UNCLAIMED PROFILE
DatabaseFree31K+ installs

PostgreSQL MCP Server

Read-only PostgreSQL database query interface for AI assistants

by Anthropic|MIT License|Updated 2025-01-18

PostgreSQL MCP Server lets AI models run read-only SQL queries against your PostgreSQL database. It provides safe schema inspection, data exploration, and analytical queries without risking data modification. Perfect for debugging database issues, generating reports, or understanding complex schema relationships through natural language.

PostgreSQL MCP Server Configuration

claude_desktop_config.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:password@localhost:5432/mydb"
      ]
    }
  }
}
Ad Space

How to setup PostgreSQL MCP Server?

  1. 1

    Ensure you have a running PostgreSQL database instance (local or remote).

  2. 2

    Get your database connection string in postgresql:// format.

  3. 3

    For security, create a read-only database user: CREATE ROLE mcp_readonly WITH LOGIN PASSWORD 'your_password'; GRANT CONNECT ON DATABASE mydb TO mcp_readonly; GRANT USAGE ON SCHEMA public TO mcp_readonly; GRANT SELECT ON ALL TABLES IN SCHEMA public TO mcp_readonly;

  4. 4

    Add the configuration with your connection string to Claude Desktop config.

  5. 5

    Restart Claude Desktop and test by asking it to list tables or describe a schema.

Is PostgreSQL MCP Server free?

Yes, it is free and open-source under MIT license. It works with any PostgreSQL database regardless of the hosting provider.

How to setup PostgreSQL MCP Server?

Get your PostgreSQL connection string, optionally create a read-only user for safety, add the config to Claude Desktop with your connection string, and restart. No additional software needed beyond Node.js.

Can PostgreSQL MCP Server write data?

By design, the official server is read-only to prevent accidental data modification. It only executes SELECT queries and schema inspection commands. For write operations, you would need a custom implementation.

PostgreSQL MCP Server vs Competitors

FeaturePostgreSQL MCP ServerCompetitor
Read-Only Safety✅ Yes❌ No
Schema Inspection✅ Yes✅ Yes
Connection Pooling✅ Yes❌ No
SSL Support✅ Yes✅ Yes
Multiple Databases❌ No✅ Yes

Tags

postgresqldatabasesqlqueryanalytics
Ad Space

Are you the developer?

Claim this profile to update data, add documentation, view lead analytics, and control your tool's listing on MCPIndex.

GitHubNPM