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 & Databasesstdiolocal 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 claude_desktop_config.json

claude_desktop_config.json

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

Paste under mcpServers in your config, then restart Claude Desktop. For Claude Code, reference this server in your project's CLAUDE.md.

PostgreSQL

Install one command

Tools exposed 5 tools

Configuration claude_desktop_config.json

Similar servers