Retrieve key PostgreSQL server metrics including version, access mode, connection status, and WAL level to diagnose configuration and reload status.
MIT
518,181 tools. Updated 2026-09-06 04:29
"PostgreSQL" matching MCP tools:
- Inspect cumulative I/O activity from pg_stat_io per backend type, object, and context. Identifies buffer-cache misses, write amplification, and fsync behavior; returns available=false on PostgreSQL 14/15.MIT
- Read PostgreSQL shared buffer cache summary, reporting total, free, dirty buffers, and average usage count. Requires pg_buffercache extension; returns available=false if not installed.MIT
- Review PostgreSQL configuration settings to identify suboptimal values for shared_buffers, work_mem, max_connections, and autovacuum parameters.MIT
- List all installed PostgreSQL extensions in your database to view available features and capabilities.MIT
- Lists PostgreSQL publications to manage real-time data sync for Supabase Realtime.MIT
Matching MCP Servers
- -licenseNot gradedqualityAmaintenanceA Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.100,74590,042MIT
- AlicenseAqualityDmaintenanceA production-oriented MCP server for PostgreSQL that exposes database operations like query execution, schema introspection, and table metadata to MCP clients such as Claude Desktop and VS Code.6252MIT
Matching MCP Connectors
- ThinAir DataOAuth
Connect your AI to any database — PostgreSQL, MySQL, or SQL Server — in seconds.
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
- Execute read-only SQL queries against your PostgreSQL database and retrieve the results.MIT
- Inspect PostgreSQL database schema to retrieve tables, columns, types, indexes, constraints, enums, and extensions.MIT
- Check PostgreSQL and Redis database health, including connection pool usage and latency, to diagnose infrastructure issues.Apache 2.0
- Add a PostgreSQL connection to an endpoint, providing ctx.POSTGRESQL for database queries and operations.Apache 2.0
- Fetch the schema of a connected PostgreSQL database, listing all tables and columns.MIT
- List data sources by type to view available connections in DolphinScheduler. Specify ds_type such as HIVE, MYSQL, or POSTGRESQL to filter results.Apache 2.0
- Monitor currently running PostgreSQL queries to identify performance bottlenecks and manage database connections effectively.MIT
- Add a PostgreSQL connection to an endpoint's context, enabling database access through ctx.POSTGRESQL.Apache 2.0
- Monitor PostgreSQL replication status, lag, and slot statistics to diagnose issues and check standby performance.MIT
- Check PostgreSQL server version, connection status, and extension availability to verify database accessibility and configuration before monitoring or analysis tasks.MIT
- Retrieve PostgreSQL server configuration parameters to view current values, descriptions, and change requirements for performance tuning and system analysis.MIT
- Execute read-only SQL SELECT queries on a PostgreSQL database. Supports CTEs and EXPLAIN, with configurable row limit and timeout.MIT
- Compare managed PostgreSQL database pricing across AWS, Azure, GCP, and OCI by specifying vCPUs, memory, and storage to find the cheapest option per cloud.MIT
- List all non-template databases on a PostgreSQL server, returning details like name, encoding, collation, size, and connection limit.MIT
- Verify Azure credentials for Azure Database for PostgreSQL Flexible Server access and identify the mapped PostgreSQL login role. Use it first to diagnose authentication problems.MIT