dbLinter rules repository

This is the repository for dbLinter rules. Here you can find all the rules that dbLinter uses to check your database code.

You can see all rules at once or browse by quality area, tags, severity levels and fixing times.

The rule detail pages will give you insights into the reasons why such a rule improves your code quality. It shows non-compliant and compliant examples and parameters with which you can customize the rules to your needs.

Where can I get dbLinter?

dbLinter will be available soon. If you want to get updated on the progress, subscribe to the newsletter.

What is dbLinter?

Boost database quality with automated code checks, fixes and tests.

dbLinter is a suite for checking and improving the quality of database applications. Quality is assessed against a configured set of rules using static code analysis and database queries. Quick fixes will be offered where available. Selected findings can be ignored. This prevents them from appearing in subsequent analysis runs.

dbLinter targets all versions of Oracle Database and PostgreSQL. It covers files containing SQL, PL/SQL, PL/pgSQL, SQL*Plus, SQLcl and psql for static code analysis. It provides predefined tests to validate your data model to find tables without primary keys, tables without relationships, missing foreign key indexes and much more. If parameterising predefined rules and tests is not enough, you can even define your own rules, checks and tests.

If you are familiar with the Trivadis PL/SQL & SQL Coding Guidelines, or if you have used the discontinued db* CODECOP, or if you want to ensure that your database applications maintain a predefined quality level, then dbLinter is the right choice for you.