rsql

rsql [--url url] [-c query | -f file] [options]

rsql is a command-line SQL client written in Rust that provides a unified interface for connecting to many database engines, including PostgreSQL, MySQL, MariaDB, SQLite, DuckDB, Redshift, Snowflake, SQL Server, and others. It supports both interactive mode for exploratory queries and batch mode for running SQL files and single commands from scripts.Output can be formatted as CSV, JSON, Markdown, HTML, or formatted tables, making it suitable for both human reading and data pipeline integration. The --url flag specifies a database connection URL, while -c executes a query directly and -f runs a SQL file against the specified database.

--url URL

Database connection URL (e.g. `postgres://user:pass@host/db`, `mysql://...`, `sqlite://path`).

Execute one or more semicolon-separated SQL commands and exit.

Execute commands from an SQL script file and exit.

Output format: ascii, csv, expanded, html, json, jsonl, markdown, plain, psql, sqlite, tsv, unicode, xml, yaml.

Shorthand for `--format csv`.

Shorthand for `--format json`.

Colorize output: always, auto, or never.

Syntax highlighting theme (e.g. solarized-dark, base16-ocean.dark).

Echo commands before execution: on, off, prompt.

Print the elapsed time for each command.

Enable command history.

Display help information.

Display version information.

Connection string required. Database drivers needed. Rust-based tool.

rsql is a command-line SQL client written in Rust, providing a unified interface for multiple database types.

psql(1), mysql(1), sqlite3(1)