Community Plugin

tsql-master

Comprehensive T-SQL and SQL Server expertise for query optimization, performance tuning, and Azure SQL Database. PROACTIVELY activate for: (1) T-SQL query optimization and SARGability analysis, (2) SQL Server performance tuning, (3) Index design and strategy, (4) Execution plan analysis, (5) Parameter sniffing solutions, (6) Azure SQL Database optimization, (7) Window functions and advanced patterns, (8) Columnstore and In-Memory OLTP, (9) Query Store and IQP features. Includes: tsql-expert agent, 5 progressive disclosure skills, 3 optimization commands, diagnostic scripts.

2.0.3

Updated 1 month ago

AI Insight

Provides expert T-SQL and SQL Server assistance for query optimization, performance tuning, index design, and Azure SQL Database management.

Why this plugin

Offers specialized, proactive expertise for complex SQL Server performance issues like parameter sniffing and execution plan analysis, surpassing general SQL tools with deep Microsoft ecosystem knowledge.

Prerequisites

Requires access to a SQL Server or Azure SQL Database instance. May need specific permissions for diagnostic scripts and Query Store features.

sql

performance

azure

Install

Run in your terminal

npx claudepluginhub josiahsiegel/claude-plugin-marketplace

Components

Commands

Analyze Query

/analyze-query

inherits

Analyze a T-SQL query for optimization opportunities, SARGability issues, and index recommendations

Explain Execution Plan

/explain-plan

inherits

Help interpret SQL Server execution plan operators and identify performance issues

Suggest Indexes

/suggest-indexes

inherits

Suggest optimal indexes for a T-SQL query or table based on query patterns

Agents

T-SQL Expert Agent

/tsql-expert

all tools

You are an expert in T-SQL, SQL Server, and Azure SQL Database optimization. You provide comprehensive guidance on query optimization, performance tuning, index design, execution plan analysis, and platform-specific best practices.

Skills

advanced-patterns

inherits

Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS).

azure-sql-optimization

inherits

Azure SQL Database optimization and platform-specific features. Use this skill when: (1) User asks about Azure SQL Database optimization, (2) User needs DTU/vCore guidance, (3) User wants to use automatic tuning, (4) User asks about Hyperscale or serverless, (5) User needs Azure SQL performance monitoring.

index-strategies

inherits

SQL Server index design and optimization strategies. Use this skill when: (1) User needs help designing indexes, (2) User asks about clustered vs nonclustered indexes, (3) User wants to optimize columnstore indexes, (4) User needs filtered or covering indexes, (5) User asks about index maintenance and fragmentation.

query-optimization

inherits

1 assets

T-SQL query optimization techniques for SQL Server and Azure SQL Database. Use this skill when: (1) User needs to optimize slow queries, (2) User asks about SARGability or index seeks, (3) User needs help with query hints, (4) User has parameter sniffing issues, (5) User needs to understand execution plans, (6) User asks about statistics and cardinality estimation.

tsql-functions

inherits

2 assets

Complete T-SQL function reference for SQL Server and Azure SQL Database. Use this skill when: (1) User asks about T-SQL string, date, math, or conversion functions, (2) User needs help with window/ranking functions, (3) User works with JSON or XML in T-SQL, (4) User asks about aggregate functions or GROUP BY, (5) User needs system or metadata functions.

Stats

Stars13

Forks3

Installs3

MaintenanceGood

Last Commit1 month ago

Community Promotion

Collections

Links

View on GitHub

View README

Plugin Marketplace JSON

Homepage

Similar Plugins

payload

41.0k

Payload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.

2mo

v0.0.1

agent-browser

16.8k

Automates browser interactions for web testing, form filling, screenshots, and data extraction

v0.15.1

planning-with-files

15.5k

Manus-style persistent markdown files for planning, progress tracking, and knowledge storage. Works with Claude Code, Kiro, Clawd CLI, Gemini CLI, Cursor, Continue, and 11+ AI coding assistants.

v2.21.0

voltagent-data-ai

10.9k

Data engineering, ML, and AI specialists - data pipelines, machine learning, LLM architecture

v1.0.1