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 designing or reviewing a PostgreSQL-specific schema, including table structures, data types, indexes, constraints, and partitioning.
A correctly designed, performant, and maintainable PostgreSQL schema following best practices, avoiding common pitfalls.
Use Cases
A backend engineer is building a new SaaS billing system and needs to design the subscriptions and invoices tables. Using this skill, they apply 3NF normalization, choose BIGINT IDENTITY keys, NUMERIC for money, and add FK indexes. The result is a clean schema that avoids timestamp/timezone mistakes and performs well under join-heavy queries.
A DBA reviews a legacy PostgreSQL schema suffering from slow queries and dead tuples. Using this skill, they identify missing FK indexes, premature varchar(n) usage, and lack of partitioning on a 200M-row log table. They apply partial indexes, switch to TEXT, and implement RANGE partitioning, restoring query performance and simplifying maintenance.
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
