Active

postgres-mcp

Postgres MCP Pro provides configurable read/write access and performance analysi

The Postgres MCP Server lets your AI connect directly to your PostgreSQL database — instead of writing SQL, you just tell the AI "who were the top 10 customers by revenue last month" and it queries the tables and returns the result.

For developers, this removes the back-and-forth of opening a DB client, writing SQL, and pasting results back into the AI. Once installed, your database becomes part of the AI's context.

GitHub ↗

TrustScore

✅ No clear abandonment signal detected; complete security and compatibility checks before production use

Why use it

Good for: developers and data analysts who want the AI to help explore data, generate reports, or debug production data issues.

Before connecting: your connection string holds sensitive credentials — use a read-only account for production databases. Review the maintenance signals below, then test compatibility and security in your own environment.

Before you connect

🔑 Needs an API key / tokenPythonDocker

Config example (to connect)

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

Install / Connect

# No npm package — install from source.
# See the repo's README for the exact command:
# https://github.com/crystaldba/postgres-mcp

Follow the official README; env and args vary per server.

🛠️ Maintenance weight 30% · 56 pts

📝

Last commit4 days ago

📈

Commits in 90 days1

💬

Recent issues with replies29%

🗃️

Repo statusNormal

📊 Adoption weight 25% · 62 pts

⭐

GitHub stars3.2k (90d +0%)

📦

npm weekly downloadsNot npm-distributed

🚀

Releases per month—

✅ Usability weight 20% · 20 pts

📋

Official registryNot listed

▶️

Runnable entryNot resolvable

🔍

AuditabilityOpen-source repo, auditable

❤️ Health & community weight 25% · 58 pts

🐛

open issues82

🔀

open PRs—

⚖️

LicenseMIT

👥

Contributors / forks10 / 367

Sources: GitHub API · updated 2026-08-19

90-day trend

⭐ stars +0%

Frequently Asked Questions

Will the Postgres MCP Server modify my data?

It depends on the permissions of the database account you give it. To stay safe, use a read-only account for production so the AI can only query, not change data.

Which AI clients are supported?

Claude Desktop, Claude Code, Cursor, and VS Code all work with MCP. See the installation section below for the config.

Similar / alternative servers

How to choose among these

Database servers split into relational vs. vector; vector stores are all for RAG, differing by scale and hosting.

Relational DB (business data, SQL)→Pick Supabase / Neon / MongoDB / ClickHouse — match your DB
RAG with semantic memory→Pick a vector store: Pinecone (scaled) / Qdrant / Chroma (light) / Weaviate

mcp-server-mysql

A Model Context Protocol server that provides read-only access to MySQL database

Active⭐ 2.1kupdated 23d ago

capital.hove/read-only-local-postgres-mcp-server

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

Active⭐ 2updated 47d ago

io.github.Eszetael/postgres-mcp-hardened

PostgreSQL (hardened, read-only)

Activeupdated 1d ago

io.github.ofershap/postgres

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

Activeupdated 1d ago

One email a week, 5 minutes to see what happened in the MCP ecosystem

New servers, breakout trends, abandonment alerts — tracked automatically, curated by hand, sent to your inbox.

One email a week · unsubscribe anytime · no data selling