Sql expert skills hmohamed01 sql expert
Skill bg-szy/TOP-SKILLS/skills/marketplace/sql-expert__skills-hmohamed01-sql-expert
全球最大的 Claude Code 技能聚合库 · 收录 3900+ 来自 12+ 来源的技能，提供在线搜索与趋势分析看板 / The world's largest Claude Code skill aggregation hub — 3900+ skills from 12+ sources with online search and trend dashboard
npx -y skills add bg-szy/TOP-SKILLS --skill sql-expert__skills-hmohamed01-sql-expertAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Write, optimize, and debug T-SQL queries for Microsoft SQL Server. Covers CTEs, window functions, PIVOT, MERGE, APPLY operators, execution plan analysis, indexing strategies, and stored procedures. Use when working with SQL Server, T-SQL scripts, .sql files, stored procedures, query optimization, or database performance tuning.
SKILL.md
2.8 KB, 593 tokens by cl100k_base, as published. Nobody here has run it
SQL Expert
Expert assistance for Microsoft SQL Server and T-SQL development.
Instructions
When helping with T-SQL:
- Gather context first - Ask about table structures, relationships, data volumes, and SQL Server version if not provided
- Write for performance - Produce queries that scale, avoiding anti-patterns from the start
- Explain reasoning - Describe why a technique was chosen, not just how it works
- Present alternatives - When multiple approaches exist, explain trade-offs
- Handle edge cases - Consider NULLs, empty result sets, and boundary conditions
- Note version requirements - Flag features that require specific SQL Server versions
Core Capabilities
- Query optimization: Execution plan analysis, index recommendations, eliminating anti-patterns
- Advanced techniques: CTEs (recursive/non-recursive), window functions, PIVOT/UNPIVOT, MERGE, CROSS/OUTER APPLY
- Data processing: JSON/XML handling, temporal tables, dynamic SQL
- Stored procedures: Error handling with TRY...CATCH, transaction management, table-valued parameters
Quick Reference
Anti-Patterns to Catch
-- Non-SARGable (BAD)
WHERE YEAR(date_column) = 2024
-- SARGable (GOOD)
WHERE date_column >= '2024-01-01' AND date_column < '2025-01-01'
-- Implicit conversion (BAD)
WHERE nvarchar_column = @varchar_param
-- Type match (GOOD)
WHERE nvarchar_column = @nvarchar_param
Error Handling Template
BEGIN TRY
BEGIN TRANSACTION;
-- operations
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION;
THROW;
END CATCH;
Version-Specific Features
| Feature | Version |
|---|---|
| STRING_AGG, TRIM | 2017+ |
| JSON functions, STRING_SPLIT | 2016+ |
| GENERATE_SERIES, GREATEST/LEAST | 2022+ |
Additional References
- references/patterns.md - Query patterns and templates (CTEs, pagination, PIVOT, MERGE, window functions)
- references/performance.md - Execution plan analysis, parameter sniffing, Query Store, wait statistics
- references/security.md - SQL injection prevention, dynamic SQL safety, permissions, data masking
- references/data-types.md - Type selection, collation handling, precision/scale, storage optimization
- references/transactions.md - Isolation levels, deadlock prevention, distributed transactions, sagas
What ships with it: 2 files
50.7 KB alongside SKILL.md
- evaluation.json11.1 KB
- skill-report.json39.6 KB