PostgreSQL
activeConnects an agent to a PostgreSQL database: local, Docker, managed Postgres on RDS, Neon and Supabase, or a database that is only reachable through an SSH bastion. **Reaches the database you actually have.** Built-in SSH tunneling with a pinned host key, and eight named failure codes that say which phase broke. One `DATABASE_URL` is the whole setup. **Sees the whole database.** `list_schemas`, plus a schema argument on `list_tables` and `describe_table`, so it is not stuck in `public`. **Tells you what broke.** Failures come back carrying the SQLSTATE or SSH code with a hint, so the agent corrects itself instead of retrying blindly. **Respects the context window.** Results carry a byte budget with an explicit `truncated` flag, so a large table does not flood the model. **Writes are off by default**, and refused by PostgreSQL itself rather than by a client-side SQL filter: every read runs inside a `BEGIN READ ONLY` transaction, so the rule survives views, rules and functions. Turn them on with `PG_ALLOW_WRITE=true`. MIT, four runtime dependencies, Node 20 or newer. Also on npm as `mcp-postgres-server` and in the official MCP Registry as `io.github.antonorlov/mcp-postgres-server`.
Code-only MCP server: no hosted endpoint, so you install and run it yourself. It is not probed, graded or counted in our reachability statistics.
Get it
- Package
- smithery: antonorlov/mcp-postgres-server
- Run (stdio)
npx -y @smithery/cli install antonorlov/mcp-postgres-serverThe usual command for this package registry; check the repository README for required settings.- License
- not declared
- Last update
- 2026-09-16
Adoption signals
Public signals from outside this directory, shown for context. They do not change search order or grades.
Listed in
- smithery · source
Run this server as a hosted endpoint? Submit the endpoint and it moves to the remote directory, where it is probed and graded.