PostgreSQL
Read-only Postgres access — schema introspection and SQL queries.
Install
Add this command to your MCP client config to connect PostgreSQL.
npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydbAbout PostgreSQL
The Postgres server connects to a PostgreSQL database (or any libpq-compatible target) and exposes schema introspection plus read-only query execution.
It deliberately limits writes by default. The intended workflow is: the assistant explores tables, indexes, and constraints; reasons about a query; and runs SELECTs to validate. For writes, you typically pair it with a migration tool or run statements through your application code.
Use it for ad-hoc analytics, "explain this slow query" sessions, and onboarding new engineers to an unfamiliar schema.
Tags
Related servers
Other MCP servers in Data and beyond.
SQLite
Anthropic
Query and mutate SQLite databases from your AI client.
Supabase
Supabase
Manage Supabase projects: schema, data, edge functions, and auth.
Filesystem
Anthropic
Read, write, and search local files with sandboxed directory access.
Slack
Anthropic
Read channels, post messages, and search history in a Slack workspace.
Fetch
Anthropic
Fetch a URL and return clean Markdown — the canonical web-reading tool.
GitHub
GitHub
Issues, PRs, code search, and repository operations across GitHub.