DuckDB + React = SQLRooms Framework for Analytics Apps Without Backend

What it does

An open source React toolkit for human + agent collaborative analytics apps

Pick and choose the functionality you need for composable, extensible applications, with integrations for popular data visualization libraries. Work with your data, run queries, and analyze results even without an internet connection. SQLRooms supports offline workflows using persistent storage via OPFS. import { createRoomShellSlice, createRoomStore, RoomShellSliceState, RoomShell, } from '@sqlrooms/room-shell' ; import {useSql} from '@sqlrooms/duckdb' ; type RoomState = RoomShellSliceState ; const { roomStore , useRoomStore } = createRoomStore < RoomState >( ( set , get , store ) => ({ ... createRoomShellSlice ({ config: { dataSources: [ { type: 'url' , tableName: 'earthquakes' , url:…from sqlrooms.org

In the maker’s words, at launch

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…

• DU
  Duck-UI – Browser-Based SQL IDE for DuckDB2025 · demo.duckui.com · ▲213

  I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV&#x2F;JSON&#x2F;Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…

• SO
  SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

  SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

• 
  The DuckDB Local UI2025 · github.com · ▲193

  Easily explore local data files with DuckDB

• 
  Restdb.io – a plug and play database service2016 · restdb.io · ▲101

  Simple online database service in the cloud with NoSQL, REST API, low code javascript hooks, MongoDB support and more. Perfect for API automation, custom development, enterprise, backoffice, serverless backends, database driven websites. It provides easy collaboration and data management with secure

• 
  GoatDB – A lightweight, offline-first, realtime NoDB for Deno and React2025 · github.com · ▲90

  Hey HN, We've been experimenting with a real-time, version-controlled NoDB for Deno & React called GoatDB. The idea is to remove backend complexity while keeping apps fast, offline-resilient, and easy to self-host. Runs on the client – No backend required, incremental queries keep things efficient. Self-hosted & lightweight – Deploy a single executable, no server stack needed. Offline-first & resilient – Clients work independently & can restore state after server outages. Edge-native & fast – Real-time sync happens locally with minimal overhead. Why We Built It: We needed something that’s…

• 
  SQL workbench in the browser2024 · sql-workbench.com · ▲117

  Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.

• 
  Spira Maxima▲578

  Video model that turns script into viral social media videos

  AI · 17d ago · spira.ai

• 
  Rill Browser▲540

  The browser where Claude Code and Codex work beside you

  AI · 17d ago · rill.love

• 
  Germany's new sovereign AI model Kolibri▲424

  Kolibri is Aleph Alpha

  AI · 19d ago · tej.as

• 
  Giving Opus 5.5 a simulated paint canvas▲392

  Paintings by AI models: programs run through a simulation of oil paint.

  AI · 20d ago · stillwet.art

• 
  PixVerse R2▲381

  A real-time world model you can explore and change

  AI · 29d ago · world.pixverse.video

• 
  Hemory▲381

  Keep listening. Searchable memory for your AI agents.

  AI · 30d ago · hemory.com

• 
  Clueso▲1,300

  Create stunning product videos in minutes with AI

  AI · 2025 · clueso.io

• 
  Trickle - Magic Canvas ▲1,064

  Hey HN! Introducing Trickle Magic Canvas: the world’s first Agentic Canvas, where you can visually co-create apps and websites with AI, from idea to production. Why is a canvas better? Most AI tools today rely on linear chats or text prompts. We believe that limits creativity and clarity. Canvas changes the game. 1. Every version & page at a glance. Each page and sub-page lives on a timeline. You can quickly browse, edit, and preview progress like a living, visual document — no more digging through chat logs or scattered states. 2. The canvas is the context. Unlike linear chats, you can…

  AI · 2025 · trickle.so

• TB
  Tinder but it's only pictures of my wife and I can only swipe right▲1,030

  Life & fun · 2025 · trytender.app

• 
  Ten years of running every day, visualized▲958

  Today marks ten years, 3653 consecutive days, of running at least one mile every day under the USRSA rules [1]. To celebrate, I built an interactive dashboard that turns a decade of GPX files into charts you can explore. Running has truly changed my life: I've made lifelong friends, explored beautiful places, and more importantly invested into my own health and fitness, which I'm starting to see the positive benefits as I get older. The stack is pretty simple: a NextJS app, with a Postgres database to keep all my running data, and all the stats are pre-computed and cached in Redis, so I…

  Dev tools · 2025 · nodaysoff.run

• 
  Draw a fish and watch it swim with the others▲935

  Made this website as an exercise in vibe-coding and GCP. It was posted about a few times around the internet, on sites like Morning Brew (https:&#x2F;&#x2F;www.morningbrew.com&#x2F;issues&#x2F;business-buzzkill), MetaFilter (https:&#x2F;&#x2F;www.metafilter.com&#x2F;209703&#x2F;Draw-A-Fish), boingboing.net, etc. I think it's cute! I built a basic CNN trained against penises and swastikas, and then anything that doesn't hit the 63% confidence score gets sent to a mod queue, a vibe-coded fish-tinder…

  AI · 2025 · drawafish.com

• 
  Use Their ID – Use your local UK MP’s ID for the Online Safety Act▲862

  Hi HN - I made a site that takes a UK postcode, grabs the local MP's information and generates an AI mockup of what their ID might look like. It's a small, silly protest at the stupidity of the Online Safety Act that just came into force. edit - My open AI credits got hugged to death, please use a known postcode (like one from Kier Starmer's constituency, WC2B6NH) in the meantime.

  AI · 2025 · use-their-id.com