Introduction
Welcome to rsql
, a powerful and flexible command-line SQL interface for working with data from a wide variety of
sources. Whether you are a data engineer, analyst, or developer, rsql
is designed to make querying, transforming, and
exploring data fast and productive.
What is rsql?
rsql
is a cross-platform CLI tool that connects to many different databases and file formats, including relational
databases (PostgreSQL, MySQL, MariaDB, SQL Server, CockroachDB, Redshift, Snowflake, DuckDB, LibSQL, SQLite, and more),
as well as data files (CSV, JSON, Parquet, Arrow, Avro, Excel, XML, YAML, and others). It supports both local and remote
data sources.
Why use rsql?
- Unified SQL interface: Query many data sources with a consistent SQL syntax and experience.
- Automation: Integrate with scripts and automation pipelines for data processing.
- Productivity: Features like smart completions, history, and formatting make interactive work efficient.
- Portability: Works on Linux, macOS, and Windows, with support for multiple CPU architectures.
- Extensibility: Easily configure output formats, themes, and behaviors to fit your workflow.
When to use rsql?
- When you need to quickly query or transform data from different sources without switching tools.
- When you want to automate data tasks in scripts or CI/CD pipelines.
- When you need a lightweight, installable SQL client for local or remote databases.
- When you want to explore, analyze, or export data in various formats.
Continue to Getting Started for a quick setup and usage guide.