Meta tags:
description=An open source React toolkit for human + agent collaborative analytics apps;

Headings (most frequently used words):

data, sqlroomsbuild, centric, apps, with, duckdb, local, analytics, no, backend, required, own, your, privacy, preserving, ai, integration, modular, architecture, modern, ui, components, offline, use, get, started, in, minutes, manual, setup, case, studies,

Text of the page (most frequently used words):
and (14), data (10), for (9), with (9), sqlrooms (9), the (7), trademarks (7), openjs (5), foundation (5), #analytics (5), const (5), list (4), use (4), policy (4), trademark (4), that (4), duckdb (4), from (4), earthquakes (4), set (4), get (4), minimal (4), your (4), privacy (3), started (3), you (3), app (3), store (3), visualization (3), backend (3), example (3), maxmagnitude (3), istableready (3), roomshell (3), roomstore (3), queries (3), run (3), without (3), offline (3), apps (3), all (2), registered (2), see (2), not (2), are (2), them (2), applications (2), built (2), case (2), studies (2), comprehensive (2), can (2), required (2), github (2), row (2), max (2), magnitude (2), return (2), queryresult (2), usesql (2), state (2), useroomstore (2), mycomponent (2), url (2), type (2), createroomshellslice (2), roomstate (2), createroomstore (2), roomshellslicestate (2), import (2), room (2), npm (2), examples (2), view (2), llms (2), txt (2), documentation (2), full (2), react (2), components (2), functionality (2), sql (2), local (2), copyright, vis, contributors, rights, reserved, has, uses, please, our, logos, indicated, their, respective, holders, does, imply, any, affiliation, endorsement, cookie, code, conduct, bylaws, terms, deploys, supported, chordshell, com, transcality, cosmograph, flowmap, city, foursquare, spatial, desktop, real, world, more, guide, page, getting, key, concepts, just, flexible, extended, various, modules, powered, client, side, complete, earthquake, toarray, loading, enabled, select, query, number, findtablebyname, boolean, function, myroom, export, https, parquet, tablename, datasources, config, shell, tsx, simple, loads, single, table, manual, setup, dev, install, giget, npx, create, new, project, minutes, llm, optimized, markdown, bundle, work, analyze, results, even, internet, connection, supports, workflows, using, persistent, storage, via, opfs, including, tables, layouts, tools, building, beautiful, interfaces, modern, pick, choose, need, composable, extensible, integrations, popular, libraries, modular, architecture, agents, write, execute, generate, insights, sharing, model, providers, preserving, integration, remains, device, maximum, sub, second, large, datasets, own, leverage, powerful, capabilities, enabling, fast, browser, processing, what, open, source, toolkit, human, agent, collaborative, build, centric, appearance, overview, home, main, navigation, ctrl, search, skip, content,

Text of the page (random words):
sqlrooms skip to content sqlrooms search ctrl k main navigation home overview examples case studies get started appearance sqlrooms build data centric apps with duckdb an open source react toolkit for human agent collaborative analytics apps what is sqlrooms example apps view on github local analytics no backend required leverage duckdb s powerful sql capabilities enabling fast in browser data processing without a backend own your data data remains on your local device for maximum privacy sub second analytics on large datasets and offline functionality privacy preserving ai integration use agents that can write and execute sql queries and generate insights without sharing your data with model providers modular architecture pick and choose the functionality you need for composable extensible applications with integrations for popular data visualization libraries modern ui components comprehensive set of react components including data tables layouts and visualization tools for building beautiful analytics interfaces offline use work with your data run queries and analyze results even without an internet connection sqlrooms supports offline workflows using persistent storage via opfs are you an llm view llms txt for optimized markdown documentation or llms full txt for full documentation bundle get started in minutes to create a new project from the minimal example run sh npx giget gh sqlrooms examples minimal my minimal app cd my minimal app npm install npm run dev manual setup set up a simple room that loads and queries a single data table tsx 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 https earthquakes parquet set get store export const myroom roomshell roomstore roomstore mycomponent roomshell function mycomponent const istableready useroomstore state boolean state db findtablebyname earthquakes const queryresult usesql maxmagnitude number query select max magnitude as maxmagnitude from earthquakes enabled istableready if istableready return loading const row queryresult data toarray 0 return max earthquake magnitude row maxmagnitude complete example on github that s it you ve just built an app with a flexible store and ui that can be extended with various analytics visualization and ai modules all powered by client side duckdb with no backend required for a more comprehensive guide see key concepts and the getting started page case studies real world applications built with sqlrooms foursquare spatial desktop flowmap city cosmograph transcality chordshell com supported by deploys by copyright openjs foundation and vis gl contributors all rights reserved the openjs foundation has registered trademarks and uses trademarks for a list of trademarks of the openjs foundation please see our trademark policy and trademark list trademarks and logos not indicated on the list of openjs foundation trademarks are trademarks or registered trademarks of their respective holders use of them does not imply any affiliation with or endorsement by them the openjs foundation terms of use privacy policy bylaws code of conduct trademark policy trademark list cookie policy