Postgres MCP
PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only…
- Pricing
- Open source
- Runs
- Locally
- Version
- 1.7.0
- Listing updated
- 4 days ago
About Postgres MCP
Postgres MCP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.
Install
Run in a terminal
claude mcp add postgres-mcp -- npx -y @edelciomolina/postgres-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"postgres-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
]
}
}
}Configuration
MCP_KEY_HOSTName of the .env variable that holds the database hostMCP_KEY_PORTName of the .env variable that holds the database portMCP_KEY_NAMEName of the .env variable that holds the database nameMCP_KEY_USERName of the .env variable that holds the database userMCP_KEY_PASSName of the .env variable that holds the database passwordMCP_KEY_SSLMODEName of the .env variable that holds the SSL mode (e.g. require)
Pricing
Open source
Postgres MCP FAQ
Is Postgres MCP free?
Yes. Postgres MCP is open source, so you can use and self-host it for free.
How do I add Postgres MCP to Claude Code?
Run this command in your terminal: claude mcp add postgres-mcp -- npx -y @edelciomolina/postgres-mcp
What are the best alternatives to Postgres MCP?
The closest alternatives to Postgres MCP are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.
Alternatives to Postgres MCP

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

PlatypusDB
MCP serverGives MCP clients access to your PlatypusDB database connections, scoped per agent
Runs locally- Open source
- Databases

Lorebase
MCP serverLets agents read and change a governed, versioned Postgres knowledge graph
Runs locally- Open source
- Knowledge and memory
Sovaria
MCP serverManage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant
Not checked yet- 4 tools
- Remote
- Freemium
- Databases

model2data studio
MCP serverGenerate realistic connected test data, dbt projects and dashboards from a schema
- Remote
- Freemium
- Databases

semlayer
MCP serverInfers a semantic layer from your data warehouse and serves it to agents
Runs locally- Free
- Databases