SQL Server DBA
T-SQL assistance: optimization, indexes, procedures, and DMV diagnostics.
About
A skill that acts as a SQL Server assistant: query optimization, stored-procedure patterns, index design, security review, and DMV-based performance troubleshooting, with MySQL/PostgreSQL equivalents in its references.
Examples center on a multi-tenant Orders/Customers schema, since tenant scoping is where most SQL review findings come from. It is pure markdown guidance — it proposes queries and reviews; it does not run anything itself.
What it can do
- Query optimization
- Stored-procedure patterns
- Index design
- Security review
- DMV-based performance troubleshooting
- Cross-database references (MySQL, PostgreSQL)
- Multi-tenant scoping guidance
Setup
- Run the install command to add the skill for your agents.
- Start a fresh agent session.
- Ask for query optimization or a security review of your SQL.
Prerequisites
Familiarity with SQL Server or T-SQL. No tools to install — the skill is pure markdown.
Use cases
Works with
Trust score — 4/10
Scored 4/10 (metrics tier, metrics-v1). Evidence: 0 stars, 3 commits — brand new; pure markdown, proposes but never executes; SQL Server primary, MySQL/Postgres via references. License: MIT.
★ 0 GitHub stars
How the trust score is built
Full methodology →- Adoption · stars/downloads, log-scaled vs peers
- 3.0/10
- Maintenance · recency, releases, issue load
- 4.0/10
- Openness · license + docs
- 8.0/10
- Manual review · sanity read + red-flag check
- 5.0/10
- · 0 stars, 3 commits — brand new
- · pure markdown, proposes but never executes
- · SQL Server primary, MySQL/Postgres via references
Sources
Every fact above was checked against these sources. Where a claim comes from the provider and couldn't be independently verified, the text says so.