Postgres MCP server

Read from the package source without running it. The installed server may list more.

• pg-awr

  Generate a PostgreSQL performance report similar to Oracle AWR. Includes database statistics, top queries (requires pg_stat_statements extension), table/index statistics, connection info, and optimization recommendations.

• pg-connect

  Provides an interface to connect to a specified PostgreSQL database. If a database connection is already active, the tool will close the existing connection before establishing a new one. This tool accepts three required parameters: \tconnectionString: The PostgreSQL connection string without embedded credentials (e.g., postgresql://host:port/dbname or host:port/dbname). To enable encryption (SSL)

• pg-explain

  Generate and display the execution plan for a given SQL query using PostgreSQL's EXPLAIN command. This tool helps you understand how PostgreSQL will execute your query, including information about table scans, joins, indexes used, and estimated costs. Args: \tsql: The SQL query to explain. The `model` argument should specify only the name and version of the LLM (Large Language Model) you are using

• pg-querywrite action

  This tool executes SQL queries in a READ ONLY session connected to a PostgreSQL database. If no active connection exists, it uses MCP server registration argument and environment variables PG_USER and PG_PASSWORD. You should: \tExecute the provided SQL query. \tReturn the results in Toon format. Args: \tsql: The SQL query to execute. The `model` argument should specify only the name and version of

• pg-stats

  Get comprehensive statistics for a specific PostgreSQL table. This tool retrieves detailed information including row counts, table size, index information, column statistics, and other metadata that can help optimize queries and understand data distribution. Args: \tname: The name of the table to get statistics for. The `model` argument should specify only the name and version of the LLM (Large La

• Code scan12 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitystatic API keys via environment variables6/15
• Maintenancelast push 38 days ago12/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Safety score

78/100

higher than 47% of 802 Databases servers

Tools

5

the typical Databases server has 8

Tools that change things

20%

typical: 10%. Fewer write tools means less an agent can break

GitHub stars

2

more than 60% of 601 Databases servers

Downloads a week

30

more than 17% of 324 Databases servers with a package

Postgres: common questions

Is Postgres MCP server safe?

Mostly: it is graded B (78/100). Read the Postgres safety report

How do I install Postgres?

It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.

Does Postgres need an API key?

Yes. The registry entry asks for POSTGRES_PASSWORD.

Is Postgres maintained?

The last commit was 73 days ago (2026-08-21). The latest release is v1.0.8.

What can I use instead of Postgres?

Servers from other publishers that do the same job: DBHub MCP server, Appwrite MCP server and Faucet MCP server.

How does Postgres compare with other Databases MCP servers?

safety score 78/100 (higher than 47% of 802 Databases servers); tools 5 (the typical Databases server has 8); tools that change things 20% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.