Read Only Local Postgres Mcp Server

This server connects Claude to PostgreSQL databases with read-only access, exposing a connect tool that accepts standard Postgres connection strings and a query tool limited to SELECT statements. You get JSON-formatted results and can switch between databases at runtime without restarting Claude. The security model is straightforward: query validation blocks anything that isn't a SELECT, so you can safely point it at production databases for analysis work. Useful when you want to explore schemas, run analytics queries, or debug data issues through natural language without writing SQL directly. Works via npx for quick setup or manual installation if you need more control over the Node runtime.