What it does
T-SQL Tools works on .sql files in Visual Studio Code. Everything runs inside the editor; it does not connect to a database.
- Formatter. Format Document and Format Selection with 11 style settings. After formatting it checks its own result, and if anything other than spacing or letter case changed, it keeps your original text and warns you.
- Lint rules. Ten checks, such as
SELECT *,UPDATEorDELETEwithoutWHERE,NOLOCK,= NULL,@@IDENTITYand the deprecatedTEXT,NTEXTandIMAGEtypes. - Quick fixes for most rules, and comments that switch a rule off for one line.
- Snippets. 40 snippets for common T-SQL, and 15 more with Pro.
- Team settings. Formatting profiles and a shared
.tsqltools.jsonfile in the project.
Free and Pro
Every install starts with a 14-day Pro trial, with no sign-up. After that, the free features keep working.
| Feature | Free | Pro |
|---|---|---|
| Formatter and its settings | Yes | Yes |
| Lint rules | 4 rules (TSQL001 to TSQL004) | All 10 rules |
| Quick fixes | "Ignore on this line" only | Yes |
| Snippets | 40 | 55 |
| Formatting profiles and team settings file | No | Yes |
Your data
Your SQL never leaves your computer. The extension contacts blznworks.com only to check a Pro key, and sends usage counts only when VS Code telemetry is switched on. The privacy policy has the details.
Availability
Get T-SQL Tools from the Visual Studio Marketplace, or search for "T-SQL Tools" in the Extensions view of VS Code. It is also on Open VSX, for editors that install from there, such as Cursor, VSCodium and Windsurf. The free features need no key; to unlock Pro, enter your key in the extension. For questions, use the contact form.
Price
The free edition needs no key. T-SQL Tools Pro costs:
- $5 per month
- $39 per year
- $79 once, with no renewal
One Pro key works on up to 3 devices. Paddle handles the payment as merchant of record and shows any tax before you pay.