Python MCP server for PostgreSQL database inspection and querying
Connect Runs on your machine
claude mcp add postgresql-mcp-server -e POSTGRES_HOST=<POSTGRES_HOST> -e POSTGRES_PORT=<POSTGRES_PORT> -e POSTGRES_USER=<POSTGRES_USER> -e POSTGRES_PASSWORD=<POSTGRES_PASSWORD> -e POSTGRES_DB=<POSTGRES_DB> -e POSTGRES_READ_QUERY_LIMIT=<POSTGRES_READ_QUERY_LIMIT> -- uvx mdev-postgresql-mcp-server==0.1.2{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}{
"servers": {
"postgresql-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
POSTGRES_HOSTRequired | PostgreSQL host |
POSTGRES_PORTRequired | PostgreSQL port |
POSTGRES_USERRequired | PostgreSQL username |
POSTGRES_PASSWORDOptional, secret | PostgreSQL password |
POSTGRES_DBRequired | PostgreSQL database name |
POSTGRES_READ_QUERY_LIMITOptional | Maximum rows returned by read queries |
Details
| Package | [email protected] (PYPI, stdio) |
| First published | 23 May 2026 |
| Last updated | 23 May 2026 |
| Registry name | io.github.musaddiq-dev/postgresql-mcp-server |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.