Selecting an Adapter
Harlequin uses adapter plug-ins as a generic interface to any database. Harlequin ships with adapters for DuckDB (the default) and SQLite; additional adapters can be installed by installing additional pip
packages in the same virtual environment as Harlequin, or by installing Harlequin while specifying extras.
To select an adapter other than DuckDB, you use the --adapter
option (alias -a
) at the command-line:
$ harlequin -a sqlite
Each adapter has its own configuration options, detailed in their own section in these docs. Harlequin --help
option will dynamically include the options for all installed adapters so you can easily reference them.
Core Adapters
Core adapters are created and maintained by the maintainers of Harlequin.
- DuckDB
- SQLite
- Postgres (also supports Redshift)
- MySQL
- ODBC (supports MS SQL Server, Oracle, and others)
Community Adapters
Community adapters are created and maintained by other members of the Harlequin community. To add your adapter to this list, please open a PR.
- BigQuery, contributed by Josh Temple
- Trino, contributed by Tyler Hillery
- Databricks, contributed by Zach Shirah and Alex Malins
- ADBC, contributed by Tyler Hillery. Supports Snowflake and more.
- RisingWave, contributed by ZhengYu Xu
- Wherobots, contributed by Wherobots
- Cassandra, contributed by Vadim Khitrin
- NebulaGraph, contributed by Wey Gu
- Coming soon: Snowflake, contributed by Ryan Murray