domains / families / data / sql-pro

sql-pro

combined

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

When to use

When not to use

Skill page

Conflict

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.