rsql

Connect to database

$ rsql -d [database_url]

$ rsql -d [database_url] -c "[SELECT * FROM users]"

$ rsql -d [database_url] -f [query.sql]

$ rsql -d [database_url] -c "[query]" --csv

$ rsql -d [database_url] -c "[query]" --json

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

rsql is a command-line SQL client written in Rust that provides a unified interface for connecting to multiple database types including PostgreSQL, MySQL, and SQLite. 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, or formatted tables, making it suitable for both human reading and data pipeline integration. The -d flag specifies a database connection URL, while -c executes a query directly and -f runs a SQL file against the specified database.

-d URL

Database URL.

Execute query.

Run SQL file.

CSV output.

JSON output.

Table format.

Verbose mode.

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)