PostgreSQL MCP Server
io.github.musaddiq-dev/postgresql-mcp-server ยท version 0.1.2
Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.
Python MCP server for PostgreSQL database inspection and querying
https://github.com/musaddiq-dev/postgresql-mcp-serverQuick facts
- Listing: Community
- Published May 23, 06:27 UTC
- Transport: stdio
- Package: pypi
mdev-postgresql-mcp-server0.1.2 - Listed by cosmic-mcp: Nov 8, 19:00 UTC
Details
- Repository: https://github.com/musaddiq-dev/postgresql-mcp-server
- PyPI: https://pypi.org/project/mdev-postgresql-mcp-server/
- Needs settings:
POSTGRES_HOSTPOSTGRES_PORTPOSTGRES_USERPOSTGRES_PASSWORDPOSTGRES_DBPOSTGRES_READ_QUERY_LIMIT
Setup snippets
Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.
Run it locally (pypi)
uvx 'mdev-postgresql-mcp-server==0.1.2'Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"postgresql-mcp-server": {
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"command": "uvx",
"env": {
"POSTGRES_DB": "<your postgres db>",
"POSTGRES_HOST": "<your postgres host>",
"POSTGRES_PASSWORD": "<your postgres password>",
"POSTGRES_PORT": "<your postgres port>",
"POSTGRES_READ_QUERY_LIMIT": "<your postgres read query limit>",
"POSTGRES_USER": "<your postgres user>"
}
}
}
}Claude Code
claude mcp add 'postgresql-mcp-server' -- uvx 'mdev-postgresql-mcp-server==0.1.2'Cursor (.cursor/mcp.json)
{
"mcpServers": {
"postgresql-mcp-server": {
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"command": "uvx",
"env": {
"POSTGRES_DB": "<your postgres db>",
"POSTGRES_HOST": "<your postgres host>",
"POSTGRES_PASSWORD": "<your postgres password>",
"POSTGRES_PORT": "<your postgres port>",
"POSTGRES_READ_QUERY_LIMIT": "<your postgres read query limit>",
"POSTGRES_USER": "<your postgres user>"
}
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"postgresql-mcp-server": {
"args": [
"mdev-postgresql-mcp-server==0.1.2"
],
"command": "uvx",
"env": {
"POSTGRES_DB": "<your postgres db>",
"POSTGRES_HOST": "<your postgres host>",
"POSTGRES_PASSWORD": "<your postgres password>",
"POSTGRES_PORT": "<your postgres port>",
"POSTGRES_READ_QUERY_LIMIT": "<your postgres read query limit>",
"POSTGRES_USER": "<your postgres user>"
},
"type": "stdio"
}
}
}Related servers
- AI for Database Verified domain
Ask your databases questions in plain English, run read-only SQL and set up data alerts. - AI2SQL Verified domain
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema - AICasePredict Verified domain
Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts. - APC Security Reference Server
Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin... - AdoMcp
Database MCP server for schema discovery, comments, and SQL queries. - Agent Swarm
Full Agent Swarm API and MCP server with local SQLite storage for multi-agent orchestration.