tSQLt Testing
Writes, runs, and debugs tSQLt unit tests for SQL Server databases.
About
A skill for authoring tSQLt unit tests on SQL Server, structured as Assemble/Act/Assert: it fakes or spies tables, functions, and procedures, asserts on query results, expects exceptions, and runs suites with tSQLt.Run until green.
It works from test names alone and iterates on failures without sending real emails or touching production data. It is SQL Server only and assumes tSQLt is installed on a development database.
What it can do
- Assemble/Act/Assert test scaffolding
- Table faking and procedure spying
- Result-set and scalar assertions
- Exception expectations
- Test suite execution with tSQLt.Run
- Iterative failure fixing
Setup
- Run the install command to add the skill for your agents.
- Make sure tSQLt is installed on a dev SQL Server instance.
- Ask for tests by name and let the skill scaffold, fake dependencies, and run them.
Prerequisites
SQL Server with tSQLt installed on a non-production database.
Use cases
Works with
Trust score — 5/10
Scored 5/10 (metrics tier, metrics-v1). Evidence: 1 GitHub star, very early; 18 commits; requires tSQLt on a dev SQL Server — not for production databases; niche audience: SQL Server + tSQLt teams. License: MIT.
★ 1 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
- 5.0/10
- Openness · license + docs
- 8.0/10
- Manual review · sanity read + red-flag check
- 6.0/10
- · 1 GitHub star, very early
- · 18 commits
- · requires tSQLt on a dev SQL Server — not for production databases
- · niche audience: SQL Server + tSQLt teams
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.