sql-professional-usage
CommunityWrite safe SQL that scales in production.
Software Engineering#performance#migrations#sql#pagination#query review#database correctness#injection safety
Authormachenjie
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill prevents slow, brittle, or unsafe SQL changes by enforcing professional standards for correctness, performance, and migration safety.
Core Features & Use Cases
- SQL injection resistance and input safety: Enforces parameterized queries and rejects string-composed SQL derived from inputs.
- Production-grade performance discipline: Requires
EXPLAIN ANALYZEfor non-trivial queries, validates index usage, and blocks unbounded scans. - Migration and semantics correctness: Applies expand-contract migration sequencing with lock-aware, online-schema-change guidance, while making NULL, timezone, and numeric precision explicit.
Quick Start
Ask the AI to review a proposed SQL query and migration for transaction safety, indexing correctness, pagination strategy, NULL behavior, timezone handling, and injection risks, and return an acceptance or rejection recommendation with required fixes.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sql-professional-usage Download link: https://github.com/machenjie/rd-skills/archive/main.zip#sql-professional-usage Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.