sqlformater 1.0.0

Formater SQL written in Rust

sqlformater

sqlformater is a command-line tool (CLI) built in Rust, designed to automatically format SQL scripts. It supports individual files or entire directories and allows customized configuration via settings files.

🚀 Getting Started

Install with Cargo :

cargo install --git https://github.com/LugolBis/sqlformater.git

Install with pip :

pip install sqlformater

Usage :

sqlformater <PATHS> [OPTIONS]

📂 : Specify the files or folders to format

You can provide one or more of the following:

• One or more folder paths: formats all .sql files in the subdirectories.
• One or more .sql files: formats specific individual files.
• . or *: selects the current directory and all its subdirectories.

⚙️ Available Options

Option	Description
-logs_path=<FOLDER_PATH>, --logs_path=<FOLDER_PATH>	Specifies the folder where logs will be saved.
-settings_path=<PATH>, --settings_path=<PATH>	Path to the configuration file or the folder that contains it.
-verbose, --verbose	Enables verbose mode to display detailed execution information.
-status, --status	Shows diagnostic information: settings, logs, etc.
-help, --help	Displays general help.
-help-settings, --help-settings	Displays information about available configuration settings.

📘 Examples

Format all SQL files in the current directory and subdirectories:

sqlformater .

Format two specific files:

sqlformater tutu/queries/init.sql tutu/queries/update_users.sql

Format all files in a folder with a specific config file:

sqlformater home/tutu/migrations --settings_path=./config/settings.json

Enable verbose mode:

sqlformater * --verbose

🔧 Configuration

You can customize the formatter's behavior via a configuration file. To see the available settings:

sqlformater --help-settings