Postgres MCP server
ofershap/mcp-server-postgres · typescript · MIT
PostgreSQL MCP — query databases, inspect schemas, explain queries.
Also known as ofershap/mcp-server-postgres, mcp-server-postgres, mcp-pg-server
- Stars
- 0
- Tools
- —
- Downloads, 30 days
- —
- Latest version
- 1.0.0
- Last commit
- Aug 12, 2026
- License
- MIT
What is Postgres MCP?
Postgres is an MCP server. PostgreSQL MCP — query databases, inspect schemas, explain queries.
How to install Postgres MCP
Formats verified 10 Nov 2026Add to CursorAdd to GooseInstall Postgres MCP in Claude Code
$ claude mcp add mcp-server-postgres -- npx -y mcp-pg-serverInstall Postgres MCP in Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"mcp-server-postgres": {
"command": "npx",
"args": [
"-y",
"mcp-pg-server"
]
}
}
}Install Postgres MCP in VS Code
.vscode/mcp.json
{
"servers": {
"mcp-server-postgres": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-pg-server"
]
}
}
}Install Postgres MCP in VS Code CLI
$ code --add-mcp '{"name":"mcp-server-postgres","type":"stdio","command":"npx","args":["-y","mcp-pg-server"]}'Install Postgres MCP in Claude Desktop
claude_desktop_config.json
{
"mcpServers": {
"mcp-server-postgres": {
"command": "npx",
"args": [
"-y",
"mcp-pg-server"
]
}
}
}Install Postgres MCP in Codex
$ codex mcp add mcp-server-postgres -- npx -y mcp-pg-serverInstall Postgres MCP in Codex config.toml
~/.codex/config.toml
[mcp_servers.mcp-server-postgres] command = "npx" args = ["-y", "mcp-pg-server"]
Install Postgres MCP in Gemini CLI
$ gemini mcp add -s user mcp-server-postgres npx -- -y mcp-pg-serverInstall Postgres MCP in Gemini settings.json
~/.gemini/settings.json
{
"mcpServers": {
"mcp-server-postgres": {
"command": "npx",
"args": [
"-y",
"mcp-pg-server"
]
}
}
}No environment variables or API keys required.Setup guides:Claude CodeCursorVS CodeClaude Desktop
Postgres MCP questions
How do I add Postgres MCP to Claude Code?
Run claude mcp add mcp-server-postgres -- npx -y mcp-pg-server in your terminal. Add --scope user to make it available in every project.
How do I add Postgres MCP to Cursor?
Open ~/.cursor/mcp.json and add the server under mcpServers, using the Cursor config shown in the install section above.