PostgreSQL MCP server: connect PostgreSQL to Claude, ChatGPT, Cursor and Claude Code. Hosted remote MCP for schemas, tables, SQL and database health.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http postgresql-by-insightfulpipe https://postgresql.insightfulmcp.com/~/.codex/config.toml
[mcp_servers.postgresql-by-insightfulpipe]
url = "https://postgresql.insightfulmcp.com/"
# codex mcp add postgresql-by-insightfulpipe --url https://postgresql.insightfulmcp.com/~/.cursor/mcp.json
{
"mcpServers": {
"postgresql-by-insightfulpipe": {
"url": "https://postgresql.insightfulmcp.com/"
}
}
}.vscode/mcp.json
{
"servers": {
"postgresql-by-insightfulpipe": {
"type": "http",
"url": "https://postgresql.insightfulmcp.com/"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"postgresql-by-insightfulpipe": {
"httpUrl": "https://postgresql.insightfulmcp.com/"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"postgresql-by-insightfulpipe": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://postgresql.insightfulmcp.com/"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"postgresql-by-insightfulpipe": {
"url": "https://postgresql.insightfulmcp.com/"
}
}
}