Need recommended list of free static code analysis tool to inspect SQL files

James J 606 Reputation points
2021-10-26T13:13:55.71+00:00

Hi,

In the market we have many paid version of static code analysis tools to check many programming languages and scripts. I would like to know, Do you have any recommended static code analysis (free) tool to analyze SQL files.
Requirement: It has to inspect the SQL script quality and security.

Please share the details. Will be helpful.

Thanks,
J

SQL Server | Other
0 comments No comments
{count} vote

Accepted answer
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2021-10-26T22:07:07.53+00:00

    I saw a flash for something called SQL Fluff today: https://docs.sqlfluff.com/en/stable/. It was described as an open-source SQL Linter. There is also a VS Code extension: https://marketplace.visualstudio.com/items?itemName=dorzey.vscode-sqlfluff.

    I only saw this today, and I have not had the time to try it myself.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,771 Reputation points
    2021-10-26T14:27:02.423+00:00

    That is functionality built-in to the SSDT add-in for Visual Studio for common problems.

    https://learn.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/dd172133(v=vs.100)

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.