P

PostgreSQL MCP Server

Verified

Read-only SQL access to PostgreSQL databases for AI agents.

open-source 82/100 Databases & Data database sql postgres postgresql read-only

A Model Context Protocol server that provides read-only access to PostgreSQL databases. Allows AI agents to inspect database schemas and execute read-only SQL queries, enabling data exploration and analysis without risk of data modification.

Supports schema inspection, table listing, and arbitrary SELECT queries with parameterized inputs.

Install

npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydb

MCP Client Config

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    }
  }
}

Capabilities

Tools

query

Resources

schema

Compatible With

Claude Desktop Claude Code Cursor Windsurf Continue

Metrics

18,500

GitHub Stars

45,200

Installs

3,100

Weekly

12

Open Issues

View Repository By Model Context Protocol

More in Databases & Data

Best of Databases & Data →
S

SQLite MCP Server

Query and analyze SQLite databases with built-in business intelligence.

open-source 80/100 Databases & Data
N

Neon MCP Server

Manage Neon serverless Postgres databases from AI agents.

open-source 78/100 Databases & Data
M

MongoDB MCP Server

Connect AI agents to MongoDB for document queries and collection management.

open-source 75/100 Databases & Data