What can you do with this server?

pg-mcp is a PostgreSQL MCP server that enables AI assistants to securely interact with PostgreSQL databases, with built-in read-only protection by default. * pg_connect: Connect to a PostgreSQL database via a connection URL or individual parameters (host, port, user, password, database), with optional SSL and read-only mode settings. * pg_disconnect: Close and clean up an existing database connection by its connection ID. * pg_query: Execute SQL queries against a connected database, with support for parameterized/prepared statements. * pg_list_schemas: List all schemas available in the connected database. * pg_get_ddl: Retrieve the complete DDL for a database (CREATE TABLE statements, indexes, constraints, foreign keys, sequences, and views), optionally filtered by schema. * Read-only mode: Enabled by default, blocking DML (INSERT, UPDATE, DELETE, TRUNCATE, MERGE) and DDL/DCL operations (CREATE, ALTER, DROP, GRANT, REVOKE). Can be explicitly disabled per connection. * Auto-connect: Automatically connects on startup if DATABASE_URL or standard libpq environment variables are set, using connection ID "default".

Which integrations are available for this server?

Enables querying of PostgreSQL databases, schema inspection, and retrieval of DDL with built-in read-only protection. It provides tools for connecting to databases, executing SQL queries, listing schemas, and fetching complete DDL structures.

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@pg-mcp list all tables in the public schema" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

pg-mcp

by shedyhs

Overview Schema Related Servers Score Discussions

TypeScript

Hybrid

pg-mcp

MCP server for PostgreSQL. Query databases, inspect schemas, backup data, and manage dumps — with built-in read-only protection.

Quick Start

npm install -g @shedyhs/pg-mcp

Add to your AI provider config:

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

With DATABASE_URL or PGHOST/PGDATABASE set, the server auto-connects as "default" on startup.

Set PG_MCP_READ_ONLY=false in env to allow write operations (read-only by default).

Related MCP server: PostgreSQL MCP Server

Tools

Tool	Description	Requires
`pg_connect`	Connect to a PostgreSQL database (URL, params, or libpq env vars)	—
`pg_disconnect`	Disconnect from a database	—
`pg_query`	Execute SQL queries with read-only protection	—
`pg_list_schemas`	List all user schemas	—
`pg_get_ddl`	Get complete DDL (tables, indexes, constraints, FKs, sequences, enums, views)	—
`pg_backup_query`	Backup specific rows as INSERT statements before destructive operations	—
`pg_dump`	Dump a database or specific tables to a file	`pg_dump` CLI
`pg_restore`	Restore a database from a dump file (custom, directory, or tar format)	`pg_restore` CLI

Where to Put the Config

Provider	Config file
Claude Desktop	`~/Library/Application Support/Claude/claude_desktop_config.json` (macOS) / `%APPDATA%\Claude\claude_desktop_config.json` (Windows)
Claude Code	`.claude/settings.json` or `~/.claude/settings.json`
Cursor	`.cursor/mcp.json`
Windsurf	`~/.codeium/windsurf/mcp_config.json`
Codex	`codex.json`

All providers above use the same JSON format from Quick Start.

GitHub Copilot (VS Code) uses a slightly different format in .vscode/mcp.json:

{
  "servers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "@shedyhs/pg-mcp"],
      "env": {
        "DATABASE_URL": "postgres://user:pass@localhost:5432/mydb"
      }
    }
  }
}

From source — replace command/args with "command": "node", "args": ["/path/to/pg-mcp/dist/index.js"].

Installing pg_dump & pg_restore

Only needed if you use pg_dump or pg_restore. All other tools work without external dependencies.

OS	Command
macOS	`brew install libpq`
Debian/Ubuntu	`sudo apt-get install postgresql-client-16`
RHEL/Fedora	`sudo dnf install postgresql16`
Windows	`winget install PostgreSQL.PostgreSQL.16`

Verify with pg_dump --version.

Installation from Source

git clone https://github.com/shedyhs/pg-mcp
cd pg-mcp
npm install && npm run build

License

MIT

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

PostgreSQL MCP Server
Databases Data Platforms Developer Tools
gldc
A
license
-
quality
D
maintenance
Enables AI agents to interact with PostgreSQL databases through the Model Context Protocol, providing database schema exploration, table structure inspection, and SQL query execution capabilities.
Last updated 2026-02-18
15
MIT
PostgreSQL MCP Server
Databases Developer Tools
gharshit
A
license
-
quality
D
maintenance
Enables AI assistants to safely interact with PostgreSQL databases through read-only operations, providing schema discovery, table inspection, and query execution capabilities with structured context awareness.
Last updated 2025-12-11
MIT
PostgreSQL MCP Server
Databases RAG Systems
abhinv98
A
license
-
quality
D
maintenance
Enables AI agents to query, explore, and analyze PostgreSQL databases through the Model Context Protocol. It provides robust security features including read-only mode, schema restrictions, and query timeouts for safe data interaction.
Last updated 2025-12-04
14
MIT
PostgreSQL MCP Server
adelhassen
F
license
-
quality
D
maintenance
Enables AI assistants to interact with PostgreSQL databases by executing SQL queries and inspecting database schemas. It provides tools to facilitate database exploration and management through the Model Context Protocol.
Last updated 2026-02-04

View all related MCP servers

Related MCP Connectors

PlainQuery | MCP DB Agent
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
nlqdb — analytical memory for AI agents
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/shedyhs/pg-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server