Sleek vs Sqruff

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.

Sqruff is a free SQL linter and formatter written in Rust, focused on formatting valid SQL for particular dialects and providing linting and fixes. It offers configurable automated formatting, custom rules, and column-level data lineage analysis for SQL queries. Dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, and Trino, among others. Dialect and rule settings are read from a project `.sqruff` configuration file. Developers can use the maintained VS Code and Zed integrations, or an LSP server with other LSP-capable editors. A documented GitHub Action supports use in CI, and a browser playground is available. Installation options include Homebrew, a bash installer, pip, cargo, binary releases, and an official Docker image. The public repository provides an Apache-2.0 license. The project identifies dbt project support as experimental and is associated with Quary, an open-source analytics platform for engineers based in the United Kingdom.