Custom Rules for PL/SQL

Must-share information (formatted with Markdown):
SonarQube Developer Edition 8.6.1.40680
Trying to Achieve Custom Rules for PL/SQL.

Currently, we are able to evaluate our sql files and .sqlproj (Database development project) without any issues.

We want to add some custom rules like

  1. Avoiding DROP, ALTER TABLE/COLUMN statements.
  2. Any statement without specifying schema. Ex: tablename instead of [schemaname].[tablename]

Is it worth looking into this plugin? GitHub - gretard/sonar-sql-plugin: SQL language (T-SQL, MySQL and PostgreSQL dialects) plugin for SonarQube

Please suggest.

Hi,

Welcome to the community!

Custom rules are natively supported for PL/SQL via XPath 1.0 custom rules. You’ll find a rule template already available in SonarQube.

 
HTH,
Ann