📋 Copy MCP Install CLI { } Inspect JSON API Ground-Truth Source ↗

⚡ 1-Click Agent & Developer Install

Zero Auth · Ready for Grok Bot, Claude Code & Cursor

### Server Architecture & Capability Summary **PostgreSQL Read/Write & Schema Introspection MCP Server** (`postgres-mcp`) is a verified **STDIO** Model Context Protocol (MCP) server curated with **@simonw** for Grok Bot, Claude Code, and Cursor. Connect AI agents directly to PostgreSQL databases for live table schema inspection, `EXPLAIN ANALYZE` query benchmarking, and safe read-only or transactional queries. ### 1-Click CLI Installation Run the command below to register `postgres-mcp` in Claude Code or your MCP client: ```bash claude mcp add postgres -- npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydb ``` ### Standard `mcpServers` JSON Configuration (`.cursor/mcp.json` / `claude_desktop_config.json`) ```json { "mcpServers": { "postgres-mcp": { "command": "npx", "args": [ "-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb" ], "env": { "DATABASE_URL": "postgresql://user:pass@host:5432/dbname" } } } } ``` ### Exposed MCP Tools - `query_sql` — Deterministic JSON-RPC 2.0 tool exposed by `postgres-mcp`. - `describe_table_schema` — Deterministic JSON-RPC 2.0 tool exposed by `postgres-mcp`. - `list_indexes` — Deterministic JSON-RPC 2.0 tool exposed by `postgres-mcp`. - `explain_query_plan` — Deterministic JSON-RPC 2.0 tool exposed by `postgres-mcp`. ### Authentication & Environment Variables - **Transport Protocol:** `stdio` - **Auth Mechanism:** `connection_string` - `DATABASE_URL`: `postgresql://user:pass@host:5432/dbname` - **Documentation / Source:** [https://github.com/modelcontextprotocol/servers](https://github.com/modelcontextprotocol/servers)

Tags: #postgres-mcp#stdio#engineering#mcp-server#query-sql#describe-table-schema

View All 16 Items by @simonw →

mcp · ⚡ 93

SQLite & Datasette Local Analytics & Schema MCP Server

Query local SQLite databases, run full-text FTS5 searches, create analytical views, and synthesize structured data memos directly from your agent workspace

mcp · ⚡ 79

PostgreSQL Analytics & Read-Replica Inspector MCP (mcp-postgres)

Zero-mutation PostgreSQL read-replica MCP server enforcing `SET TRANSACTION READ ONLY` on every query for safe executive BI, cohort analysis, and schema ex

mcp · ⚡ 92

SQLite Embedded Telemetry & Ledger MCP Server (mcp-sqlite)

Lightweight embedded SQLite MCP interface for local agent memory stores, evaluation benchmarks, and deterministic SQLite ledger auditing.