P

PostgreSQL MCP Server

Verified

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

open-source 93/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

84,186

GitHub Stars

1,605,767

Installs

76,023

Weekly

353

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 85/100 Databases & Data
M

MongoDB MCP Server

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

open-source 85/100 Databases & Data
R

Redis MCP Server

Connect AI agents to Redis for key-value operations and caching.

open-source 59/100 Databases & Data