JaviMaligno/postgres_mcp

Overview

A Python-based MCP server for PostgreSQL that connects to a Docker-hosted PostgreSQL instance. It was created by a user to enable MCP connectivity to a local Docker PostgreSQL database. The repository has 9 stars and is maintained by various contributors.

Best for

Best for
Developers who need a quick MCP bridge to a Docker PostgreSQL database

Use cases

• Connecting an MCP client to a Docker PostgreSQL database
• Running PostgreSQL queries through an MCP interface
• Integrating PostgreSQL with MCP-based development tools

How to use

Install

npx postgresql-mcp

Tools exposed

• POSTGRES_HOST
• POSTGRES_PORT
• POSTGRES_USER
• POSTGRES_PASSWORD
• POSTGRES_DB
• POSTGRES_SSLMODE
• ALLOW_WRITE_OPERATIONS
• QUERY_TIMEOUT
• MAX_ROWS
• explain_query
• list_schemas
• list_tables
• describe_table
• list_views
• describe_view
• list_functions
• table_stats
• list_indexes
• list_constraints
• get_database_info

Tested with

Claude Desktop, Claude Code, Cursor

Notes

A Python-based MCP server for PostgreSQL that connects to a Docker-hosted PostgreSQL instance. It was created by a user to enable MCP connectivity to a local Docker PostgreSQL database. The repository has 9 stars and is maintained by various contributors.

9 stars on GitHub. Last updated 2026-01-23. Licensed MIT.

Use cases

• Connecting an MCP client to a Docker PostgreSQL database
• Running PostgreSQL queries through an MCP interface
• Integrating PostgreSQL with MCP-based development tools

Pros

• Works specifically with Docker PostgreSQL setups
• Lightweight Python implementation
• Simple to use for basic MCP connectivity

Cons

• Very few stars indicate limited community testing
• May lack production-ready features
• Documentation or support may be minimal

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.