The Best T-SQL Static Analysis Tools (Linters/Formatters)
We rank 8 T-SQL linters, code analyzers, formatters, and more. Find and compare tools like Codacy, Fortify, SonarCloud, and more. Please rate and review tools that you've used. This helps others find the best tools for their projects.
Help make this list better
Suggest Tools
8 Multi-Language Tools
Fortify
A commercial static analysis platform that supports the scanning of C/C++, C#, VB.NET, VB6, ABAP/BSP, ActionScript, Apex, ASP.NET, Classic ASP, VB Script, Cobol, ColdFusion, HTML, Java, JS, JSP, MXML/Flex, Objective-C, PHP, PL/SQL, T-SQL, Python (2.6, 2.7), Ruby (1.9.3), Swift, Scala, VB, and XML.
SonarCloud
SonarCloud enables your team to deliver clean code consistently and efficiently with a code review tool that easily integrates into the cloud DevOps platforms and extend your CI/CD workflow. SonarCloud is free for open source projects.
CAST Highlight
Commercial Static Code Analysis which runs locally, but uploads the results to its cloud for presentation.
PT.PM
An engine for searching patterns in the source code, based on Unified AST or UST. At present time C#, Java, PHP, PL/SQL, T-SQL, and JavaScript are supported. Patterns can be described within the code or using a DSL.
StaticReviewer
Static Reviewer executes code checks according to the most relevant Secure Coding Standards, OWASP, CWE, CVE, CVSS, MISRA, CERT, for 40+ programming languages, using 1000+ built-in validation rules for Security, Deadcode & Best Practices Available a module for Software Composition Analysis (SCA) to find vulnerabilities in open source and third party libraries.
SonarLint
SonarLint is a free IDE extension available for IntelliJ, VS Code, Visual Studio, and Eclipse, to find and fix coding issues in real-time, flagging issues as you code, just like a spell-checker. More than a linter, it also delivers rich contextual guidance to help developers understand why there is an issue, assess the risk, and educate them on how to fix it.
Help make this list better
Suggest Tools
Frequently Asked Questions
What are T-SQL tools?
Transact-SQL (T-SQL) is an extension of SQL, the Structured Query Language, used by Microsoft SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse and SQL Server Analysis Services (SSAS). T-SQL is the primary language for Microsoft SQL Server, Azure SQL Database and Azure SQL Data Warehouse. T-SQL is also used in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
What are the best T-SQL static analysis tools and linters?
The most popular T-SQL tools ranked by user votes are: Codacy, Fortify, SonarCloud, CAST Highlight, PT.PM.
Which T-SQL services are free for open source projects?
Commercial services with a free plan for open source include Codacy, SonarCloud, PT.PM, SonarLint.