mcp-postgresql
A production-oriented MCP server for PostgreSQL that exposes database operations like query execution, schema introspection, and table metadata to MCP clients such as Claude Desktop and VS Code.
Databases
npm 0 platforms
0 features
Install
npx -y mcp-postgresql
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"mcp-postgresql": {
"command": "npx",
"args": [
"-y",
"mcp-postgresql"
],
"env": {
"PGSSL": "<PGSSL>",
"PGHOST": "<PGHOST>",
"PGPORT": "<PGPORT>",
"PGUSER": "<PGUSER>",
"PGDATABASE": "<PGDATABASE>",
"PGPASSWORD": "<PGPASSWORD>",
"PGPOOL_MAX": "<PGPOOL_MAX>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
Sources: public MCP Server directories. This is an independent third-party directory with no affiliation to or endorsement from the maintainers of the listed servers.
