PostgreSQL MCP Server
Python MCP server for PostgreSQL database inspection and querying
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.1.2
- Listing updated
- 4 days ago
About PostgreSQL MCP Server
PostgreSQL MCP Server is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
Install
Run in a terminal
claude mcp add postgresql-mcp-server --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-serverAdd to claude_desktop_config.json
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"postgresql-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>"
}
}
}
}Configuration
POSTGRES_HOSTPostgreSQL hostRequiredPOSTGRES_PORTPostgreSQL portRequiredPOSTGRES_USERPostgreSQL usernameRequiredPOSTGRES_PASSWORDPostgreSQL passwordPOSTGRES_DBPostgreSQL database nameRequiredPOSTGRES_READ_QUERY_LIMITMaximum rows returned by read queries
Pricing
Open source
PostgreSQL MCP Server FAQ
Is PostgreSQL MCP Server free?
Yes. PostgreSQL MCP Server is open source, so you can use and self-host it for free.
How do I add PostgreSQL MCP Server to Claude Code?
Run this command in your terminal: claude mcp add postgresql-mcp-server --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server
What are the best alternatives to PostgreSQL MCP Server?
The closest alternatives to PostgreSQL MCP Server are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.
Alternatives to PostgreSQL MCP Server

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