SQL Enlight
sqlenlight.com
What it is
SQL Enlight is a static analysis and refactoring tool for SQL Server and T-SQL. It examines code and databases for defects and supports server health monitoring, diagnosis, and performance tuning. Developers can validate syntax, run automated reviews, and apply automatic fixes to some code and database issues. Formatting, script summaries, and outlines help make large scripts easier to work with; sections can also be extracted into stored procedures or functions. Developers and database administrators can create custom analysis rules with XPath and XSLT. The tool integrates with SQL Server Management Studio and Visual Studio, and supports build workflows through Team Foundation Server check-in policies, MSBuild tasks, a command-line interface, and an Automation API. Its Azure DevOps extension supports build analysis, quality gates, reports, and pull-request checks and comments; a SonarQube plugin adds T-SQL issues, measures, rules, and quality-gate integration. SQL Enlight supports SQL Server 2005 through 2022, including Azure SQL Database. The paid product has a 14-day evaluation period. Licenses include email support, updates, and documentation access.
Spec sheet
- Purpose
- SQL Enlight is a static code analysis and refactoring tool for SQL Server and T-SQL.Read 7 Oct 2026 · docs.sqlenlight.com
- Product
- SQL Enlight is a static code analysis and refactoring tool for SQL Server and T-SQL.Read 7 Oct 2026 · docs.sqlenlight.com
- Trial
- The homepage advertises a full-featured 14-day free trial with no credit card required.Read 7 Oct 2026 · sqlenlight.com
- Support
- The product page says all licenses include email support, software updates, and access to documentation.Read 7 Oct 2026 · sqlenlight.com
- Maker
- The product documentation identifies Yubitsoft as the maker.Read 7 Oct 2026 · sqlenlight.com
- Activation privacy
- For activation, the product creates a non-unique hardware identifier from general system component information using a one-way hash; the page says it does not scan hard-drive files or use personally identifiable information to create that identifier.Read 7 Oct 2026 · docs.sqlenlight.com
- Analysis
- It analyzes T-SQL code and databases to identify defects and support server health monitoring, diagnosis, and performance tuning.Read 7 Oct 2026 · docs.sqlenlight.com
- Automated fixes
- The product can validate T-SQL syntax, perform automated code reviews, and apply fixes to code and database issues.Read 7 Oct 2026 · docs.sqlenlight.com
- Automatic fixes
- The product can automatically fix some code and database analysis issues.Read 7 Oct 2026 · docs.sqlenlight.com
- Azure DevOps
- The Azure DevOps extension can analyze T-SQL in builds, evaluate quality gates, publish reports, and add status checks and comments to pull requests.Read 7 Oct 2026 · sqlenlight.com
- CI integrations
- The product provides Team Foundation Server check-in policy assemblies, MSBuild tasks, a command line interface, and an Automation API.Read 7 Oct 2026 · docs.sqlenlight.com
- Custom rules
- Developers and database administrators can create custom analysis rules using XPath and XSLT.Read 7 Oct 2026 · docs.sqlenlight.com
- Editions and audience
- SQL Enlight has Developer and Build Machines editions, intended respectively for SQL Server developers and database professionals, and for CI/CD pipelines, servers, build machines, and build agents.Read 7 Oct 2026 · docs.sqlenlight.com
- Formatting and refactoring
- It can format T-SQL and refactor large scripts by extracting parts into stored procedures or functions.Read 7 Oct 2026 · docs.sqlenlight.com
- IDE integrations
- SQL Enlight integrates with SQL Server Management Studio and Visual Studio as an extension.Read 7 Oct 2026 · docs.sqlenlight.com
- Notable limit
- The documentation says the Test Explorer works with databases where tSQLt is already installed and does not currently install the framework automatically.Read 7 Oct 2026 · docs.sqlenlight.com
- Refactoring
- It can format code, extract parts of large scripts into stored procedures or functions, and generate script summaries and outlines.Read 7 Oct 2026 · docs.sqlenlight.com
- SonarQube
- The SonarQube plugin adds T-SQL issues and measures, configurable SQL Enlight rules and profiles, and quality gate integration for database code.Read 7 Oct 2026 · sqlenlight.com
- SQL Server support
- The product page says SQL Enlight supports SQL Server versions 2005 through 2022, including Azure SQL Database.Read 7 Oct 2026 · sqlenlight.com
Plans and prices
SQL Enlight for Build Machines Priced on request For CI/CD pipelines, servers, build machines, and build agents · includes command-line interface, MSBuild tasks, and Automation API Read 7 Oct 2026 · docs.sqlenlight.com
SQL Enlight for Developers Priced on request For developers and database professionals working with SQL Server and T-SQL · includes Visual Studio and SSMS extensions and a command-line interface Read 7 Oct 2026 · docs.sqlenlight.com
Strong points and limits
Strong points
- Formats and refactors T-SQL scripts.
- Supports SQL Server 2005 through 2022 and Azure SQL Database.
- Integrates with SSMS, Visual Studio, Azure DevOps, and SonarQube.
- Offers custom analysis rules using XPath and XSLT.
- Includes email support, updates, and documentation with licenses.
Limits
- Paid product; no price is listed.
- The evaluation period lasts 14 days.
- Test Explorer requires an existing tSQLt installation.
Who it suits
SQL Enlight is for SQL Server developers and database professionals who need to analyze or refactor T-SQL, as well as teams running database checks in CI/CD pipelines. The Test Explorer is relevant only to databases where tSQLt is already installed.
Verdict
SQL Enlight combines T-SQL analysis, refactoring, and automated checks with integrations for IDEs and build workflows.
Where Specifiction places it
- SQL Linters and Formatters#8 of 268.1