PostgreSQL Ops

Provides direct PostgreSQL database access with query execution, schema introspection, and performance monitoring through specialized extensions like pg_stat_statements for conversational database administration and troubleshooting.

PostgreSQL operations MCP server by JungJungIn that provides AI assistants with direct database access through asyncpg and psycopg2 connections, offering query execution, database introspection, and performance monitoring capabilities. The implementation includes specialized functions for PostgreSQL extensions like pg_stat_statements and pg_stat_monitor for query performance analysis, along with utility functions for formatting database results into human-readable tables with automatic byte and duration formatting. Built with Docker support and both stdio and HTTP transport options, it serves developers needing conversational database administration, data analysts requiring ad-hoc query capabilities, and database administrators who want AI-assisted performance monitoring and troubleshooting workflows.