mcpbeat Sign in

PostgreSQL MCP Server

local only

PostgreSQL MCP Server runs on your own machine — the client starts it, so there is no endpoint to ping. 2 146 installs a week from npm. Last commit 31 Oct 2026.

PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

Installs per day peak 884 · avg 254 · +228% w/w
a month agotoday
2 146
Installs / week
npm · @yawlabs/postgres-mcp
10
Stars
0 open issues
31 Oct 2026
Last commit
23 releases in 90 days
MIT
License
TypeScript

What the code does

We read the source, 1 d ago · rules 995398eba69f

Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

    const out = execFileSync(cmd, ["--version"], {
Touches key and credential files release.sh:821
  If the error was E401 or E404, the automation token in ~/.npmrc is dead.

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

This code can reach further than it looks

We found places where it runs commands, builds paths or queries from values it is given. None of that is a flaw by itself — it becomes one when the code changes, and code changes quietly between releases. We re-read it on every one.

Three servers free · no card

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.

run in your terminal
claude mcp add postgres-mcp -- npx -y @yawlabs/postgres-mcp
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}
~/.codex/config.toml
[mcp_servers.postgres-mcp]
command = "npx"
args = ["-y", "@yawlabs/postgres-mcp"]
.cursor/mcp.json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}

Alternatives to PostgreSQL MCP Server

same job, measured the same way
Snowflake MCP Server
by nsphung

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

194 installs/wk local only
DBeast PostgreSQL MCP
by snss10

PostgreSQL MCP server for schema, query, health, security, and performance analysis.

local only
PostgreSQL MCP Server
by musaddiq-dev

Python MCP server for PostgreSQL database inspection and querying

104 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 ofershap

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

42 installs/wk local only
SqlServerMcp
by nithish1206

MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis

local only
Sezzlee PostgreSQL
by sezzlee

Explore and query PostgreSQL read-only: catalogue search, schema introspection and bounded queries.

34 installs/wk local only
Elekto MCP for SQL Server
by elekto-com-br

Read-only SQL Server introspection and querying: schema, definitions, dependencies and data.

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 npm package @yawlabs/postgres-mcp was installed 2 146 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 @yawlabs/postgres-mcp straight from npm; nothing to host, nothing to sign up for.
How many people use PostgreSQL MCP Server?
The npm package @yawlabs/postgres-mcp was installed 2 146 times in the last week. Week over week that is +228%. 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 TypeScript and 10 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.