# AIops-tools/postgres-aiops

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

## Tools (35)

- `autovacuum_status`: Check autovacuum status
- `bloat_and_vacuum_analysis`: Analyze bloat and vacuum needs
- `blocking_lock_chain_rca`: Analyze blocking lock chains
- `cancel_query`: Cancel a running query
- `create_index`: Create a new index
- `drop_index`: Drop an index
- `explain_query`: Explain a query plan
- `index_bloat`: Analyze index bloat
- `invalid_indexes`: Find invalid indexes
- `list_activity`: List current database activity
- `list_databases`: List databases on server
- `list_extensions`: List installed extensions
- `list_locks`: List current locks
- `list_roles`: List database roles
- `long_running_queries`: Find long-running queries
- `missing_index_hints`: Get missing index suggestions
- `overview`: Cluster health snapshot
- `reindex`: Rebuild indexes
- `replication_slots`: List replication slots
- `replication_status`: Check replication status
- `reset_query_stats`: Reset query statistics
- `run_analyze`: Run ANALYZE on tables
- `run_vacuum`: Run VACUUM on tables
- `server_version`: Get PostgreSQL server version
- `show_settings`: Show current server settings
- `slow_query_rca`: Root cause analysis for slow queries
- `table_bloat`: Analyze table bloat
- `table_sizes`: Get table sizes
- `terminate_backend`: Terminate a backend process
- `top_queries`: Get top queries from pg_stat_statements
- `undo_apply`: Apply an undo operation
- `undo_list`: List available undo operations
- `unused_indexes`: Find unused indexes
- `update_setting`: Update a server setting
- `wal_status`: Check WAL status

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