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 服务器

Instagram MCP Server

HasData

Read 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.

CoinLobster

The only MCP server with live whale trades across 15 exchanges plus on-chain DEX flow. Smart Money Radar, real liquidations and outcome-scored signals. No API key required.

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

AfterLaunch

Team AfterLaunch

The agentic growth engine, in your terminal. AfterLaunch watches how customers find your product across AI search and traditional search, then hands your agent the next growth move, already drafted.

Forency

cheevahagadog

Investigate any website's technology stack: CMS, eCommerce, frameworks, analytics, CRM, payments, and hosting behind any URL. Ask "which of these 15 prospects use HubSpot vs Salesforce?" and get a table back. Free tier: