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.

「データと分析」の他のコンテンツ

Zillow MCP Server

HasData

HasData's hosted Zillow MCP server lets AI agents search homes for sale, rentals and sold listings, then retrieve property details, price history and Zillow estimates as structured JSON.

EximAgent

AI sales team for export-import businesses: specialist agents for outbound prospecting, trade data analysis and compliance (HS codes, tariffs, landed cost, OFAC sanctions).

Draxlr

Vivek

Draxlr is a remote MCP server that connects AI assistants to your SQL databases. Explore schemas, run read-only queries, and work with your saved queries and dashboards over MCP. Hosted at https://api.draxlr.com with OAu

AskRentAI

Ask your Rent Manager property portfolio anything, from the AI you already use. AskRentAI is a hosted, read-only MCP server for Rent Manager, the property management platform used across a large share of US rental housi

TikTok MCP Server