How do I install the Postgres Mastery skill?

Run npx skills-ws install postgres-mastery in your project. The skill is added to your agent's skills directory (.claude/skills, .cursor/skills, .agents/skills, or the OpenClaw workspace skills/ directory) and works with Claude Code, OpenClaw, Cursor, Codex, and GitHub Copilot.

Which AI coding assistants support the Postgres Mastery skill?

Postgres Mastery works with any agent that supports the SKILL.md standard, including openclaw, claude-code, cursor, codex.

Is the Postgres Mastery skill free?

Yes. Postgres Mastery is MIT-licensed open source and free to use. Source code is on GitHub at github.com/san-npm/skills-ws.

Postgres Mastery skill

Postgres Mastery is an agent skill for AI coding assistants (Claude Code, OpenClaw, Cursor, Codex). Advanced PostgreSQL — index strategies, EXPLAIN ANALYZE, partitioning, pgvector, connection pooling, zero-downtime migrations, backups, and replication. Use when diagnosing slow queries, designing indexes, planning a migration, tuning PgBouncer, adding pgvector search, or setting up backups/replication. Install with: npx skills-ws install postgres-mastery.

devv1.11.0Updated Aug 2026

copied ✓

openclawclaude-codecursorcodex

0 installsSecurity scan: cleanSource code

PostgreSQL Mastery

Production PostgreSQL patterns that go beyond CREATE INDEX. Index selection, query plan analysis, partitioning, pgvector for embeddings, zero-downtime migrations, and replication.

Reference guide

Read only the references needed for the current request:

1. Index Types — When to Use Each: references/1-index-types-when-to-use-each.md
2. EXPLAIN ANALYZE Deep Dive: references/2-explain-analyze-deep-dive.md
3. Partitioning: references/3-partitioning.md
4. pgvector — Embeddings & Similarity Search: references/4-pgvector-embeddings-similarity-search.md
5. Connection Pooling — PgBouncer: references/5-connection-pooling-pgbouncer.md
6. Zero-Downtime Migrations: references/6-zero-downtime-migrations.md
7. Backup & Recovery: references/7-backup-recovery.md
8. Replication: references/8-replication.md
9. Query Optimization Case Studies: references/9-query-optimization-case-studies.md
10. Essential Configuration: references/10-essential-configuration.md

PostgreSQL Mastery

Reference guide

Related Dev skills