DuckDB

DuckDB (opens in a new tab) allows you to use Hashboard without setting up any external database.

DuckDB is a unique database amongst the types Hashboard supports. Traditional analytical databases are optimized to store massive quantities of data that can be retrieved at high speeds. While these databases are incredibly powerful, they often require a fair amount of work to set up.

DuckDB is instead focused on getting you up and running with analyzing a (smaller) dataset as quickly as possible. It can read common file types you likely already have: CSVs, JSON arrays, and more. DuckDB also runs on Hashboard's servers, so you don't need to set up (or pay for) any infrastructure to start querying a dataset.

This makes DuckDB perfect for one-off analysis, or for less technical users to get their data into Hashboard without setting up any servers. DuckDB is not a good choice if your dataset is large, or needs to be updated in realtime from an external system.

How to get set up

Hashboard pre-configures a DuckDB connection for every project. You are already ready to start exploring data files in your Hashboard project.

See Modeling with Uploaded Files for more information.