Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
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.
Usage example
Start the BI server on port 8080
-- 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 & setupAbout 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