skills.rest
odeciojunior
odeciojuniorCOMMUNITY
Explore all skills by this author →
GitHub

sql-server-toolkit

Route SQL Server tasks to specialist agents for diagnostics, tuning, and review.

Updated Oct 15, 2025
Search Tags:#query-optimization#code-review#sql-server#agent-orchestration#database-performance#schema-discovery#t-sql
One-click install
npx skills add https://github.com/odeciojunior/claude-play --skill sql-server-toolkit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-server-toolkit
Source: https://github.com/odeciojunior/claude-play/tree/main/plugins/sql-server-tools/skills/sql-server-toolkit
Command: npx skills add https://github.com/odeciojunior/claude-play --skill sql-server-toolkit

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the guesswork of choosing the right specialist for SQL Server workflows by routing database diagnostics, query tuning, schema exploration, and code review tasks to focused agents that produce targeted, expert guidance.

Core Features & Use Cases

  • Agent orchestration for diagnostics: Automatically assign performance and health investigations to a performance monitoring agent that inspects wait stats, blocking, and resource usage.
  • Schema and metadata discovery: Use a schema discovery agent to enumerate tables, relationships, and dependencies to accelerate documentation and impact analysis.
  • Query tuning and code review: Route slow queries to a performance tuner for execution plan analysis and index recommendations, and send stored procedures to a code review agent for anti-pattern and security checks.
  • Use Case: When a production query is causing high CPU and IO, describe the problem and receive a prioritized plan that includes agent-picked diagnostics, tuning suggestions, and code review findings.

Quick Start

Ask Claude to analyze this slow query, identify root causes, and recommend index and plan changes using the appropriate SQL Server specialist agent.

Frequently Asked Questions about sql-server-toolkit

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot slow SQL Server queries and analyze execution plans?▼

To troubleshoot slow SQL Server queries, this Skill routes your query to a performance tuner agent that analyzes execution plans, identifies root causes, and recommends index and plan changes for query optimization.

Can I review T-SQL stored procedures for anti-patterns and security issues?▼

Yes, you can review T-SQL stored procedures by routing them to a dedicated code review agent that checks for anti-patterns and security vulnerabilities, providing targeted guidance to improve code quality.

How do I discover SQL Server schema metadata and table dependencies?▼

You can discover SQL Server schema metadata by using the schema discovery agent to enumerate tables, relationships, and dependencies, accelerating documentation and impact analysis.

Do I need live database connectivity to diagnose SQL Server performance issues?▼

No, you do not need live database connectivity to diagnose SQL Server performance issues because the Skill supports offline analysis of SQL artifacts when direct database access is not available.

What is the best way to monitor SQL Server blocking and resource usage?▼

The best way to monitor SQL Server blocking and resource usage is to assign performance investigations to a monitoring agent that inspects wait stats, blocking chains, and resource consumption.

Does agent orchestration work for both SQL Server DBAs and developers?▼

Yes, agent orchestration works for both SQL Server DBAs and developers performing performance troubleshooting, schema discovery, T-SQL development, and code review workflows by routing tasks to specialized agents.

Related Skills

Explore More Software Engineering Skills→
lemlinelemline
39

sql-expert

Analyze and optimize SQL queries across PostgreSQL, MySQL, and H2.

Official
Advanced
moveonhamoveonha
1

sql-optimizer

Detect PostgreSQL SQL anti-patterns and generate EXPLAIN ANALYZE-based optimization recommendations.

Community
Advanced
pascallammerspascallammers
1

neon

Guide Neon Serverless Postgres usage for branching, pooling, optimization, and CI/CD.

Community
Advanced
Likas07Likas07

database-optimizer

Analyze SQL queries and schema design for PostgreSQL, MySQL, Supabase, and PlanetScale.

Community
Advanced