readonly-postgres-mcp
Readonly PostgreSQL MCP server with SQL guardrails for analytical queries and schema introspection.
Databases
npm 0 platforms
0 features
Install
npx -y readonly-postgres-mcp
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"readonly-postgres-mcp": {
"command": "npx",
"args": [
"-y",
"readonly-postgres-mcp"
],
"env": {
"PG_SSL": "<PG_SSL>",
"PG_HOST": "<PG_HOST>",
"PG_PORT": "<PG_PORT>",
"PG_DATABASE": "<PG_DATABASE>",
"PG_MAX_ROWS": "<PG_MAX_ROWS>",
"PG_PASSWORD": "<PG_PASSWORD>",
"PG_USERNAME": "<PG_USERNAME>",
"PG_SEARCH_PATH": "<PG_SEARCH_PATH>"
}
}
}
}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.
