MCPg : Production Grade Postgresql MCP Server

@devopam

代码仓库文档

基本信息

分类

数据与分析

传输方式

stdio

作者

devopam

提交者

Devopam Mittra

关于 MCPg : Production Grade Postgresql MCP Server

A safe-by-default PostgreSQL Model Context Protocol server for AI agents.

#mcp #server #postgresql

MCPg : Production Grade Postgresql MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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.

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.

数据与分析分类下的更多 MCP 服务器

API Direct

Search and read public data from X/Twitter, Reddit, YouTube, Instagram, TikTok, Facebook, Threads, Bluesky, Trustpilot, Amazon, Google Maps, news, forums and the web. 90+ read-only tools plus ready-made research playbook

Aard

Braddon Lance

Aard connects Macroeconomic and other official data from 170+ publishers including World Bank, IMF, BIS, ECB, Eurostat, and National Statistical Offices. Aard is powered by a large graph of the metadata universe and an

LeadBoxer

Company and contact enrichment: identify the company behind an IP, get firmographics for a domain, and profile a work email.

Tracetify — Competitor Ads, Growth Traces & Search Console

tracetify

17 tools for marketing and SEO research inside Claude Code, Cursor, Codex or ChatGPT: the ads any domain runs on Meta and Google, how a product grew from 12 public sources with every claim linked, your own Search Console

Lawstronaut Legal Research

Lawstronaut-FZCO

Connect your AI to millions of laws and court cases! Lawstronaut is the infrastructure layer that connects AI agents and software to millions of legal documents across 150+ jurisdictions, structured legal data, continuou