# AIops-tools/Postgres-AIops

Source: https://glimind.com/server/awesome%2Faiops-tools%2Fpostgres-aiops
Registry id: `awesome/aiops-tools/postgres-aiops`
Status: unknown

## Tools (35)

- `autovacuum_status`: Check autovacuum status for tables.
- `bloat_and_vacuum_analysis`: Analyze table bloat and vacuum needs with ranked recommendations.
- `blocking_lock_chain_rca`: Build the wait-for tree from pg_blocking_pids and identify the root blocker.
- `cancel_query`: Cancel a running query.
- `create_index`: Create an index (records inverse for undo).
- `drop_index`: Drop an index (captures definition for undo).
- `explain_query`: Get the execution plan for a query.
- `index_bloat`: Analyze index bloat.
- `invalid_indexes`: Find invalid indexes.
- `list_activity`: List current database activity/connections.
- `list_databases`: List all databases on the server.
- `list_extensions`: List installed PostgreSQL extensions.
- `list_locks`: List current database locks.
- `list_roles`: List all database roles/users.
- `long_running_queries`: Identify long-running queries.
- `missing_index_hints`: Get suggestions for missing indexes.
- `overview`: Get a high-level overview of the PostgreSQL server.
- `reindex`: Rebuild an index.
- `replication_slots`: List replication slots.
- `replication_status`: Check replication status.
- `reset_query_stats`: Reset pg_stat_statements query statistics.
- `run_analyze`: Run ANALYZE on a table.
- `run_vacuum`: Run VACUUM on a table.
- `server_version`: Get the PostgreSQL server version.
- `show_settings`: Show current PostgreSQL configuration settings.
- `slow_query_rca`: Root cause analysis for a slow query using pg_stat_statements and optional EXPLAIN.
- `table_bloat`: Analyze table bloat.
- `table_sizes`: Get sizes of all tables.
- `terminate_backend`: Terminate a database backend/connection.
- `top_queries`: Show top queries by resource usage (requires pg_stat_statements).
- `undo_apply`: Apply an undo operation to revert a previous write.
- `undo_list`: List available undo operations.
- `unused_indexes`: Find indexes that are not being used.
- `update_setting`: Update a PostgreSQL configuration setting (captures prior value for undo).
- `wal_status`: Check WAL (Write-Ahead Log) status.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.