Sleek: SQL Formatter

Sleek is a CLI tool for formatting SQL files. It helps you maintain a consistent style across your SQL code, enhancing readability and productivity.

The heavy lifting is done by the sqlformat crate.

Features

Automatically format SQL files using customizable indentation and character case options.
Supports glob patterns, allowing you to format multiple files at once with ease.
Check whether your SQL files are already formatted without altering them.

To install Sleek, you'll need to have Rust installed on your system. Once Rust is installed, follow these simple steps:

bash cargo install sleek

bash sleek [FLAGS] [OPTIONS] <file_paths>...

-c, --check: Check if the code is already formatted. If not, it will exit with an error message.
-h, --help: Prints help information.
-V, --version: Prints version information.

-i, --indent_spaces <indent_spaces>: Set the number of spaces to use for indentation (default: 4).
-U, --uppercase <uppercase>: Change reserved keywords to ALL CAPS (default: true).
-l, --lines_between_queries <lines_between_queries>: Set the number of line breaks after a query (default: 1).

To format a single file with the default options:

bash sleek my_query.sql

To format multiple files using a glob pattern:

bash sleek "queries/*.sql"

To format files with custom options:

bash sleek --indent_spaces 2 --uppercase false "queries/*.sql"

To check if files are already formatted:

bash sleek --check "queries/*.sql"

This project is available under the MIT License.