We’ve built SQLRooms, an open-source framework for creating single-node data analytics apps powered by DuckDB.
It lets you build fully client-side, data-centric apps using React and DuckDB running in the browser (via WebAssembly) or in Electron. No server or backend is required — apps can work offline, preserve data privacy, and run queries on large datasets with sub-second performance.
Features:
- Query large datasets in browser with DuckDB (WASM)
- Modular design for building composable data UIs (query editors, dashboards, notebooks, etc.)
- Data privacy-preserving AI assistant that can write and execute SQL queries
- Integrations with various visualization libraries
Check live examples: https://sqlrooms.org/examples
Learn more: https://sqlrooms.org
Code: https://github.com/sqlrooms/sqlrooms
Would love feedback, ideas, or suggestions!