SQL Enlight
SQL Enlight is a paid static code analysis and refactoring tool for SQL Server and T-SQL.
What SQL Enlight is
SQL Enlight is a paid static code analysis and refactoring tool for SQL Server and T-SQL. It examines T-SQL code and databases for defects, while supporting 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 tools and refactoring can extract sections of large scripts into stored procedures or functions, and the product can generate script summaries and outlines. Custom analysis rules can be created with XPath and XSLT. SQL Enlight integrates with SQL Server Management Studio and Visual Studio. Build workflows can use Team Foundation Server check-in policies, MSBuild tasks, a command-line interface, and an Automation API. Azure DevOps support includes build analysis, quality gates, reports, pull-request comments, and status checks. A SonarQube plugin adds T-SQL issues, measures, rules, profiles, and quality-gate integration. Developer and Build Machines editions serve individual database work and CI/CD environments. SQL Server 2005 through 2022 and Azure SQL Database are supported. A 14-day trial is available.
Good
- Formats and refactors large T-SQL scripts
- Finds database and code defects
- Integrates with SSMS and Visual Studio
- Supports Azure DevOps and SonarQube
- Includes email support and software updates
Watch out
- Paid product after the 14-day trial
- Test Explorer requires tSQLt already installed
- Supports T-SQL rather than multiple dialects
Who it suits
SQL Server developers and database professionals can use the Developer edition for T-SQL work. Build Machines is intended for CI/CD pipelines, servers, build machines, and build agents.
Verdict
SQL Enlight combines T-SQL analysis, refactoring, automated fixes, and database-focused delivery integrations. Its separate editions and broad SQL Server version support fit development and CI/CD use, while the tSQLt requirement matters for Test Explorer users.
Plans and prices
From SQL Enlight's own pricing page, checked 7 Oct 2001.
| Plan | Price | What it gives you |
|---|---|---|
| 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 |
| 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 |
The facts
Each one read from SQL Enlight's own pages, with the date it was checked.
What it does
- 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.checked 7 Oct 2001
- Analysis
- It analyzes T-SQL code and databases to identify defects and support server health monitoring, diagnosis, and performance tuning.checked 7 Oct 2001
- Automated fixes
- The product can validate T-SQL syntax, perform automated code reviews, and apply fixes to code and database issues.checked 7 Oct 2001
- Automatic fixes
- The product can automatically fix some code and database analysis issues.checked 7 Oct 2001
- 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.checked 7 Oct 2001
- CI integrations
- The product provides Team Foundation Server check-in policy assemblies, MSBuild tasks, a command line interface, and an Automation API.checked 7 Oct 2001
- Custom rules
- Developers and database administrators can create custom analysis rules using XPath and XSLT.checked 7 Oct 2001
- 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.checked 7 Oct 2001
- Formatting and refactoring
- It can format T-SQL and refactor large scripts by extracting parts into stored procedures or functions.checked 7 Oct 2001
- IDE integrations
- SQL Enlight integrates with SQL Server Management Studio and Visual Studio.checked 7 Oct 2001
- Notable limit
- The documentation says the Test Explorer works with databases where tSQLt is already installed and does not currently install the framework automatically.checked 7 Oct 2001
- Product
- SQL Enlight is a static code analysis and refactoring tool for SQL Server and T-SQL.checked 7 Oct 2001
- Purpose
- SQL Enlight is a static code analysis and refactoring tool for SQL Server and T-SQL.checked 7 Oct 2001
- Refactoring
- It can format code, extract parts of large scripts into stored procedures or functions, and generate script summaries and outlines.checked 7 Oct 2001
- SonarQube
- The SonarQube plugin adds T-SQL issues and measures, configurable SQL Enlight rules and profiles, and quality gate integration for database code.checked 7 Oct 2001
- SQL Server support
- The product page says SQL Enlight supports SQL Server versions 2005 through 2022, including Azure SQL Database.checked 7 Oct 2001
- Support
- The product page says all licenses include email support, software updates, and access to documentation.checked 7 Oct 2001
The company
- Maker
- The product documentation identifies Yubitsoft as the maker.checked 7 Oct 2001
Money
- Trial
- The homepage advertises a full-featured 14-day free trial with no credit card required.checked 7 Oct 2001
Alternatives to SQL Enlight
- 1
Poor SQL
Free planOpen sourceWebAPIExtensionLinux7.3Free plan - 2
SQLFormat.org
Free planOpen sourceWebAPIExtensionSelf-hosted7.1Free plan - 3
sqlfmt
Free planWebAPILinuxSelf-hosted6.7Free plan - 4
RegSQL
Free planWeb6.5From $8 a month - 5
SQLCheck
Free planLinuxmacOSWindows6.5Free plan - 6
sqlfmt
Free planWebAPI6.5From $9 a month