Try live | GitHub repo | Open in StackBlitz
A comprehensive SQL query editor demonstrating SQLRooms' DuckDB integration. Features include:
- Interactive SQL editor with syntax highlighting
- File dropzone for adding data tables to DuckDB
- Schema tree for browsing database tables and columns
- Tabbed interface for working with multiple queries
- Query execution with results data table
- Support for query cancellation
- There is a version of the example with offline functionality which supports Progressive Web App (PWA) features, persistent database storage with OPFS, and state persistence via local storage
To create a new project from the query example run this:
npx giget gh:sqlrooms/examples/query my-new-app/npm install
npm run dev