pg_database_health

MCP tool from MCP Database Server V2 by Nam088

Run health audit (connections utilization, buffer cache hit ratio, dead rows, replication lag).

How to use it

pg_database_health is exposed by the MCP Database Server V2 MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the pg_database_health tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install MCP Database Server V2

$

claude mcp add --scope user mcp-server-db node /absolute/path/to/mcp-database-server/dist/index.js --env DATABASES_CONFIG_PATH=/absolute/path/to/mcp-database-server/config/databases.config.yml

FULL MCP DATABASE SERVER V2 LISTING

Other tools in MCP Database Server V2 (39)

db_reload_config

Hot-reload databases.config.yml from disk and reconcile connections dynamically without interrupting active queries.

Inspect connection states (idle, connecting, connected, retrying, failed, circuitopen), read-only mode, and error logs across all configured databases.

pg_active_queries

Retrieve running non-idle queries and durations from pgstatactivity.

pg_bloat_estimate

Estimate table bloat ratio based on dead tuple count.

pg_database_info

Get database name, current user, PostgreSQL version, and database size.

pg_describe_table

Inspect column data types, ordinal position, and nullability.

pg_duplicate_indexes

Find overlapping or redundant indexes.

Execute write SQL statements (INSERT, UPDATE, DELETE, DDL). Blocked in read-only mode.

pg_explain_hypothetical_index

Simulate hypothetical index performance using hypopg.

pg_explain_query

Inspect query execution plans with EXPLAIN.

pg_get_top_queries

Get slow queries from pgstatstatements.

Inspect index scan counts and tuple fetch statistics.

Terminate a running backend process by PID. Blocked in read-only mode.

pg_list_constraints

List primary keys, foreign keys, and check constraints.

pg_list_functions

List user-defined functions, arguments, and return types.

pg_list_indexes

List indexes and index definitions for a table.

pg_list_materialized_views

List materialized views in a schema.

pg_list_schemas

List all database schemas.

pg_list_sequences

List sequence objects in a schema.

List tables in a target schema.

pg_list_triggers

List triggers and action statements in a schema.

List all views in a schema.

Retrieve active database locks and query durations.

pg_long_running_queries

Find queries exceeding a duration threshold.

pg_missing_indexes

Identify high-sequential-scan tables needing indexes.

Execute read-only SELECT queries (enforces single-statement extended query protocol).

pg_refresh_materialized_view

Refresh a materialized view (supports CONCURRENTLY). Blocked in read-only mode.

pg_sizes_overview

Breakdown storage sizes for database, tables, and indexes.

Get total size, table size, index size, and estimated row count.

pg_unused_indexes

Identify zero-scan candidate indexes to drop.

pg_vacuum_analyze

Run VACUUM ANALYZE to update statistics and reclaim dead tuples. Blocked in read-only mode.

Delete key. Blocked in read-only mode.

Get string value at key.

Get hash field value.

Set hash field value. Blocked in read-only mode.

List keys matching a glob pattern (capped at 1000 items).

Set multiple key/value pairs in a single command (e.g. for seeding). Blocked in read-only mode.

Set key value. Blocked in read-only mode.

Get remaining TTL in seconds.