Skip to content
DuckDB community extension

duckdbi

Browser-based BI dashboard extension for DuckDB. Run SQL queries and build interactive dashboards with drag-and-drop charts, all from the DuckDB CLI.

01 / SETUP

Install and load

Run these commands in a Haybarn SQL session. The extension is available from the community repository.

Haybarn 2.0.0 · SQL
INSTALL duckdbi FROM community;
LOAD duckdbi FROM community;

Try it in a temporary SQL session with duckdbi already loaded. Queries run in this tab; examples using files or services need their own setup.

Using upstream DuckDB? Follow the maintainer’s installation instructions.

02 / QUERY

Usage example

Start the BI server on port 8080

SQL
-- Load the extension

-- Start the BI server on port 8080
SELECT duckdbi_start('localhost', 8080);

-- Open http://localhost:8080 in your browser
-- Write SQL, create charts, build dashboards

-- Stop the server when done
SELECT duckdbi_stop();

Provided by nkwork9999. Not yet verified on Haybarn 2.0.0.

Sample data & setup

About this extension

DuckDBI turns DuckDB into a local BI server. The extension embeds a full single-page application with a simple SQL query and results screen. Advanced dashboards and reports are available at /advanced.

Architecture: The extension bundles an HTTP server (cpp-httplib) and a complete SPA as a compiled-in string literal. The /api/query endpoint executes SQL against the attached DuckDB database and returns JSON results to the browser frontend. No external server or setup required.

Project overview from the community descriptor.

Documentation and resources

Project and build details
Repository
nkwork9999/DuckDBI
License
MIT
Maintainers
nkwork9999
Written in
C++
Build source
87e34e337b32
Build definition
Community descriptor