PostgreSQL MCP Server MCP Server
io.github.musaddiq-dev/postgresql-mcp-server
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the PostgreSQL MCP Server MCP server?
Python MCP server for PostgreSQL database inspection and querying
How to install PostgreSQL MCP Server
Copy-paste configuration for popular MCP clients.
POSTGRES_HOSTrequiredPostgreSQL host
POSTGRES_PORTrequiredPostgreSQL port
POSTGRES_USERrequiredPostgreSQL username
POSTGRES_PASSWORDsecretPostgreSQL password
POSTGRES_DBrequiredPostgreSQL database name
POSTGRES_READ_QUERY_LIMITMaximum rows returned by read queries
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<YOUR_POSTGRES_HOST>",
"POSTGRES_PORT": "<YOUR_POSTGRES_PORT>",
"POSTGRES_USER": "<YOUR_POSTGRES_USER>",
"POSTGRES_PASSWORD": "<YOUR_POSTGRES_PASSWORD>",
"POSTGRES_DB": "<YOUR_POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<YOUR_POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}Related MCP servers

AWS CLI MCP Server
Python MCP server for AWS CLI inspection and operations

MySQL MCP Server
Python MCP server for MySQL database inspection and querying

Data Aggregator
Find & fetch research datasets across 17 archives, omics registries, and literature sources.

phylokit-mcp
Phylogenetic inference via IQ-TREE 3 — never returns a topology without its support

Deoochform
Create forms, read submissions, and build invitations from Claude, ChatGPT, or any MCP client.

io.github.musepy/genable-mcp
Write to Figma from any MCP client (Claude Code, Cursor). Complements the read-only official MCP.