dbLinter for VS Code

dbLinter is a tool suite for assessing and improving the quality of database applications. It uses static code analysis and database queries governed by a centrally managed configuration.

dbLinter targets all versions of Oracle AI Database, PostgreSQL, and APEXlang. It uses a predefined, configurable ruleset that originated with the Trivadis Coding Guidelines and has since evolved beyond them.

The dbLinter extension for Visual Studio Code uses its bundled language server to identify rule violations and provide quick fixes for supported URIs. It can also execute SQL-based tests and invoke commands through the CLI.

Your code is always analysed locally and never leaves your local environment.

Settings

The default settings are for an anonymous subscription plan. This means that only around 50 rules are active. These are the free rules from the Essential and Balanced profiles. Which is a reasonable set for any project using an Oracle Database.

To configure the set of rules to be applied, you need at least a Starter Subscription (Free).

Examples

Checks

Available with an Anonymous Subscription (Free).

Quick Fixes

Available with an Essential Subscription.

After applying Fix all problems:

Ignore Issue

Available with an Anonymous Subscription (Free).

After adding the @dbLinter ignore marker comment:

Ignore Issues in File

Available with an Anonymous Subscription (Free).

SQL-based Tests

Available with a Starter Subscription (Free).

CLI Integration

Available with an Essential Subscription.