Sleek vs SQL Formatter

Sleek is a command-line SQL formatter for applying consistent styles across SQL files. Its configurable options include indentation, keyword casing, and blank lines between queries. You can pass file paths or glob patterns, or provide input through standard input when no paths are supplied. The `--check` flag reports whether files are formatted without changing them. Sleek supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, and Oracle. Its VS Code extension can format documents or selections, check formatting, and optionally format on save or paste; it can also download the CLI when it is not found. The CLI is available as compiled binaries or through Cargo, which requires Rust, and the project directs users to choose a binary for their operating system and architecture. Sleek is available under the MIT License, with formatting handled by the `sqlformat` crate. Building release v0.4.0 requires Rust 1.85 or later. The listed plan is free, with a free plan and no free trial.

SQL Formatter is a free, MIT-licensed JavaScript library for pretty-printing SQL queries, with a browser demo and command-line tool. Formatting options include indentation; keyword, data type, function, and identifier case; logical operator placement; expression width; query spacing; and operator spacing. It supports dialects including BigQuery, ClickHouse, DB2, DuckDB, Hive, MariaDB, MySQL, TiDB, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, and Trino/Presto. The command-line tool accepts SQL from standard input or a file, can produce formatted output, and can update a file in place. The project also lists VS Code and Vim extensions, a Prettier plugin, and an ESLint integration. Its JSON Schema supports configuration-file autocompletion and IntelliSense, with usage guides for VS Code and Zed. The library can replace prepared-statement placeholders when parameter values are supplied. It does not support stored procedures or changing the delimiter from a semicolon. Templating syntax is not directly supported; a parameter-type workaround may not cover every construct. The maintainer describes the project as being in maintenance mode, with feasible bug fixes and likely no new features.