Postgres Mcp
PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants
- Transport
- Not stated
- Package
- —
- Registry id
- io.github.YawLabs/postgres-mcp
No install snippet on purpose. A working MCP config is a command, its arguments and an environment block — the last two are where API keys live, so this catalogue never stores them and cannot publish them. Follow the link above for the authors' own instructions.
User SQL runs inside a BEGIN READ ONLY transaction by default, blocking writes to the database; writes only become possible when ALLOW_WRITES=1 is set. It is read-only by default, with writes opt-in via a single environment variable, so an agent cannot silently drop tables. The server sends all user SQL over the extended query protocol, restricting each request to a single statement and closing the stacked-query injection class found in the deprecated reference server.
It is licensed under the MIT license and published on npm. The server is intended for anyone pointing an agent at a Postgres database and wanting it to be a daily driver rather than a demo.
Summary drafted from the project's own website. Every sentence is backed by text on that page and was reviewed before publishing.