Postgres

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

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

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

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Capabilities & Tool Schemas (5)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by Postgres.

query

Execute SQL (SELECT, WITH, EXPLAIN, SHOW, ANALYZE). Returns a text table.

schema

Tables in a schema (default `public`) with columns and approximate row counts

table_info

One table: columns, types, null/default, PK, exact row count

explain

EXPLAIN (FORMAT TEXT), optional ANALYZE

list_schemas

List non-system schemas

Documentation Overview

mcp-server-postgres

Query PostgreSQL, inspect schemas, and explain queries from your AI assistant. A daily-driver MCP for local and dev Postgres — same belt as docker and sqlite servers, not an enterprise DBA suite.

bash

DATABASE_URL=postgres://user:pass@localhost:5432/mydb npx mcp-pg-server

Works with Claude Desktop, Cursor, VS Code Copilot, and any MCP client. Connects via DATABASE_URL or per-call connectionString.

Why

Postgres is the default for most new backends, local dev stacks, and agent workflows that need a real SQL database. You already run it in Docker or on localhost — this server lets your assistant query it, read schemas, and explain plans without leaving the IDE. Read-only by default so exploration stays safe; opt into writes when you need them.

Tools

Tool	What it does
`query`	Execute SQL (SELECT, WITH, EXPLAIN, SHOW, ANALYZE). Returns a text table.
`schema`	Tables in a schema (default `public`) with columns and approximate row counts
`table_info`	One table: columns, types, null/default, PK, exact row count
`explain`	EXPLAIN (FORMAT TEXT), optional ANALYZE
`list_schemas`	List non-system schemas

Quick Start

Cursor

Add to .cursor/mcp.json:

config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["mcp-pg-server"],
      "env": {
        "DATABASE_URL": "postgres://user:pass@localhost:5432/mydb"
      }
    }
  }
}

Claude Desktop

Add to claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json):

config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["mcp-pg-server"],
      "env": {
        "DATABASE_URL": "postgres://user:pass@localhost:5432/mydb"
      }
    }
  }
}

VS Code

Configure the MCP server in your VS Code settings to run npx mcp-pg-server with DATABASE_URL set.

Example prompts

"Show me the schema of the public tables"
"Query users: SELECT * FROM users LIMIT 10"
"Explain this join query"
"What schemas exist in this database?"
"How many rows are in the orders table?"

Safety

Read-only by default. The query tool accepts only SELECT, WITH, EXPLAIN, SHOW, and ANALYZE in readonly mode. Set readonly=false to enable INSERT, UPDATE, DELETE, and DDL.

Pass connectionString on any tool to override DATABASE_URL for a single call.

Development

Terminal

npm install
npm run typecheck
npm run build
npm test
npm run format
npm run lint

Author

License

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

npm downloads

61M

Package downloads in the last 30 days.

Last commit

26d ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about Postgres

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "postgres": { "command": "npx", "args": ["-y", "postgres"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/postgres?style=directory)](https://allmcps.com/mcp/postgres)

HTML Embed

<a href="https://allmcps.com/mcp/postgres"><img src="https://allmcps.com/api/badge/postgres?style=directory" alt="Postgres on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

56Quality signal: Good · 56/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools24/30

Adoption & activity8/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

★ Spotlight Slot

Feature Your MCP Server

Get maximum visibility for your server across our directory, search results, and detail pages.

Spotlight Your Server

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge and attach your website — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to Postgres →Install in Claude Desktop Install in Cursor Install in VS Code

Postgres

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

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

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

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Capabilities & Tool Schemas (5)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by Postgres.

query

Execute SQL (SELECT, WITH, EXPLAIN, SHOW, ANALYZE). Returns a text table.

schema

Tables in a schema (default `public`) with columns and approximate row counts

table_info

One table: columns, types, null/default, PK, exact row count

explain

EXPLAIN (FORMAT TEXT), optional ANALYZE

list_schemas

List non-system schemas

Documentation Overview

mcp-server-postgres

Query PostgreSQL, inspect schemas, and explain queries from your AI assistant. A daily-driver MCP for local and dev Postgres — same belt as docker and sqlite servers, not an enterprise DBA suite.

bash

DATABASE_URL=postgres://user:pass@localhost:5432/mydb npx mcp-pg-server

Works with Claude Desktop, Cursor, VS Code Copilot, and any MCP client. Connects via DATABASE_URL or per-call connectionString.

Why

Tools

Tool	What it does
`query`	Execute SQL (SELECT, WITH, EXPLAIN, SHOW, ANALYZE). Returns a text table.
`schema`	Tables in a schema (default `public`) with columns and approximate row counts
`table_info`	One table: columns, types, null/default, PK, exact row count
`explain`	EXPLAIN (FORMAT TEXT), optional ANALYZE
`list_schemas`	List non-system schemas

Quick Start

Cursor

Add to .cursor/mcp.json:

config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["mcp-pg-server"],
      "env": {
        "DATABASE_URL": "postgres://user:pass@localhost:5432/mydb"
      }
    }
  }
}

Claude Desktop

Add to claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json):

config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["mcp-pg-server"],
      "env": {
        "DATABASE_URL": "postgres://user:pass@localhost:5432/mydb"
      }
    }
  }
}

VS Code

Configure the MCP server in your VS Code settings to run npx mcp-pg-server with DATABASE_URL set.

Example prompts

"Show me the schema of the public tables"
"Query users: SELECT * FROM users LIMIT 10"
"Explain this join query"
"What schemas exist in this database?"
"How many rows are in the orders table?"

Safety

Read-only by default. The query tool accepts only SELECT, WITH, EXPLAIN, SHOW, and ANALYZE in readonly mode. Set readonly=false to enable INSERT, UPDATE, DELETE, and DDL.

Pass connectionString on any tool to override DATABASE_URL for a single call.

Development

Terminal

npm install
npm run typecheck
npm run build
npm test
npm run format
npm run lint

Author

License

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

npm downloads

61M

Package downloads in the last 30 days.

Last commit

26d ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about Postgres

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "postgres": { "command": "npx", "args": ["-y", "postgres"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/postgres?style=directory)](https://allmcps.com/mcp/postgres)

HTML Embed

<a href="https://allmcps.com/mcp/postgres"><img src="https://allmcps.com/api/badge/postgres?style=directory" alt="Postgres on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

56Quality signal: Good · 56/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools24/30

Adoption & activity8/15

Community engagement0/10

★ Spotlight Slot

Feature Your MCP Server

Get maximum visibility for your server across our directory, search results, and detail pages.

Spotlight Your Server

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to Postgres →Install in Claude Desktop Install in Cursor Install in VS Code

Postgres

Quick Install

Client Config & Setup

Documentation Overview

mcp-server-postgres

Why

Tools

Quick Start

Cursor

Claude Desktop

VS Code

Example prompts

Safety

Development

See also

Author

License

Related MCP Servers

Adoption & maintenance

Reviews

Frequently Asked Questions about Postgres

AllMCPs Directory Badge

Technical Specs & Signals

Feature Your MCP Server

Own this project?

Share & Embed

Explore more

Postgres

Quick Install

Client Config & Setup

Documentation Overview

mcp-server-postgres

Why

Tools

Quick Start

Cursor

Claude Desktop

VS Code

Example prompts

Safety

Development

See also

Author

License

Related MCP Servers

Adoption & maintenance

Reviews

Frequently Asked Questions about Postgres

AllMCPs Directory Badge

Technical Specs & Signals

Feature Your MCP Server

Own this project?

Share & Embed

Explore more