SQLRooms

Website Example projects GitHub

SQLRooms is an open-source library that provides a foundation and set of building blocks for creating data analytics applications that run entirely in the browser. It combines essential components like a SQL query engine (DuckDB), data visualization tools, state management, and UI components into a cohesive toolkit, making it significantly easier to create powerful analytics tools without a backend.

The project grew out of work on geospatial and mobility analysis tools where users need fast SQL, interactive charts, maps, notebooks, and shareable application state in one environment. SQLRooms is designed for local-first workflows: data can stay on the user's machine, while the application still feels like a polished analytical product rather than a loose collection of scripts.

I work on the framework architecture, examples, AI-assisted SQL workflows, and reusable application patterns for dashboards, notebooks, collaborative canvases, and map-based analytics.