Postgres MCP Server: Install & Setup

Install Postgres in Claude Code

Claude Code

claude mcp add ofershap-postgres -- npx -y mcp-pg-server

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "ofershap-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-pg-server"
      ]
    }
  }
}

Frequently asked questions

What does the Postgres MCP server do?

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

Is the Postgres MCP server free?

Yes, most likely. Open source and no paid account or API key is mentioned in the listing. Check the provider for current pricing.

Does Postgres run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add Postgres to Claude Code?

Run: claude mcp add ofershap-postgres -- npx -y mcp-pg-server

More databases MCP servers

View all

Nhost

9.4k

nhost/nhost/cli

Official Nhost MCP server, bundled with the Nhost CLI. Lets AI coding assistants read your GraphQL schema, run the queries and mutations you allow, manage permissions and migrations, update Nhost Cloud project config, and search the docs.

LocalFreeGo

DBHub

3.8k

bytebase/dbhub

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

LocalFree

Postgres

3.4k

crystaldba/postgres-mcp

Postgres development and operations: performance analysis, tuning and health checks.

LocalFreePython

LINQ to DB

3.3k

linq2db/linq2db

Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB.

LocalFree

Mindwtr

2.4k1.7k

dongdongbh/Mindwtr

Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default.

LocalFree

Mysql

2.2k

benborla/mcp-server-mysql

MySQL database integration with configurable access controls and schema inspection.

LocalAccount needed