Skip to main content

SQL clients

A desktop SQL client does not read your bucket by itself. It connects to an engine: either DuckDB running inside the client, which reads your bucket or table directly with a short setup script, or a warehouse such as Trino, Athena or BigQuery that you have already pointed at the data. Pick DuckDB when you have no warehouse; it needs only a read-only storage key.

ToolConnect throughPage
DBeaverDuckDB driver with an init script; Trino, Athena, BigQuery, ClickHouse, PostgreSQL or MySQL connectionDBeaver
DataGrip and other JetBrains IDEsDuckDB data source with a startup script; Trino, Athena, BigQuery, ClickHouse, PostgreSQL or MySQL data sourceDataGrip
TablePlusDuckDB connection with bootstrap commands; BigQuery, ClickHouse, PostgreSQL or MySQL connectionTablePlus
DuckDB UI and HarlequinDuckDB started with an init script; Harlequin also has Trino, PostgreSQL and BigQuery adaptersDuckDB UI and Harlequin

Every DuckDB path runs the same statements: the CREATE SECRET, ATTACH and CREATE VIEW for your destination from DuckDB, saved in a file the client runs when it connects. After that, the example queries work unchanged.