sarj-sql-lint

Custom SQL lint rules for Postgres migrations. AST-based via sqlfluff for the SARJ101 rule + zero-dependency pygrep regex hooks for migration-hygiene checks. Designed for pre-commit.

uv tool install sarj-sql-lint

Rules

Code	id	Flags
SARJ101	`enforce-timestamptz`	`TIMESTAMP` without `WITH TIME ZONE` — use `TIMESTAMPTZ`
SARJ102	`idempotent-ddl`	`CREATE TABLE/INDEX/EXTENSION/SCHEMA/SEQUENCE/TYPE`, `ADD COLUMN`, `DROP TABLE/INDEX` without `IF [NOT] EXISTS`
SARJ103	`no-pg-enum`	`CREATE TYPE ... AS ENUM` / `ALTER TYPE ... ADD VALUE` — use TEXT + CHECK constraint
SARJ104	`prefer-text-over-varchar`	`VARCHAR(n)` / `CHARACTER VARYING(n)` — use TEXT (+ CHECK length if needed)
SARJ105	`insert-requires-on-conflict`	`INSERT INTO` statement (multi-line aware) with no `ON CONFLICT` clause
SARJ106	`prefer-jsonb`	`JSON` column type or `::json` cast — use JSONB
SARJ107	`no-limit-offset`	`OFFSET` keyword — use cursor pagination (`WHERE id > :cursor ... LIMIT n`)
SARJ108	`index-concurrently`	`CREATE INDEX` without `CONCURRENTLY` — locks the table against writes
SARJ109	`prefer-uuidv7-default`	`gen_random_uuid()` (random UUIDv4) — use `uuidv7()` so keys are time-ordered

All scanning runs over a comment/string/dollar-quote-masked view of the source, so keywords inside --//* */ comments, '...' literals, $tag$...$tag$ bodies and "..." identifiers never match.

Suppression

Add a -- sarj-noqa comment on the offending line to silence a diagnostic; scope it to specific codes with -- sarj-noqa: SARJ101, SARJ108.

Pre-commit

- repo: https://github.com/sarj-ai/standards
  rev: sql-v0.1.0
  hooks:
    - id: sarj-enforce-timestamptz
      files: '\.sql$'
    - id: sarj-idempotent-ddl
      files: '\.sql$'
    - id: sarj-ban-postgres-enums
      files: '\.sql$'
    - id: sarj-ban-create-trigger
      files: '\.sql$'
    - id: sarj-prefer-text-over-varchar
      files: '\.sql$'
    - id: sarj-insert-requires-on-conflict
      files: '\.sql$'
    - id: sarj-prefer-jsonb
      files: '\.sql$'
    - id: sarj-no-limit-offset
      files: '\.sql$'
    - id: sarj-prefer-uuidv7-default
      files: '\.sql$'

CLI

sarj-sql-lint check --rule enforce-timestamptz svcs/db/db/migrations/*.sql
sarj-sql-lint list-rules

Diagnostic format is path:line:col: CODE message — Ruff-compatible.

Each rule's source under src/sarj_sql_lint/rules/ carries its own description and diagnostic message.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sarj_sql_lint-0.3.0.tar.gz (10.7 kB view details)

Uploaded Jul 27, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

sarj_sql_lint-0.3.0-py3-none-any.whl (18.3 kB view details)

Uploaded Jul 27, 2026 Python 3

File details

Details for the file sarj_sql_lint-0.3.0.tar.gz.

File metadata

Download URL: sarj_sql_lint-0.3.0.tar.gz
Upload date: Jul 27, 2026
Size: 10.7 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: uv/0.11.32 {"installer":{"name":"uv","version":"0.11.32","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for sarj_sql_lint-0.3.0.tar.gz
Algorithm	Hash digest
SHA256	`93f48728ba6a50dbccabd20c9b26a077b9700585af5da8fde6ab62c0542389a8`
MD5	`6375607d8f3e744ac4982b67744a35b3`
BLAKE2b-256	`b1c9f2ddd379a67b0394b79885e4c0bea96ea9c42b7e59eed5fac8d6872552b0`

See more details on using hashes here.

File details

Details for the file sarj_sql_lint-0.3.0-py3-none-any.whl.

File metadata

Download URL: sarj_sql_lint-0.3.0-py3-none-any.whl
Upload date: Jul 27, 2026
Size: 18.3 kB
Tags: Python 3
Uploaded using Trusted Publishing? No
Uploaded via: uv/0.11.32 {"installer":{"name":"uv","version":"0.11.32","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for sarj_sql_lint-0.3.0-py3-none-any.whl
Algorithm	Hash digest
SHA256	`468e5c8392b8e765ac8b574dd72f69b108a5d7febe8a88453136ab79ce2e2778`
MD5	`b5c9aff6b3161274769fe5d8b08b9f97`
BLAKE2b-256	`7dd2cb4d6bcc509883d226cb764c23a3441a092a5b11ea94e2a220a4dcbd5e92`