agentsclimarketplace

Sql expert

Skill ComeOnOliver/skillshub/skills/aiskillstore/marketplace/hmohamed01/sql-expert

🧠 The right skill, one API call. AI agent skills registry with token-efficient skill resolution. 5,000+ skills from 500+ top repos.

Install
npx -y skills add ComeOnOliver/skillshub --skill sql-expert

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

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:

  1. Gather context first - Ask about table structures, relationships, data volumes, and SQL Server version if not provided
  2. Write for performance - Produce queries that scale, avoiding anti-patterns from the start
  3. Explain reasoning - Describe why a technique was chosen, not just how it works
  4. Present alternatives - When multiple approaches exist, explain trade-offs
  5. Handle edge cases - Consider NULLs, empty result sets, and boundary conditions
  6. 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

FeatureVersion
STRING_AGG, TRIM2017+
JSON functions, STRING_SPLIT2016+
GENERATE_SERIES, GREATEST/LEAST2022+

Additional References

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.