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.

Rules repository

You can already explore the rule repository with 160+ rules, detailed explanations and code examples.