Postgres Ops
PostgreSQL operations, optimization, and administration. Use for: schema design, index selection, query tuning with EXPLAIN ANALYZE, postgresql.conf configuration, backup and restore (pg_dump, pg_basebackup, WAL, PITR), vacuum and autovacuum tuning, connection pooling (pgBouncer, pgPool), replication (streaming, logical), partitioning, monitoring (pg_stat_statements, pg_stat_activity), JSONB operations, full-text search (tsvector, tsquery), row-level security (RLS), extensions (PostGIS, pg_trgm, timescaledb), GiST/GIN/BRIN indexes, materialized views, foreign data wrappers, LISTEN/NOTIFY.
Install
npx skills add NeverSight/learn-skills.dev --skill postgres-opsgit clone --depth 1 https://github.com/NeverSight/learn-skills.dev.git /tmp/learn-skills.dev
mkdir -p ~/.claude/skills
cp -r /tmp/learn-skills.dev/data/skills-md/0xdarkmatter/claude-mods/postgres-ops ~/.claude/skills/postgres-opsPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# PostgreSQL Operations Comprehensive PostgreSQL skill covering schema design through production operations. ## Quick Connection ```bash # Standard connection psql "postgresql://user:pass@localhost:5432/dbname" # With SSL psql "postgresql://user:pass@host:5432/dbname?sslmode=require" # Environment variables (libpq) export PGHOST=localhost PGPORT=5432 PGDATABASE=mydb PGUSER=myuser PGPASSWORD=secret psql # Connection pooling (pgBouncer default) psql "postgresql://user:pass@localhost:6432/dbname" ``` ```sql -- Check current connection SELECT current_database(), current_user, inet_server_addr(), inet_server_port(); -- Active connections SELECT count(*) FROM pg_stat_activity WHERE state = 'active'; ``` ## Index Type Selection ``` What query pattern are you optimizing? │ ├─ Equality (WHERE col = val) │ └─ B-tree (default, almost always right) │ ├─ Range (WHERE col > val, ORDER BY, BETWEEN) │ └─ B-tree │ ├─ Array/JSONB containment (@>, ?, ?|, ?&) │ └─ GIN │ ├─ Full-text search (@@) │ └─ GIN with tsvector │ ├─ Geometric/range overlap (&&, <->) │ └─ GiST │ ├─ Pattern matching (LIKE '%text%', similarity) │ └─ GIN with pg_trgm (gin_trgm_ops) │ ├─ Large table, few distinct values, append-only │ └─ BRIN (tiny index, good for timestamps) │ └─ Exact equality only, no range/sort needed └─ Hash (rare - B-tree usually better) ``` ### Quick Index Reference | Index | Best For | Size | Write Cost | |-------|----------|------|------------|
Details
- Skill name
postgres-ops- Repository
- NeverSight/learn-skills.dev
- Path
data/skills-md/0xdarkmatter/claude-mods/postgres-ops/SKILL.md- Repo updated
- 18 November 2026
FAQ
What does the Postgres Ops skill do?
PostgreSQL operations, optimization, and administration. Use for: schema design, index selection, query tuning with EXPLAIN ANALYZE, postgresql.conf configuration, backup and restore (pg_dump, pg_basebackup, WAL, PITR), vacuum and autovacuum tuning, connection pooling (pgBouncer, pgPool), replication (streaming, logical), partitioning, monitoring (pg_stat_statements, pg_stat_activity), JSONB operations, full-text search (tsvector, tsquery), row-level security (RLS), extensions (PostGIS, pg_trgm, timescaledb), GiST/GIN/BRIN indexes, materialized views, foreign data wrappers, LISTEN/NOTIFY.
How do I install the Postgres Ops skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add NeverSight/learn-skills.dev --skill postgres-ops. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Postgres Ops popular?
It lives in NeverSight/learn-skills.dev, which has 223 GitHub stars and 42 forks.
Related skills
Council
223NeverSight/learn-skills.dev
Convene the Council of High Intelligence — multi-persona deliberation with historical thinkers for deeper analysis of complex problems.
Megaeth Developer
223NeverSight/learn-skills.dev
End-to-end MegaETH development playbook (Feb 2026). Covers wallet operations, token swaps (Kyber Network), eth_sendRawTransactionSync (EIP-7966) for instant receipts, JSON-RPC batching, real-time mini-block subscriptions, storage-aware contract patterns (Solady RedBlackTreeLib), MegaEVM gas model, WebSocket keepalive, bridging from Ethereum, and debugging with mega-evme. Use when building on MegaETH, managing wallets, sending transactions, or deploying contracts.
Openclaw Stock Skill
223NeverSight/learn-skills.dev
使用 data.diemeng.chat 提供的接口查询股票日线、分钟线、财务指标等数据,支持 A 股等市场。
Postgres Pro
121theguysudo/ENZO
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
Database Optimizer
121theguysudo/ENZO
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
Python Database Ops
223NeverSight/learn-skills.dev
SQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.