SQL Atlas v0.6.0

Analysis accuracy

• PostgreSQL-aware scanning masks strings, nested comments and dollar-quoted bodies before structural rules run.
• PL/pgSQL function bodies no longer split at internal semicolons.
• NOT IN subqueries no longer produce duplicate generic findings.
• NATURAL JOIN and commas inside GROUP BY functions are handled correctly.

Rule configuration

• Use --config <file> with the CLI or config with the GitHub Action.
• Use --ignore <rules> with the CLI or ignore with the Action.
• Add -- sql-atlas-ignore rule-id to a SQL file for a local suppression.
• Invalid values and unknown rule IDs produce clear configuration errors.

Verification

• 71 automated tests
• CLI and GitHub Action builds verified
• GitHub Action smoke workflow passed
• npm package contains 5 files and has zero runtime dependencies

SQL Atlas v0.5.1

Patch release for the first public npm registry publication.

• Preserve the sql-atlas executable in npm package metadata
• Normalize the repository URL used by npm
• Keep the package at five files with zero runtime dependencies
• Use the public npm command in CLI documentation

Run:

npx --yes sql-atlas@0.5.1 analyze query.sql

SQL Atlas v0.5.0

SQL Atlas can now analyze SQL files directly in GitHub Actions.

GitHub Action

• Select SQL files with newline-separated glob patterns
• Add file and line annotations to workflow runs and pull requests
• Write a Markdown analysis report to the job summary
• Expose file count, finding count and lowest score as outputs
• Enforce severity and minimum score policies
• Run from a bundled Node.js 24 action without runtime downloads

- uses: actions/checkout@v7
- uses: milekv/sql-atlas@v0.5.0
  with:
    paths: migrations/**/*.sql
    dialect: postgresql
    fail-on: critical
    min-score: 60

CLI packaging

The attached CLI package now has zero runtime dependencies. It reads SQL from files or standard input and supports text, JSON and Markdown reports.

npx --yes https://github.com/milekv/sql-atlas/releases/download/v0.5.0/sql-atlas-0.5.0.tgz analyze query.sql

Web demo: https://milekv.github.io/sql-atlas/

SQL Atlas v0.4.0

SQL Atlas can now run the same deterministic SQL analysis from a terminal.

CLI

• Analyze one or more SQL files or standard input
• Select PostgreSQL, MySQL, Oracle, SQLite, SQL Server or generic SQL
• Produce text, JSON or Markdown reports
• Write reports to a file
• Enforce --fail-on severity and --min-score policies in CI
• Use stable exit codes for success, policy failures and input errors

Install and run

npx --yes https://github.com/milekv/sql-atlas/releases/download/v0.4.0/sql-atlas-0.4.0.tgz analyze query.sql

The attached tarball is an npm-compatible package. Analysis is local and does not upload SQL.

Web demo: https://milekv.github.io/sql-atlas/

SQL Atlas v0.3.0

SQL Atlas runs SQL analysis locally in the browser. This release combines the query analyzer with working PostgreSQL EXPLAIN and schema visualization tools.

Included

• Deterministic SQL checks and index suggestions
• Markdown analysis reports
• PostgreSQL EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) parsing
• Execution plan tree, metrics and warnings
• PostgreSQL CREATE TABLE parsing
• Table, column, key and foreign key visualization
• English and Polish interface

Try it without installing anything: https://milekv.github.io/sql-atlas/

All processing stays in the browser. SQL and execution plans are not uploaded.