Home/Directory/Data & Databases/PostgreSQL

PostgreSQL

@modelcontextprotocol · github.com/modelcontextprotocol/servers

Read-only SQL access with schema introspection. Inspect tables, run queries, and explain plans safely.

Anthropic OfficialData & DatabasesstdioToolslocal auth

GitHub

Install one command

terminal

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

Or add it with the Claude CLI: claude mcp add postgres

Tools exposed 5 tools

query

list_schemas

list_tables

describe_table

explain_query

Configuration generate & copy

DATABASE_URL

Values are filled in locally in your browser — nothing is sent anywhere.

claude_desktop_config.json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"],
      "env": {
        "DATABASE_URL": "<your-database-url>"
      }
    }
  }
}

Paste the Claude Desktop snippet under mcpServers in your config, then restart Claude Desktop — or run the Claude Code command in your terminal.

PostgreSQL

Install one command

Tools exposed 5 tools

Configuration generate & copy

Similar servers