📋 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 Analytics & Read-Replica Inspector MCP (mcp-postgres)** (`mcp-postgres`) is a verified **STDIO** Model Context Protocol (MCP) server curated with **@simonw** for Grok Bot, Claude Code, and Cursor. Zero-mutation PostgreSQL read-replica MCP server enforcing `SET TRANSACTION READ ONLY` on every query for safe executive BI, cohort analysis, and schema exploration. ### 1-Click CLI Installation Run the command below to register `mcp-postgres` in Claude Code or your MCP client: ```bash claude mcp add mcp-postgres -- npx -y @modelcontextprotocol/server-postgres $READONLY_DATABASE_URL ``` ### Standard `mcpServers` JSON Configuration (`.cursor/mcp.json` / `claude_desktop_config.json`) ```json { "mcpServers": { "mcp-postgres": { "command": "npx", "args": [ "-y", "@modelcontextprotocol/server-postgres", "$READONLY_DATABASE_URL" ], "env": { "READONLY_DATABASE_URL": "postgresql://readonly_user:pass@host:5432/prod" } } } } ``` ### Exposed MCP Tools - `run_readonly_sql` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-postgres`. - `list_schemas` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-postgres`. - `inspect_foreign_keys` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-postgres`. - `sample_table_rows` — Deterministic JSON-RPC 2.0 tool exposed by `mcp-postgres`. ### Authentication & Environment Variables - **Transport Protocol:** `stdio` - **Auth Mechanism:** `connection_string` - `READONLY_DATABASE_URL`: `postgresql://readonly_user:pass@host:5432/prod` - **Documentation / Source:** [https://github.com/modelcontextprotocol/servers](https://github.com/modelcontextprotocol/servers)

Tags: #mcp-postgres#stdio#engineering#mcp-server#run-readonly-sql#list-schemas

View All 16 Items by @simonw →

mcp · ⚡ 80

PostgreSQL Read/Write & Schema Introspection MCP Server

Connect AI agents directly to PostgreSQL databases for live table schema inspection, `EXPLAIN ANALYZE` query benchmarking, and safe read-only or transactio

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 · ⚡ 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.