Skip to content
SPECIFICTION
Get listed

PgSanity vs SQL Enlight

PgSanity

github.com

SQL Enlight

sqlenlight.com

Side by side

FigurePgSanitySQL Enlight
Price fromFree—
Free planYes—
Free trial—Yes
Open source——
Windows—Yes
LinuxYes—
API—Yes
Self-hostedYesYes
Plans published12
Spec score · SQL Linters and Formatters7.9 (#11)8.1 (#8)
PurposePgSanity checks the syntax of PostgreSQL SQL files.SQL Enlight is a static code analysis and refactoring tool for SQL Server and T-SQL.
SupportThe README points users to the GitHub project page to report problems.The product page says all licenses include email support, software updates, and access to documentation.

Plans

PgSanity

  • FreeFree

PgSanity pricing →

SQL Enlight

  • SQL Enlight for Build MachinesPriced on request
  • SQL Enlight for DevelopersPriced on request

SQL Enlight pricing →

In their own words

PgSanity

PgSanity has no write-up on Specifiction yet; its figures are above.

Visit github.com

SQL Enlight

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.

Visit sqlenlight.com