All skills
sql-professional-usage
FoundationJIT onlyanalysis-agent/task-agent/review-agent: use when SQL changes affect NULL, cardinality, constraints, locks, precision, or dialect semantics; skip tool-only work.
- Group
- Language usage
- Supported roles
- MainAnalysisTaskReview
- Source
- SKILL.md
Use when
Trigger signals that make this skill the right owner
- SQL NULL three-valued logic predicate join anti-join cardinality duplicates aggregation window ordering pagination
- SQL constraint upsert transaction isolation lock precision scale rounding timezone parameter dialect DDL migration compatibility
Do not use when
Anti-triggers — as binding as the triggers above
- datastore selection data modeling ORM structure deep plan tuning transaction protocol or migration orchestration owns the open decision
- no SQL generated query schema constraint database type transaction or engine behavior changes
Required inputs
What must be supplied before this skill can decide anything
- changed SQL generated query schema constraints expected cardinality and caller row contract
- selected engine version transaction context data shape numeric temporal and migration assumptions
Output contract
What this skill owes the next role
- SQL semantic decision with NULL cardinality constraints transactions locks precision parameter dialect migration risks and specialist routes
Escalation signals
When this skill must hand the decision back
- SQL can pass simple fixtures while NULL duplicates races locks coercion precision or engine-version semantics corrupt behavior
Loaded by
This skill never owns a task. These professionals may pull it in as Layer 3.
Targeted references
Each reference carries its own load condition. None of them enter context by default.
| Reference | Load when | Do not load when | Required by |
|---|---|---|---|
| benchmarks-and-patterns.mdbenchmark-pattern | SQL change crosses NULL cardinality constraint transaction precision parameter dialect or DDL boundary whose semantics remain unclear | Current SQL row contracts engine behavior and focused fixtures settle the changed boundary | TaskAnalysisReview |