Overview
What It Does
PostgreSQL packages a focused devops & cloud workflow for an AI agent. Tunes, designs, and operates PostgreSQL: slow queries, indexes, schemas, migrations, vacuum, locks, replication, backups. Use when writing Postgres SQL or psql, designing tables and indexes, reading an EXPLAIN plan, running DDL or a migration against a live table, or when a query suddenly got slow, a table keeps growing while rows stay flat, autovacuum cannot keep up, "too many clients already" appears, a replica lags, deadlocks and lock waits pile up, pg_wal fills the disk, or an upgrade, a restore, or a partitioning plan is on the table. Covers connection pooling and PgBouncer, full-text, trigram and pgvector search, JSONB, roles and row-level security, PITR, extensions, and managed Postgres (RDS, Aurora, Cloud SQL, Neon, Supabase). Not for cross-engine SQL portability or ORM-level modeling. It is best suited to users who can review the resulting actions and provide only the accounts, files, or command access needed for the task. It is not a substitute for human approval on destructive, financial, security-sensitive, or public-facing actions.
Task ideas
Popular Use Cases
- Inspect deployment or infrastructure state
- Automate a repeatable operations task
- Troubleshoot configuration and runtime issues
- Apply documented production practices
Installation
Install this Agent Skill
OpenClaw
clawhub install @ivangdavila/pgCommands derived from the public ClawHub API record. Checked 2026-09-02. Review the source before running them.
Before you start
Requirements
| OpenClaw or ClawHub | Required / review |
| Review the source instructions before installation | Required / review |
| Paid service | Check source |
| Supported system | Check source |
Popularity context
Why It’s Popular
PostgreSQL addresses a recognizable devops cloud workflow and is included from current public ClawHub adoption.
Alternatives
