Skip to content
SkillModel-led1,339 tokens in use

postgres-pro

Tunes PostgreSQL with EXPLAIN ANALYZE, targeted indexes, JSONB with GIN, VACUUM and bloat checks, replication monitoring and extensions.

12,471 stars on the repository MIT LicenseJeffallan/claude-skills · skills/postgres-pro
/plugin marketplace add jeffallan/claude-skills /plugin install fullstack-dev-skills@fullstack-dev-skills
View source

Install command as written in the repository's README

Skill label

measured from its files

What installing postgres-pro costs

40tokens idle
1,339tokens in use
13,817tokens, up to

Idle is what sits in context while the skill is installed. In use is its instructions, loaded when it runs. Up to adds the files its instructions link. Counts are approximate, made offline with cl100k_base.

Model dependence Model-led

Script-ledMixedModel-led

Mostly instructions, so how well it works depends on the model that follows them.

This describes the skill's structure, how much of it is scripts. It does not say how well it works.

Touches

Nothing detected: no shell, network, file writes, git or credentials in its files.

Declared tags come from the skill's frontmatter; detected ones from its scripts, its code blocks and the commands it names in inline code. This is detected, not audited.

How it scores

Quality

How well the skill is written, counted from its own files: its frontmatter, its steps, examples, stated output and constraints, its size and whether every file it ships is one it names.How we score it →
Excellent
  • Frontmatter15/15
  • Structure23/25
  • Examples15/15
  • Output15/15
  • Size15/15
  • Resources15/15

Security

Starts at 100 and loses points for each thing in the skill's files that a reader should look at first.How we score it →
Excellent

No findings.

Repository health

Pre-computed score based on development activity, maintenance, community, maturity, and trend momentum.How we score it →
Excellent
  • Development activity100
  • Maintenance100
  • Community60
  • Maturity36
  • Momentum40

Postgres Pro guides Claude through PostgreSQL performance and administration in five steps: analyze with EXPLAIN (ANALYZE, BUFFERS), design indexes, rewrite queries, set up replication and monitor maintenance through the pg_stat views.

It includes an end-to-end example that finds slow queries in pg_stat_statements, builds a partial index concurrently and confirms the planner uses it, plus SQL for JSONB, dead tuples and replication lag.

What You Get

  • A five-step workflow from performance analysis to monitoring
  • An end-to-end slow-query example using pg_stat_statements, EXPLAIN, a concurrent partial index and ANALYZE
  • SQL patterns for JSONB containment with GIN indexes, dead tuple and bloat monitoring and replication lag
  • Reference files for performance, JSONB, extensions, replication and maintenance
  • Rules such as CREATE INDEX CONCURRENTLY in production, connection pooling and never disabling autovacuum globally

Common Use Cases

  • Finding and fixing the slowest queries on a production database
  • Indexing JSONB event payloads for containment queries
  • Setting up streaming or logical replication and watching lag
  • Tuning autovacuum on high-churn tables
  • Choosing and using extensions such as pg_trgm, PostGIS or pgvector

What Makes It Unique

The skill pairs each recommendation with a verification query. Indexes are confirmed with EXPLAIN before and after creation, replication lag is read from pg_stat_replication, and the output template asks for EXPLAIN output with interpretation, rationale for every index and before and after configuration values.

Under The Hood

The skill is instructions and reference markdown that Claude loads by topic; it ships no scripts. Its examples are SQL statements that read pg_stat views, run EXPLAIN ANALYZE, create indexes, run VACUUM and ANALYZE, so when Claude has database access it executes commands that change a live database. Without access it writes the statements for you to run.

Join founders building with open source

Opinionated takes, migration guides, cost-saving tips, and insights from the open source ecosystem.

Subscribe on SubstackJoin 750+ subscribers