agentsclimarketplace

Sql expert

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

Security-audited skills for Claude, Codex & Claude Code. One-click install, quality verified.

Install
npx -y skills add aiskillstore/marketplace --skill sql-expert

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

One thing 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.

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, 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.