sushilparjapat/postgres-mcp-server

3.2

If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Postgres MCP Pro is an open source Model Context Protocol (MCP) server designed to support AI agents throughout the development process, offering features like index tuning, explain plans, health checks, and safe SQL execution.

Comments

No comments yet. Be the first to comment!

Author

sushilparjapat

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/sushilparjapat/postgres-mcp-server

License

MIT License

Last publish date

2025-06-16

Last update date

2025-06-16

Server configs

in claude desktop

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

via pip in claude desktop

{
  "mcpServers": {
    "postgres": {
      "command": "postgres-mcp",
      "args": [
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

in cursor

{
    "mcpServers": {
        "postgres": {
            "type": "sse",
            "url": "http://localhost:8000/sse"
        }
    }
}

in windsurf

{
    "mcpServers": {
        "postgres": {
            "type": "sse",
            "serverUrl": "http://localhost:8000/sse"
        }
    }
}