CtrlK
BlogDocsLog inGet started
Tessl Logo

alonso-skills/mssql-writing-guidelines

Use when writing or reviewing MSSQL/T-SQL, creating stored procedures, designing table schemas, writing views, building migrations, defining custom types, or architecting a SQL Server application database. Also use when writing RAISERROR patterns, CHECK constraints with scalar functions, base/subtype table hierarchies, composite key designs, role-scoped views with row-level security, or idempotent DDL scripts. If you are touching MSSQL for an application database, use this skill. Not for PostgreSQL, MySQL, Oracle, or SQLite — patterns are SQL Server-specific.

75

Quality

94%

Does it follow best practices?

Impact

No eval scenarios have been run

SecuritybySnyk

Passed

No known issues

Overview
Quality
Evals
Security
Files

Quality

Content

85%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

This is a high-quality, comprehensive MSSQL methodology skill that provides concrete, executable guidance across a wide range of SQL Server patterns. Its greatest strengths are actionability (real T-SQL throughout), excellent progressive disclosure (clear overview with well-signaled references), and strong workflow clarity with explicit validation steps. The only minor weakness is that some sections include slightly more explanatory prose than strictly necessary, though most of it conveys genuinely novel methodology rather than concepts Claude would already know.

DimensionReasoningScore

Conciseness

The skill is generally well-written and avoids explaining basic SQL concepts, but it's quite long (~300+ lines) with some sections that could be more tightly compressed. The 'When to Use' / 'When NOT to use' section and some explanatory prose (e.g., explaining why predicate constraint names are better) add modest verbosity. However, most content is genuinely novel methodology that Claude wouldn't know, so the bulk earns its place.

2 / 3

Actionability

The skill provides concrete, executable T-SQL code examples throughout — CREATE TYPE definitions, CHECK constraints with scalar functions, composite key hierarchies, idempotent migration patterns with meta-functions, and specific naming conventions with examples. The Common Mistakes table gives precise fix patterns. Code is copy-paste ready and specific to SQL Server.

3 / 3

Workflow Clarity

The idempotent migration section includes an explicit 4-step validation workflow (run once → verify objects → verify constraints → run again for idempotency). The transaction hierarchy (_trx/_utx/_ut) clearly defines composition patterns with validation checks (@@TRANCOUNT). Error handling specifies checking @@ROWCOUNT and @@ERROR after every DML with GOTO exit labels. The procedure composition pattern (trx opens, calls utx, commits/rolls back) is a clear feedback loop.

3 / 3

Progressive Disclosure

The skill is structured as a clear overview with well-signaled one-level-deep references to 10+ reference files (procedure-structure.md, basetype-subtype.md, hierarchical-keys.md, view-patterns.md, security-permissions.md, relational-queues.md, error-handling.md, migration-patterns.md, naming-conventions.md, query-patterns.md, etc.). Each section gives enough inline context to be useful standalone while pointing to detailed references for full patterns. No nested references.

3 / 3

Total

11

/

12

Passed

Description

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 thoroughly covers specific capabilities, includes abundant natural trigger terms, explicitly states both what the skill does and when to use it, and clearly distinguishes itself from similar database skills through explicit exclusion of other SQL dialects. The description is comprehensive without being padded, and uses appropriate third-person imperative voice throughout.

DimensionReasoningScore

Specificity

Lists multiple specific concrete actions: writing stored procedures, designing table schemas, writing views, building migrations, defining custom types, RAISERROR patterns, CHECK constraints with scalar functions, base/subtype table hierarchies, composite key designs, role-scoped views with row-level security, idempotent DDL scripts.

3 / 3

Completeness

Clearly answers both 'what' (writing/reviewing T-SQL, stored procedures, schemas, views, migrations, etc.) and 'when' with explicit trigger guidance ('Use when writing or reviewing MSSQL/T-SQL...', 'If you are touching MSSQL for an application database, use this skill'). Also includes explicit exclusion criteria.

3 / 3

Trigger Term Quality

Excellent coverage of natural terms users would say: MSSQL, T-SQL, stored procedures, table schemas, views, migrations, custom types, SQL Server, CHECK constraints, composite key, row-level security, DDL scripts. Also explicitly names competing technologies (PostgreSQL, MySQL, Oracle, SQLite) to prevent false matches.

3 / 3

Distinctiveness Conflict Risk

Highly distinctive with a clear niche (SQL Server/MSSQL specifically) and explicitly excludes other database systems (PostgreSQL, MySQL, Oracle, SQLite), making it very unlikely to conflict with skills for other database platforms.

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.

Validation11 / 11 Passed

Validation for skill structure

No warnings or errors.

Reviewed

Table of Contents