PostgreSQL

What this skill does

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.

PostgreSQL is part of the Research & Knowledge category — research and knowledge skills that gather, search, and summarize information. You can install it on its own or alongside other research & knowledge skills from the OpenClaw catalog.

How to install PostgreSQL

The easiest path is via the OpenClaw Easy desktop app — one click, no terminal required:

1. Download OpenClaw Easy for macOS or Windows (free, one-click installer, ~30 seconds).
2. Open the in-app Skills panel.
3. Search for pg and click Install.
4. The skill activates automatically when an incoming message matches its description.

Install from the command line

If you already run the OpenClaw CLI, add PostgreSQL with a single command:

openclaw skills add pg

This pulls pg from ClawHub and installs it into ~/.openclaw/skills/pg/. Restart the OpenClaw gateway afterwards so the new skill is discovered.

How to use PostgreSQL

Once installed, PostgreSQL activates on its own: when an incoming message on WhatsApp, Telegram, Slack, Discord, Feishu or Line matches the skill's description, your OpenClaw agent loads it and runs the workflow. You can also trigger it explicitly by describing the task in chat. No extra configuration is required after install.

Manual install (advanced)

If you prefer manual installation:

1. Click the Download .zip button above to grab pg-1.0.3.zip directly from our S3 mirror.
2. Unzip into ~/.openclaw/skills/pg/ (create the directory if it does not exist).
3. Restart OpenClaw Easy (or the OpenClaw CLI gateway) so the new skill is discovered.

Frequently asked questions

How do I install PostgreSQL?

Install PostgreSQL in the OpenClaw Easy desktop app by opening the Skills panel, searching for pg, and clicking Install. From a terminal you can run: openclaw skills add pg. Either way the skill is placed in ~/.openclaw/skills/pg/.

Is PostgreSQL free?

Yes. PostgreSQL is free and open-source, distributed under the Apache-2.0 license through ClawHub. No account or payment is required to download or run it.

What does PostgreSQL do?

Tunes, designs, and operates PostgreSQL: slow queries, indexes, schemas, migrations, vacuum, locks, replication, backups.

Related: more research & knowledge skills

If PostgreSQL looks useful, you may also want to check out other research & knowledge skills in the OpenClaw catalog:

• Search Reddit ⬇ 4.2K
• Proxmox Full ⬇ 4.2K
• Qa Agent ⬇ 4.2K
• Wechat Search ⬇ 4.2K
• qmd External Knowledge Base Search ⬇ 4.1K

Browse the full OpenClaw skill catalog

This page covers just one skill. The OpenClaw skill hub has 10,000+ more — search, sort by downloads or stars, and install any of them in one click. There is also a curated awesome-openclaw-skills list grouped by use case.