Databases
SQL Studio supports a wide range of SQL databases and file formats. Each database has its own subcommand with specific arguments.
Supported Databases
| Database | Subcommand | Type |
|---|---|---|
| SQLite | sqlite | Local file |
| libSQL | libsql | Remote server |
| Local libSQL | local-libsql | Local file (libSQL driver) |
| PostgreSQL | postgres | Remote server |
| MySQL / MariaDB | mysql | Remote server |
| DuckDB | duckdb | Local file |
| Parquet | parquet | Local file |
| CSV | csv | Local file |
| ClickHouse | clickhouse | Remote server |
| Microsoft SQL Server | mssql | Remote server |
General Syntax
sql-studio [OPTIONS] <SUBCOMMAND> [ARGS...]Global options like --address, --timeout, and --base-path can be placed before the subcommand. See Configuration for details.