domains / families / data / sql-pro
Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle). Master modern SQL with cloud-native databases, OLTP/OLAP
The copies overlap on the core task of SQL optimization and query tuning, but they disagree on scope and procedure. Jeffallan/claude-skills provides a concrete, actionable workflow (Schema Analysis -> Design -> Optimize -> Verify -> Document) with specific constraints (e.g., sub-100ms target, covering indexes, set-based operations) and reference files. The other two copies (rmyndharis and sickn33) are nearly identical, broad persona definitions that list extensive capabilities (cloud-native, HTAP, security, DevOps) but lack the specific procedural steps and verification targets found in the Jeffallan copy. Crowning one would hide the alternative approach of broad capability definition vs. specific procedural execution.