English | 日本語

sql-dialect-fmt

English | 日本語

sql-dialect-fmt is an opinionated Rust formatter and editor toolchain for Snowflake SQL and Databricks SQL. It follows the gofmt / Prettier / Biome style: few options, stable output, and formatting that is safe to run in CI.

Formatting is mechanically lossless and idempotent. Inputs that cannot be parsed pass through unchanged, significant tokens and comments are preserved, and format(format(x)) == format(x).

Install

# From crates.io
cargo install sql-dialect-fmt --version 1.22.3 --locked

# Directly from this repository
cargo install --git https://github.com/hjosugi/sql-dialect-fmt sql-dialect-fmt

# From a local checkout
cargo install --path crates/sql-dialect-fmt-cli

# Binary install, when using release assets with cargo-binstall
cargo binstall sql-dialect-fmt

# Homebrew, using this repository as a tap
brew tap hjosugi/sql-dialect-fmt https://github.com/hjosugi/sql-dialect-fmt
brew install sql-dialect-fmt

CI can use the bundled composite action or the GHCR image.

- uses: hjosugi/sql-dialect-fmt@v1
  with:
    args: "sql/**/*.sql"

docker run --rm -v "$PWD:/work" -w /work ghcr.io/hjosugi/sql-dialect-fmt:1.22.3 --check .

Try the browser playground from the docs site: https://hjosugi.github.io/sql-dialect-fmt/playground.html

Usage

sql-dialect-fmt query.sql                 # format to stdout
sql-dialect-fmt --write *.sql             # rewrite files in place
sql-dialect-fmt --check src/**/*.sql      # non-zero when files are not formatted
sql-dialect-fmt --check --diff query.sql  # show a unified diff for unformatted input
sql-dialect-fmt --lint src/               # lint (SDF001-SDF007): path:line:col findings, exit 1 when any
cat query.sql | sql-dialect-fmt           # stdin to stdout
cat query.sql | sql-dialect-fmt -         # explicitly read stdin with `-`
sql-dialect-fmt --stdin-filepath src/query.sql < query.sql  # use a path for config discovery
cat query.sql | sql-dialect-fmt --range 40:120  # reformat only statements in a byte range (stdin)

# Style: --keyword-case upper|lower|preserve / --select-item-layout auto|vertical
#        --comma-style trailing|leading / --line-width N / --indent-width N
#        --line-ending auto|lf|crlf

The shared defaults are line_width = 80, indent_width = 2, upper-case keywords, vertical top-level SELECT items, trailing commas, and automatic preservation of the input line ending. CLI, config, LSP, Wasm playground, and VS Code use the same option model and defaults.

pre-commit users can enable the official hooks:

repos:
  - repo: https://github.com/hjosugi/sql-dialect-fmt
    rev: v1.22.3
    hooks:
      - id: sql-dialect-fmt

Use sql-dialect-fmt-check instead when a hook should only verify formatting.

VS Code Extension

The VS Code extension in editors adds Snowflake SQL syntax highlighting and formatting. It registers a formatter for snowflake-sql files, so Format Document, Format Selection, and editor.formatOnSave all work with no external binary. It bundles the Rust formatter as WebAssembly and formats entirely on your machine.

./scripts/build-vscode-extension.sh

Then press F5 in editors/ (or install the packaged VSIX) and run Format Document on a .sql file. Formatting honors keyword case, vertical/automatic SELECT layout, leading/trailing commas, line width, line endings, and the active editor indentation.

Development

task test
task clippy
task vscode:build
task vscode:package
RUSTDOCFLAGS="-D warnings" cargo doc --workspace --no-deps
task fmt:check

Formatter feature flags

The default build keeps the core SQL formatter small and fast. Embedded JavaScript/Python body formatting remains available as an explicit feature while basic formatter and VS Code quality are the active priority:

cargo test -p sql-dialect-fmt-formatter --features external-formatters

Fine-grained features are available for embedders:

Status

Snowflake support covers SELECT, DML (INSERT/UPDATE/DELETE/MERGE), COPY, major DDL and object DDL (including Snowpipe CREATE PIPE ... AS COPY INTO), Semantic View, and CREATE PROCEDURE/CREATE FUNCTION bodies in SQL, JavaScript, Python, Java, and Scala. Non-SQL embedded body formatting is opt-in and otherwise stays verbatim. Databricks mode covers LATERAL VIEW, Delta DDL options, VERSION/TIMESTAMP AS OF, higher-order-function lambdas, SQL scripting blocks, and backtick identifiers.

SQL lifted out of a host language keeps formatting and highlighting: a ${ ... } template placeholder — a JavaScript template literal (`SELECT ${cfg.col} FROM ${cfg.t}`) or a Databricks/Spark/dbt ${var} substitution — is treated as one atomic token, with nested braces, quoted }, and nested template literals balanced so the statement still parses and the placeholder round-trips verbatim.

The workspace also includes an LSP server, semantic tokens, hover text, a CLI, and VS Code packaging. Tree-sitter sources remain in the repository but are paused outside the active workspace and CI. The LSP server discovers and applies the same sql-dialect-fmt.toml as the CLI (with editor settings layered on top), so an editor formats consistently with CI. The headline formatter feature is magic trailing comma. See ROADMAP.md for the detailed coverage map.

Crates

License

0BSD. You can use, copy, modify, and distribute this project for almost any purpose.