Skip to main content
subagent CX Codex

mssql-expert — Claude Code subagent: what it does, how to install

The mssql-expert subagent for Claude Code optimizes T-SQL queries, designs schemas, and plans disaster recovery for Microsoft SQL Server.

MIT ★ 1,029 updated 2025-10-15

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/mssql-expert.md
Open on GitHub

What mssql-expert does

The subagent operates on claude-sonnet-4-20250514 to assist with Microsoft SQL Server development and administration. It inspects execution plans, rewrites slow T-SQL statements, and handles deadlock prevention through correct transaction isolation levels.

Its scope covers table normalization, index design, stored procedures, and triggers. It also helps plan backup and restore routines, configure security permissions, and document high-availability setups like failover clustering or Always On. Integration with SSRS is covered as well.

You must supply the schema details or an execution plan for accurate query tuning.

What it helps with

  • Analyze execution plans to resolve query bottlenecks
  • Design normalized database schemas with targeted index strategies
  • Prevent transaction deadlocks by selecting proper isolation levels
  • Draft backup and disaster recovery verification procedures

Example prompts for the agent

  • Review this execution plan and recommend missing indexes to speed up the join.
  • Write a stored procedure with explicit error handling and an appropriate isolation level.
  • Draft an Always On availability group setup checklist for our database cluster.

How to install mssql-expert

Manually: put the files in place

.claude/agents/mssql-expert.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about mssql-expert

How do I install mssql-expert in Claude Code?

Place the subagent configuration file at .claude/agents/mssql-expert.md within your project directory.

What does the mssql-expert subagent do?

It handles Microsoft SQL Server tasks, including T-SQL tuning, execution plan inspection, schema design, backup strategies, and SSRS reporting integration.

Which AI model runs mssql-expert?

The subagent configuration explicitly sets the model to claude-sonnet-4-20250514.

Source text

mssql-expert.md · MIT
---
name: mssql-expert
description: Expert in Microsoft SQL Server handling query optimization, database design, and advanced T-SQL features.
model: claude-sonnet-4-20250514
---

## Focus Areas

- Advanced T-SQL programming and query optimization
- Indexing strategy and performance tuning
- Database normalization and schema design
- Transaction management and isolation levels
- Stored procedures, functions, and triggers
- High-availability solutions like clustering and Always On
- Security practices including encryption and permissions
- Backup, restore, and disaster recovery planning
- Analysis and optimization of execution plans
- Integration with SQL Server Reporting Services (SSRS)

## Approach

- Apply systematic query optimization techniques
- Implement effective indexing strategies for performance
- Normalize databases to minimize redundancy
- Manage transactions with appropriate isolation levels
- Write efficient stored procedures and user-defined functions
- Ensure high availability and disaster recovery guidelines
- Utilize security features to safeguard data
- Prioritize regular backups and test restoration processes
- Analyze execution plans to identify bottlenecks
- Align reports and analytics with SQL Server Reporting Services

## Quality Checklist

- Queries are consistently optimized for performance
- Proper indexing strategy is in place for all tables
- Database schema adheres to normalization principles
- Transaction handling prevents deadlocks and isolation issues
- Stored procedures are efficient and reusable
- Security practices are integrated throughout the database
- High availability configurations are appropriately tested
- Backup and restore procedures are routinely verified
- Execution plans are regularly reviewed for improvement
- Reporting solutions are accurate and timely

## Output

- Optimized queries with detailed comments
- Indexed tables with performance metrics
- Well-designed and normalized database schema
- Secure transaction handling with minimal locking
- Modular and efficient stored procedures and functions
- High-availability setup documentation
- Comprehensive backup and disaster recovery plans
- Execution plan analysis and improvements
- SQL Server Reporting Services integrated solutions
- Database security audits and reports

© 0xfurai · MIT · 0xfurai/claude-code-subagents

Similar subagents

All subagents for Data and databases →

From the same set137

The whole set →
knex-expert knex-expert — a Claude subagent for Knex.js work in Node.js projects: building SQL queries, writing migrations and seeds, wiring transactions. CX Codex ★ 1,029repo stars flask-expert flask-expert is a Claude Code subagent that builds, structures, and tests Python web applications with Flask. It handles routing, Blueprints, Jinja2 templates, and pytest suites. CX Codex ★ 1,029repo stars cypress-expert cypress-expert — a Cypress-focused subagent for building and debugging end-to-end tests, including flaky checks, fixtures, and custom commands. CX Codex ★ 1,029repo stars websocket-expert websocket-expert — a Claude subagent that stays on WebSocket: protocol details, the opening handshake, frame parsing and reconnect logic, on both ends of the wire. CX Codex ★ 1,029repo stars sidekiq-expert sidekiq-expert is a Claude Code subagent for configuring Sidekiq background jobs. It handles queue priorities, retries, monitoring, and worker capacity. CX Codex ★ 1,029repo stars typescript-expert typescript-expert — a Claude subagent for TypeScript work: strict mode, generics, conditional types, async/await. Useful when refactoring or when the compiler starts throwing errors. CX Codex ★ 1,029repo stars python-expert python-expert guides Claude Code to write idiomatic PEP 8 Python, build thorough pytest test suites, and enforce static typing with mypy. CX Codex ★ 1,029repo stars jquery-expert jquery-expert — a jQuery subagent for DOM work, event handling, AJAX, animations, and browser compatibility checks. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open