ErikEJ.DacFX.TSQLAnalyzer.Cli
0.9.169-nightly
Prefix Reserved
This is a prerelease version of ErikEJ.DacFX.TSQLAnalyzer.Cli.
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet tool install --global ErikEJ.DacFX.TSQLAnalyzer.Cli --version 0.9.169-nightly
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest
dotnet tool install --local ErikEJ.DacFX.TSQLAnalyzer.Cli --version 0.9.169-nightly
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=ErikEJ.DacFX.TSQLAnalyzer.Cli&version=0.9.169-nightly&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
nuke :add-package ErikEJ.DacFX.TSQLAnalyzer.Cli --version 0.9.169-nightly
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
T-SQL Analyzer CLI
T-SQL Analyzer is a command line tool for identifying, and reporting the presence of anti-patterns in T-SQL scripts.
It evaluates more than 140 rules for design, naming and performance issues.
Getting started
The tool runs on any system with the .NET 8.0 runtime installed.
Installing the tool (currently in preview)
dotnet tool install --global ErikEJ.DacFX.TSQLAnalyzer.Cli --version *-*
Usage
## Analyze a single file
tsqlanalyze -i C:\scripts\sproc.sql
## Analyze a folder
tsqlanalyze -i "c:\database scripts"
## Analyze a folder with a filter and a full folder path
tsqlanalyze -i c:\database_scripts\sp_*.sql "c:\old scripts"
## Analyze a script with a rule settings filter and for a specific SQL Server version
tsqlanalyze -i C:\scripts\sproc.sql -r Rules:-SqlServer.Rules.SRD0004 -s SqlAzure
Rule settings filters are demonstrated here
The SQL Server verison values are documented here
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
This package has no dependencies.
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.15 | 332 | 3/23/2025 |
| 1.0.14 | 88 | 3/21/2025 |
| 1.0.13 | 149 | 3/19/2025 |
| 1.0.12 | 139 | 3/19/2025 |
| 1.0.11 | 133 | 3/19/2025 |
| 1.0.10 | 315 | 2/24/2025 |
| 1.0.9 | 139 | 2/24/2025 |
| 1.0.8 | 152 | 2/23/2025 |
| 1.0.7 | 264 | 2/19/2025 |
| 1.0.5 | 166 | 2/19/2025 |
| 1.0.0-preview.4 | 184 | 2/17/2025 |
| 0.9.174-nightly | 117 | 2/16/2025 |
| 0.9.171-nightly | 140 | 2/16/2025 |
| 0.9.169-nightly | 144 | 2/16/2025 |
| 0.9.167-nightly | 120 | 2/15/2025 |
| 0.9.166-nightly | 118 | 2/15/2025 |
| 0.9.164-nightly | 128 | 2/15/2025 |
| 0.9.156-nightly | 115 | 2/15/2025 |
| 0.9.154-nightly | 120 | 2/15/2025 |
| 0.9.152-nightly | 127 | 2/15/2025 |
| 0.9.151-nightly | 125 | 2/15/2025 |
| 0.9.150-nightly | 113 | 2/15/2025 |
| 0.9.149-nightly | 131 | 2/15/2025 |
| 0.9.141-nightly | 129 | 2/14/2025 |
| 0.9.139-nightly | 121 | 2/14/2025 |
| 0.9.137-nightly | 97 | 2/12/2025 |
| 0.9.135-nightly | 94 | 2/12/2025 |
Early POC