sk Skill · AIops-tools
postgres-aiops
Use this skill whenever the user needs to operate or troubleshoot a PostgreSQL server/cluster as a DBA — a one-shot cluster health overview; server reads (version/uptime, settings, extensions, databases, roles); activity (sessions, idle-in-transaction, long-running queries, locks); query stats (pg_stat_statements top-N, EXPLAIN a statement); index health (unused indexes, missing-index hints, bloat,…
Open on skills.sh ↗read 2026-09-17
- installs 8w
- 0
- 30-day movement
- starts with the next reading
- Related entries
- 1
- Connections
- 1
bashPythongovernancepostgresmcpaiops
- Host repository
- AIops-tools/Postgres-AIops
- Allowed tools
- Bash
- Compatible with
- Standalone, self-governed PostgreSQL DBA operations. The governance harness (audit, token/runaway budget, undo, it is never logged or echoed. SQL safety: all values are bound query parameters, the few identifiers that cannot be parameterised (table/index/GUC names, ORDER BY columns, where drop captures pg_get_indexdef, update_setting restores the prior value), irreversible ops (terminate/cancel, vacuum/analyze, reindex
- Licence
- MIT
- Host language
- Python