PostgreSQL MCP Server

by musaddiq-dev Your server? Claim it

local only

PostgreSQL MCP Server runs on your own machine — the client starts it, so there is no endpoint to ping. 104 installs a week from pypi. Last commit 23 May 2026.

Python MCP server for PostgreSQL database inspection and querying

Installs per day peak 3 468 · avg 134 · -97% w/w

a month agotoday

104

Installs / week

pypi · mdev-postgresql-mcp-server

Stars

0 open issues

23 May 2026

Last commit

from GitHub

MIT

License

Python

Nothing serious here today

Today is the operative word: we check PostgreSQL MCP Server every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add postgresql-mcp-server -e 'POSTGRES_HOST=<POSTGRES_HOST>' -e 'POSTGRES_PORT=<POSTGRES_PORT>' -e 'POSTGRES_USER=<POSTGRES_USER>' -e 'POSTGRES_DB=<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_DB": "<POSTGRES_DB>",
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>"
      }
    }
  }
}

~/.codex/config.toml

[mcp_servers.postgresql-mcp-server]
command = "uvx"
args = ["mdev-postgresql-mcp-server"]
env = { POSTGRES_HOST = "<POSTGRES_HOST>", POSTGRES_PORT = "<POSTGRES_PORT>", POSTGRES_USER = "<POSTGRES_USER>", POSTGRES_DB = "<POSTGRES_DB>" }

.cursor/mcp.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_DB": "<POSTGRES_DB>",
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "postgresql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_DB": "<POSTGRES_DB>",
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>"
      }
    }
  }
}

Put your own values in place of <POSTGRES_HOST> (PostgreSQL host), <POSTGRES_PORT> (PostgreSQL port), <POSTGRES_USER> (PostgreSQL username), <POSTGRES_DB> (PostgreSQL database name). The author’s registry entry marks them as required.

Optional settings from the registry entry, left out of the block above: POSTGRES_PASSWORD (PostgreSQL password), POSTGRES_READ_QUERY_LIMIT (Maximum rows returned by read queries).

Alternatives to PostgreSQL MCP Server

same job, measured the same way

MySQL MCP Server

by musaddiq-dev

Python MCP server for MySQL database inspection and querying

104 installs/wk local only

Postgres Connector

by martymarkenson

MCP server for querying PostgreSQL databases

56 installs/wk local only

Database Admin

by cybeleri

Database admin MCP: schema inspection, query optimization for PostgreSQL and MySQL

43 installs/wk local only

Postgres

by marcelo-ochoa

MCP server for interacting with PostgreSQL databases

105 installs/wk local only

DB Connect MCP

by yugui923

Multi-database MCP server for PostgreSQL, MySQL, and ClickHouse

667 installs/wk local only

Read Only Local Postgres MCP Server

by hove

MCP server for read-only PostgreSQL database queries in Claude Desktop

143 installs/wk local only

Postgres

by ofershap

PostgreSQL MCP — query databases, inspect schemas, explain queries.

42 installs/wk local only

Dbmcp

by haymon

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention

local only

PostgreSQL MCP Server — questions

Answers built from our own checks of this server.

Why is there no uptime for PostgreSQL MCP Server?

PostgreSQL MCP Server runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package mdev-postgresql-mcp-server was installed 104 times last week.

How do I connect PostgreSQL MCP Server?

Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It runs locally, so the command pulls mdev-postgresql-mcp-server straight from pypi; nothing to host, nothing to sign up for.

How many people use PostgreSQL MCP Server?

The pypi package mdev-postgresql-mcp-server was installed 104 times in the last week. Week over week that is -97%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is PostgreSQL MCP Server open source?

Yes — it is published under the MIT licence, written in Python and 1 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.