alonso-skills/mssql-server
Writes, optimizes, and debugs T-SQL queries. Explains SQL Server internals, troubleshoots performance issues, and guides database administration tasks including backup/restore, high availability, security, and index design. Use when the user asks about T-SQL syntax, SQL Server administration, query performance, stored procedures, indexes, locking, transactions, backup/restore, high availability, security, or any MSSQL-related topic — even without saying 'SQL Server' explicitly. Also trigger on terms like SSMS, tempdb, bcp, sqlcmd, MSSQL, sp_executesql, NOLOCK, columnstore, Hekaton, RCSI, param sniffing, or execution plan.
100
100%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Passed
No known issues
Quality
Discovery
100%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This is an excellent skill description that clearly defines its scope around SQL Server and T-SQL, lists concrete capabilities, and provides comprehensive trigger guidance. The explicit 'Use when...' clause with both common and specialized trigger terms ensures accurate skill selection. The description is thorough without being padded, and uses proper third-person voice throughout.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Lists multiple specific concrete actions: writes/optimizes/debugs T-SQL queries, explains SQL Server internals, troubleshoots performance issues, guides database administration tasks including backup/restore, high availability, security, and index design. | 3 / 3 |
Completeness | Clearly answers both 'what' (writes/optimizes/debugs T-SQL, explains internals, troubleshoots performance, guides admin tasks) and 'when' with an explicit 'Use when...' clause listing numerous trigger scenarios and specific terms. | 3 / 3 |
Trigger Term Quality | Excellent coverage of natural terms users would say, including both common terms (T-SQL, SQL Server, stored procedures, indexes, backup/restore) and specialized terms (SSMS, tempdb, bcp, sqlcmd, MSSQL, sp_executesql, NOLOCK, columnstore, Hekaton, RCSI, param sniffing, execution plan). Also notes triggering even without the user saying 'SQL Server' explicitly. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive with a clear niche around SQL Server/T-SQL/MSSQL. The extensive list of SQL Server-specific terms (SSMS, tempdb, Hekaton, RCSI, sp_executesql, etc.) makes it very unlikely to conflict with generic database or other SQL dialect skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
100%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is an exceptionally well-structured skill that serves as a routing hub for a comprehensive MSSQL knowledge base. The routing table with keywords, file paths, scope descriptions, and disambiguation columns is an elegant solution for a broad domain. The content is concise, actionable, and perfectly demonstrates progressive disclosure by keeping the main file lean while pointing to 54 specialized reference files.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The skill is lean and efficient. It provides a clear routing mechanism without explaining what SQL Server is or how databases work. Every section serves a purpose: usage instructions, quick examples, and the routing table. The disambiguation column is a smart way to handle ambiguity without verbose prose. | 3 / 3 |
Actionability | The quick examples provide executable T-SQL code. The routing table gives concrete file paths for every topic. The 5-step usage instructions are specific and actionable (e.g., 'Lead with code/pattern, follow with caveats in admonition blocks'). The disambiguation column provides precise cross-reference guidance. | 3 / 3 |
Workflow Clarity | The 5-step workflow is clearly sequenced: identify topic → read reference files → handle cross-cutting questions → disambiguate → format response. For a routing/dispatch skill, this is the appropriate level of workflow detail. There are no destructive or batch operations requiring validation checkpoints. | 3 / 3 |
Progressive Disclosure | This is an exemplary progressive disclosure pattern. The SKILL.md serves as a concise overview and routing hub, pointing to 54 well-organized reference files via a single-level-deep routing table. Each reference file is clearly scoped with keywords, file paths, and disambiguation notes for navigation. | 3 / 3 |
Total | 12 / 12 Passed |
Validation
100%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
Reviewed
Table of Contents