Postgres.

Drop this into your client's MCP config — claude_desktop_config.json for Claude Desktop, or .cursor/mcp.json for Cursor — then restart the app. Replace placeholder paths and credentials with your own.

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

The reference MCP server for relational data. Exposes table schemas and read-only query execution to an agent — without giving it a write seat. The standard pattern for letting an LLM 'see' your data without risking writes.

• List schemas and tables
• Read column types and constraints
• Execute read-only queries
• Connection-pooled for agent loops