r/DuckDB
I built a canvas for exploratory data analysis with DuckDB
- upvotes
- 22
- comments
- 0
Post
Highlighted: the lines this signal was extracted from
I've been working as a data engineer for about half a decade. A common problem I run into is "this pipeline broke, but why?" To figure it out I query the database, paste the results into a Miro board together with a diagram of the pipeline. Then there's usually a flurry of arrows and random notes. I've found that laying everything out visually on a canvas helps me reach that "aha!" moment where I understand how all the pieces fit together. But what if I could do it all in one place instead of going back and forth between a canvas and querying databases? That led to me building Kavla! Kavla is a canvas for exploratory analysis. You can write SQL, paste images, make charts and then draw on them! You can also connect an agent and ask it to investigate a question, and have it generate custom data viz using React. It's built with DuckDB and tldraw. DuckDB is a great fit. It's very performant for files and there are already extensions for integrating other databases. Right now I've implemented Postgres and BigQuery, but will add more if anyone asks:-) It's open source: https://github.com/aleda145/kavla Try it in your browser: https://kavla.dev/ (DuckDB WASM is amazing)