{"id":"61ff535b-0aa9-41d0-b88a-6d8dd6a55c46","slug":"clawhub-zw008-postgres-aiops","name":"postgres-aiops","description":"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, invalid/duplicate); table health (sizes, dead-tuple bloat, autovacuum status); replication (standby lag, replication slots, WAL); three flagship analyses — slow-query RCA (worst pg_stat_statements entry + EXPLAIN → cause/action), bloat & vacuum analysis (dead tuples + autovacuum lag → recommendation), and blocking lock-chain RCA (build the wait-for tree, name the root blocker); and guarded writes (terminate a backend, cancel a query, VACUUM/ANALYZE, create/drop an index, REINDEX, ALTER SYSTEM SET a parameter, reset query stats). Always use this skill for \"postgres health check\", \"why is this query slow\", \"pg_stat_statements top queries\", \"EXPLAIN this\", \"table/index bloat\", \"which indexes are unused\", \"missing index\", \"autovacuum status\", \"who is blocking whom\", \"kill the backend holding the lock\", \"replication lag\", \"replication slots\", \"VACUUM this table\", \"create/drop an index\", or \"ALTER SYSTEM SET work_mem\" when the context is a PostgreSQL database. Do NOT use when the target is OT / industrial equipment (Modbus, OPC-UA, PLCs — use industrial-aiops), a hypervisor, a storage appliance, a backup product, a container/cluster orchestrator, or a non-PostgreSQL database (negative routing hints only). Covers common PostgreSQL DBA operations with a built-in governance harness (audit, token budget, undo, risk-tiers). Beyond the mock suite, the reads plus a governed write and its undo have been exercised against a live PostgreSQL 16.14 instance (see docs/VERIFICATION.md).","canonicalUrl":"https://www.xpersona.co/agent/clawhub-zw008-postgres-aiops","sourceUrl":"https://clawhub.ai/zw008/postgres-aiops","homepage":"https://clawhub.ai/zw008/skills/postgres-aiops","source":"CLAWHUB","vendor":{"slug":"clawhub","label":"Clawhub","url":"https://clawhub.ai/zw008/skills/postgres-aiops"},"protocols":["OPENCLEW"],"capabilities":[],"trustScore":null,"trustConfidence":"unknown","artifactCount":0,"benchmarkCount":0,"lastRelease":"0.10.3","freshnessAt":"2026-10-10T12:45:12.703Z","freshnessLabel":"Oct 10, 2026","securityReviewed":true,"openapiReady":false,"stats":[{"label":"Trust score","value":"Unknown"},{"label":"Compatibility","value":"OpenClaw"},{"label":"Freshness","value":"Oct 10, 2026"},{"label":"Vendor","value":"Clawhub"},{"label":"Artifacts","value":"0"},{"label":"Benchmarks","value":"0"},{"label":"Last release","value":"0.10.3"}],"factsPreview":[{"factKey":"vendor","category":"vendor","label":"Vendor","value":"Clawhub","href":"https://clawhub.ai/zw008/skills/postgres-aiops","sourceUrl":"https://clawhub.ai/zw008/skills/postgres-aiops","sourceType":"profile","confidence":"medium","observedAt":"2026-10-10T12:45:12.703Z","isPublic":true},{"factKey":"protocols","category":"compatibility","label":"Protocol compatibility","value":"OpenClaw","href":"https://www.xpersona.co/api/v1/agents/clawhub-zw008-postgres-aiops/contract","sourceUrl":"https://www.xpersona.co/api/v1/agents/clawhub-zw008-postgres-aiops/contract","sourceType":"contract","confidence":"medium","observedAt":"2026-10-10T12:45:12.703Z","isPublic":true},{"factKey":"traction","category":"adoption","label":"Adoption signal","value":"1.4K downloads","href":"https://clawhub.ai/zw008/postgres-aiops","sourceUrl":"https://clawhub.ai/zw008/postgres-aiops","sourceType":"profile","confidence":"medium","observedAt":"2026-10-10T12:45:12.703Z","isPublic":true},{"factKey":"latest_release","category":"release","label":"Latest release","value":"0.10.3","href":"https://clawhub.ai/zw008/postgres-aiops","sourceUrl":"https://clawhub.ai/zw008/postgres-aiops","sourceType":"release","confidence":"medium","observedAt":"2026-09-15T06:15:14.292Z","isPublic":true},{"factKey":"handshake_status","category":"security","label":"Handshake status","value":"UNKNOWN","href":"https://www.xpersona.co/api/v1/agents/clawhub-zw008-postgres-aiops/trust","sourceUrl":"https://www.xpersona.co/api/v1/agents/clawhub-zw008-postgres-aiops/trust","sourceType":"trust","confidence":"medium","observedAt":null,"isPublic":true}],"highlights":["1.4K downloads","Trust evidence available"],"agentCard":{"name":"postgres-aiops","description":"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, invalid/duplicate); table health (sizes, dead-tuple bloat, autovacuum status); replication (standby lag, replication slots, WAL); three flagship analyses — slow-query RCA (worst pg_stat_statements entry + EXPLAIN → cause/action), bloat & vacuum analysis (dead tuples + autovacuum lag → recommendation), and blocking lock-chain RCA (build the wait-for tree, name the root blocker); and guarded writes (terminate a backend, cancel a query, VACUUM/ANALYZE, create/drop an index, REINDEX, ALTER SYSTEM SET a parameter, reset query stats). Always use this skill for \"postgres health check\", \"why is this query slow\", \"pg_stat_statements top queries\", \"EXPLAIN this\", \"table/index bloat\", \"which indexes are unused\", \"missing index\", \"autovacuum status\", \"who is blocking whom\", \"kill the backend holding the lock\", \"replication lag\", \"replication slots\", \"VACUUM this table\", \"create/drop an index\", or \"ALTER SYSTEM SET work_mem\" when the context is a PostgreSQL database. Do NOT use when the target is OT / industrial equipment (Modbus, OPC-UA, PLCs — use industrial-aiops), a hypervisor, a storage appliance, a backup product, a container/cluster orchestrator, or a non-PostgreSQL database (negative routing hints only). Covers common PostgreSQL DBA operations with a built-in governance harness (audit, token budget, undo, risk-tiers). Beyond the mock suite, the reads plus a governed write and its undo have been exercised against a live PostgreSQL 16.14 instance (see docs/VERIFICATION.md).","source":"CLAWHUB","sourceId":"clawhub:s171xgnmqse0nqvgqvqnaq5f9183kyre:postgres-aiops","homepage":"https://clawhub.ai/zw008/skills/postgres-aiops","repository":"https://clawhub.ai/zw008/postgres-aiops","documentation":"https://www.xpersona.co/agent/clawhub-zw008-postgres-aiops","protocols":["OPENCLEW"],"examples":[{"kind":"example","language":"bash","snippet":"uv tool install postgres-aiops\npostgres-aiops init       # interactive wizard: connection + encrypted password\npostgres-aiops doctor"},{"kind":"example","language":"bash","snippet":"openclaw plugins install clawhub:@zw008/postgres-aiops\nopenclaw skills info postgres-aiops          # expect: Visible to model: yes"}]}}