Domains
Forms
Mechanism
Breaks down how the skill works and what it produces, so you can quickly judge whether it fits your scenario and value.
When debugging slow queries, designing database schemas, optimizing application performance, or analyzing EXPLAIN plans.
references/details.md for deeper worked examplesUser eliminates slow queries, builds performant schemas, reduces DB load/cost, and gains a systematic optimization workflow.
Use Cases
A backend engineer notices a dashboard API takes 8 seconds on large datasets. Using this skill, they run EXPLAIN ANALYZE, spot a Seq Scan on a 10M-row table, add a composite covering index, and rewrite the JOIN to filter early. Query drops to 120ms, eliminating user complaints and reducing DB CPU cost.
A startup is designing its first PostgreSQL schema. The developer uses the skill to choose appropriate index types (partial for active users, GIN for JSONB metadata), avoid over-indexing, and plan VACUUM/ANALYZE maintenance. The result is a schema that scales smoothly as data grows without rewrite.
Skill Relationships
Dependency relationships read as "the upper tier points to the lower tier." The current Skill sits in the middle tier — above are Skills that depend on it, below are Skills it depends on.
Tier 1 · These Skills Use Me
Tier 2 · Current Skill
Tier 3 · I Use These Skills
Browse this skill's relationships within its skillset. Click a node to switch the side panel; use the search box to jump to any skill.
Skill File