sql-neatfmt 0.1.1

A compact SQL formatter with dialect-aware parsing.

sql-neatfmt

sql-neatfmt is a compact SQL formatter designed for editor use. It uses SQLGlot for dialect-aware parsing and owns the final layout rules.

The formatter intentionally favors readable query editing:

SELECT a.id,
       a.name,
       b.code code_name
FROM table_a a
         LEFT JOIN table_b b
           ON a.id = b.a_id
          AND b.deleted = 0
WHERE a.status = 1
  AND a.created_at >= DATE '2026-04-01'
GROUP BY a.id
ORDER BY a.id DESC;

Usage

sql-neatfmt --dialect mysql < query.sql
sql-neatfmt --dialect postgres query.sql
sql-neatfmt --dialect oracle --fix query.sql
sql-neatfmt --dialect mysql --keyword-case lower query.sql
sql-neatfmt --dialect mysql --check query.sql
sql-neatfmt --dialect mysql --diff query.sql

Keywords are uppercased by default. Use --keyword-case lower or --no-uppercase-keywords to emit lowercase keywords instead.

Use --check in CI or editor hooks to fail when SQL would be reformatted. Use --diff to print a unified diff without modifying files.

Installation

Install from a local checkout:

uv tool install --from ~/repos/sql-neatfmt sql-neatfmt

Install from a Git checkout:

uv tool install git+https://github.com/LuciusChen/sql-neatfmt

After publishing to PyPI:

uv tool install sql-neatfmt

Build release artifacts:

uv build --no-sources

Publish to PyPI from GitHub Actions:

1. Create a PyPI pending trusted publisher for sql-neatfmt.
2. Use owner LuciusChen, repository sql-neatfmt, workflow publish.yml, and environment pypi.
3. Run the Publish workflow from GitHub Actions, or publish a GitHub release.

Publish from this checkout after setting a PyPI token:

uv publish --check-url https://pypi.org/simple/

Supported initial dialect names follow SQLGlot: mysql, postgres, oracle, sqlite, tsql, and others accepted by SQLGlot.

Scope

This is intentionally conservative. Parse failures, comments, and templated SQL are returned unchanged rather than risk corrupting the query.