Dash

Dash is an open-source platform for data exploration and visualization designed to operate fully locally, either in the browser or as a DuckDB extension. It provides a visual SQL workspace where users can explore, analyze, and interact with their data without the need for cloud services, ensuring that all processing and data storage remain on the user's device. The platform is suitable for those who want a privacy-focused, local-first solution for working with data, offering flexibility for both browser-based and DuckDB-integrated workflows.

A core feature of Dash is its data canvas, which allows users to arrange SQL nodes on an infinite canvas, connect them, and observe data flow in real time. Users can display query results in various formats such as tables, bar charts, and line charts, each with interactive components. ref_<name() in SQL. Downstream nodes automatically re-run when changes occur, and interactive views enable nodes to forward only selected rows to subsequent nodes, allowing for dynamic, responsive data exploration.

Dash supports effortless data import through drag-and-drop functionality for files in various formats, requiring no configuration. Users can create and customize dashboards with a range of visualizations, and the platform offers persistency by saving data and workspaces in the browser for future sessions. An AI assistant feature is also available, enabling users to bring their own AI to help generate queries and visualizations.

The tool can be accessed directly as a web app, with all operations and data storage handled locally in the browser, or it can be embedded as a community extension within DuckDB, making it accessible from any DuckDB connection, including CLI, notebooks, or any language with a DuckDB driver. Dash is open source, and its documentation and code are available via GitHub.