What tools does MCPg provide?
Over 100 tools covering schema introspection, natural-language-to-SQL, query optimization, index tuning, performance analysis, multi-tenancy operations, and DBA tasks.
MCPg : Production Grade Postgresql MCP Server
@devopam
Basic information
About MCPg : Production Grade Postgresql MCP Server
A safe-by-default PostgreSQL Model Context Protocol server for AI agents.
MCPg : Production Grade Postgresql MCP Server config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcpg": {
"command": "uvx",
"args": [
"mcpg"
],
"env": {
"MCPG_DATABASE_URL": "postgresql://neondb_owner:npg_HDY3yUCx5mhw@ep-falling-cherry-atplmubj-pooler.c-9.us-east-1.aws.neon.tech/neondb?sslmode=require&channel_binding=require"
}
}
}
}MCPg : Production Grade Postgresql MCP Server tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is MCPg?
MCPg is a production-grade MCP server for PostgreSQL that provides AI agents with over 100 tools for schema introspection, natural-language-to-SQL, query optimization, index tuning, performance analysis, multi-tenancy operations, and DBA tasks, prioritizing safety.
How to use MCPg?
Install via pip install mcpg or Docker. Configure connection settings and choose a transport: stdio for Claude Desktop, or HTTP/SSE/Streamable HTTP. Connect any MCP client to start using the tools.
Key features of MCPg
- Safety-first design: read-only by default, AST validation, strict sanitization
- Broad PostgreSQL support: pgvector, TimescaleDB, PostGIS, Apache AGE
- Production ready: connection pooling, SET ROLE multi-tenancy, read-replica routing
- Prometheus metrics and structured audit logging with redaction
- Multiple transports: stdio, HTTP, SSE, Streamable HTTP
- Easy install: pip or Docker with OIDC + static auth and rate limiting
Use cases of MCPg
- AI-assisted schema exploration and database introspection
- Natural language to SQL query generation and optimization
- Automated index tuning and performance analysis
- Multi-tenant database operations with role isolation
- Production DBA tasks with safety guards
Frequently asked questions
How does MCPg ensure safety?
It is read-only by default, performs AST validation on all SQL, strictly sanitizes identifiers, and requires opt-in gates for DDL, shell commands, and LISTEN operations.
What transports are supported?
MCPg supports stdio (for Claude Desktop), HTTP, Server-Sent Events (SSE), and Streamable HTTP.
Is MCPg production ready?
Yes, it includes connection pooling, SET ROLE multi-tenancy, read-replica routing, Prometheus metrics, structured audit logging, OIDC + static authentication, and rate limiting.
What are the runtime requirements?
Python (psycopg3 driver), a PostgreSQL database, and optional extensions like pg_stat_statements for performance features.
More Data & Analytics MCP servers
T
Texas RRC Wellbore Intelligence
TEOSTexas RRC oil & gas wellbores: API numbers, completion dates, depth, plug status
Instagram MCP Server
HasDataRead public Instagram profiles and post feeds by handle in Claude, Cursor, and other MCP clients. Get follower counts, captions, hashtags, mentions, and engagement counts as structured JSON.
23
iMario
iMario AI, Inc.Ask anyone anything before you decide. iMario turns your own customer data and 5.4 billion people in 59 markets into synthetic audiences calibrated on real data. This connector lets your AI assistant question them for yo
World Monitor
Elie HabibLive global-intelligence MCP server covering news, markets, conflicts, aviation, maritime activity, energy, climate, cyber threats, supply chains, and source-grounded regional briefs.
MarketCode
RoboSapien LimitedUK property intelligence for AI agents — value any address, read any market, and source land and off-market stock through one MCP endpoint.
Comments