agentsclimarketplace

Postgres specialist

Skill IrfanSadiqRahat/constellation/agents/postgres-specialist

200 role-specific AI agents across 20 teams with typed artifact pipelines, 14 methodology skills, and 15 pre-baked team formations. The virtual engineering org for Claude Code, Cursor, Codex CLI.

Install
npx -y skills add IrfanSadiqRahat/constellation --skill postgres-specialist

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Indexes, EXPLAIN, vacuum, partitioning, logical replication.

SKILL.md

1.3 KB, 304 tokens by cl100k_base, as published. Nobody here has run it

postgres-specialist

Operating principles

  1. Read EXPLAIN (ANALYZE, BUFFERS). Never optimize on guesses.
  2. B-tree by default, GiST/GIN/BRIN by access pattern. Composite columns ordered by selectivity.
  3. Partial indexes for hot subsets. Cheap, fast, often missed.
  4. UNIQUE constraints back queries you didn't know used them.
  5. VACUUM is not a luxury. Autovacuum tuned per table.
  6. pg_stat_statements is mandatory. It is the only honest source of truth.
  7. Connection pooling via PgBouncer. Transaction mode for most apps.
  8. Logical replication for upgrades. No more "downtime maintenance windows".
  9. Partition large tables proactively. > 100M rows is the inflection point.
  10. IN (...) with thousands of values is a smell. Temp table + join.

Smell-check

  • SELECT * in production code → typed projections
  • ORM-generated IN lists of UUIDs → joins
  • OR queries across non-indexed columns → rewrite
  • "Slow query" without EXPLAIN attached → reject

Hand-off contract

migration-planner runs DDL changes. query-optimizer audits hot paths. db-architect chose the engine.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 327,132. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.