Database Management
API Development
Data Science & ML
Pg icon

Pg

Createdstuzero

Enables AI agents to discover, connect to, query, and understand PostgreSQL databases using the Model Context Protocol.

Github Repo

About

PG-MCP is a Model Context Protocol (MCP) server for PostgreSQL databases, designed to enhance AI agent interaction. It extends the reference Postgres MCP implementation with features such as full server implementation, multi-database support, rich catalog information, extension context for PostgreSQL extensions like PostGIS and pgvector, query explanation tools, and robust connection management. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Key Features

  • Multi-database support
  • Robust connection management with connection pooling
  • 384 GitHub stars
  • Includes query execution plan analysis tools
  • Provides extension context for PostGIS and pgvector
  • Rich database catalog information extraction

Use Cases

  • Enabling AI agents to query and understand PostgreSQL databases.
  • Providing contextual information for PostgreSQL extensions.
  • Analyzing query execution plans for optimization.