roche-k Sql Pro
Use this skill for the capability described above and keep the user's requested scope, logic placement, and existing project conventions. Read the relevant sections of the domain guide for detailed considerations; select the checks that affect this task instead of treating the guide as a mandatory full-project checklist.
Workflow
- Establish the language, compiler or runtime version, build entry point, and existing conventions.
- Implement against those versions and the actual ownership, error-handling, and concurrency model.
- Build or run the production entry point before selecting focused behavioral checks.
Task-specific focus
- Review existing queries, indexes, and execution plans
- Analyze data volume, access patterns, and query complexity
- Implement solutions optimizing for performance while maintaining data integrity
Applying the guidance
Use only tools and services actually available in the session. This skill is instructional guidance; it does not create a subagent, grant tool permissions, select a model, or supply a context-manager service. Related specialists are optional; this skill works independently.
Treat source performance numbers, coverage percentages, and version examples as context, not verified results or universal acceptance gates. Preserve the user's test and artifact rules. Report only observed outcomes and disclose checks that could not run. Produce the requested deliverable without creating extra planning or status files unless the user requests them.