Sleek vs Squawk

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.

Squawk is an open-source linter and language server for PostgreSQL migrations and SQL. It checks schema changes for risks that could prevent database reads or writes. Its rules flag potentially unsafe statements, incompatible changes, and migration patterns, with messages that include examples and reasoning. The command-line tool lints SQL files, and a language server and VS Code extension provide editor linting.

For pull requests, a GitHub Action can lint modified migrations; Squawk can also comment through its upload-to-github command or GitHub App. For CI outside GitHub Actions, the documentation recommends configuring the GitHub App, citing CircleCI as an example. Installation options include npm, PyPI, release binaries, Docker, the browser playground, and VS Code. The playground uses WebAssembly to lint SQL in a browser. Configuration can set the PostgreSQL version, include or exclude rules and paths, and specify whether SQL files are assumed to run in transactions. Some rules are disabled by default and require explicit enabling. Squawk supports PostgreSQL only and has no automatic fixes or custom rules.