Playground

Lint PostgreSQL in your browser.

The same parser the published plugin uses — libpg-query — compiled to WebAssembly and running entirely on this page. Nothing is sent to a server. Pick a preset, edit the SQL, toggle rules.

Diagnostics

No issues found.

65 rules enabled.

Rules 65 / 89

no-syntax-error
no-select-star
require-where-in-delete
require-where-in-update
no-drop-table-cascade
no-truncate-cascade
no-cross-join
no-natural-join
consistent-jsonb-over-json
consistent-identity-over-serial
require-primary-key
consistent-text-over-varchar
consistent-timestamptz
no-money-type
no-char-type
no-grant-to-public
consistent-create-index-concurrently
no-not-in-subquery
snake-case-table-name
snake-case-column-name
no-implicit-join
require-limit
no-order-by-ordinal
no-group-by-ordinal
no-distinct-on-without-order-by
no-leading-wildcard-like
no-add-column-not-null-without-default
no-select-into
prefer-coalesce-over-case
no-having-without-group-by
no-identifier-too-long
no-alter-column-type
no-rename-column
no-rename-table
no-drop-column
no-drop-not-null
consistent-fk-not-valid
require-named-constraint
no-unlogged-table
no-temporary-table
no-numeric-without-precision
no-time-type
no-set-not-null
no-set-search-path
require-schema-qualified-table
prefer-explicit-null-ordering
no-vacuum-full
no-cluster
no-composite-primary-key
no-drop-database
no-drop-schema-cascade
consistent-reindex-concurrently
no-create-role
prefer-bigint-id
align-column-definitions
align-values
no-equality-with-null
no-on-delete-cascade
no-rule
no-security-definer-without-search-path
no-unnecessary-quoted-identifier
no-update-primary-key
no-update-without-from-binding
no-with-recursive-without-limit
plpgsql-keyword-case
prefer-add-constraint-not-valid
consistent-as-for-column-alias
consistent-as-for-table-alias
consistent-between-over-and
prefer-cast-operator
consistent-create-or-replace
prefer-current-timestamp-over-now
consistent-drop-index-concurrently
consistent-explicit-inner-join
consistent-explicit-outer-join
prefer-in-list-over-or
prefer-keyword-case
prefer-not-equals-operator
require-if-exists
require-on-delete-action
require-trailing-semicolon
no-add-check-constraint-without-not-valid
no-add-unique-constraint-directly
no-volatile-default-on-add-column
no-grant-all
prefer-exists-over-in-subquery
require-fk-include-columns
require-table-columns
require-index-on-fk-column

Reading the diagnostics

error — rules whose violation is almost certainly a bug.
warn — best-practice rules with legitimate exceptions.
off — off by default; opt in when it suits your project.

Heads up: the playground runs a faithful reimplementation of the production rules against libpg-query's AST. The README in the repository is the authoritative description of behaviour; if you spot a discrepancy, please open an issue.