Back to browse
Eatmydata.ai – Local-First Question-to-SQL-to-Dashboard AI

Eatmydata.ai – Local-First Question-to-SQL-to-Dashboard AI

by dennis16384·Jun 10, 2026·2 points·1 comment

AI Analysis

●●SolidBig BrainNiche Gem

In-browser SQLite with LLM sanitization when chat-with-data tools already exist.

Strengths
  • SQLite + QuickJS sandbox means data never leaves the browser — genuine privacy architecture.
  • Open source and self-hostable with transparent SQL query inspection.
  • Semantic indexing with local embeddings before any cloud API calls.
Weaknesses
  • Still requires remote LLM via OpenRouter — not fully offline yet.
  • Chat-with-your-data is extremely crowded (Cursor, Continue, dozens of analytics tools).
Category
Target Audience

Data analysts and developers concerned about data privacy

Similar To

Cursor · Sourcegraph Cody · Vanna AI

Post Description

Yet another "talk to your data and build a dashboard" app, where data does not leave your browser.

You ask a question, agents produce multiple SQL queries to in-browser sqlite, never seeing results, and write dashboard configuration code. The data you analyze will be indexed with a local semantic index (embeddings generation + sqlite vector search fully local).

Next, sandboxed QuickJS runs this code to produce rich dashboards directly in your browser, no backend attached. This is a fully frontend app (except OpenRouter or other remote LLM).

All data sent to LLM's is heavily sanitized and obfuscated at several points. The remote LLM never sees the contents of data it analyzes. Why does it exist - I started this is a testbed for my local-first AI projects, agentic workflows and contextual data analysis experiments.

It grew into a tool I use daily for quick and dirty data analytics when I don't want to waste time debugging SQL or building charts for simple data questions, when I literally need an answer under 10s.

I also don't like the idea of sharing random data in Claude/ChatGPT chat, neither uploading any work-related datasets to them. Plus they both often choke on tiny 100k rows data.

Fully open-sourced under MIT https://github.com/eatmydata-org/eatmydata, run it yourself it's a static web app.

What's in the box:

- SQLite OPFS adapted from wa-sqlite, data queried only locally;

- TurboQuant semantic indexing extension for sqlite (MIT-licensed);

- Quantized PII detection and embedding generation models straight in browser;

- NER and embeddings inference engines in zero-dependency C and wasm-simd128 optimizations (1.7x faster and 38x lighter binary compare to onnxruntime);

- QuickJS sandbox for AI-generated code;

- Orchestrator <-> SQL Planner <-> Coder agent loop that build SQL and dashboards from user query;

- Apache ECharts for dashboards;

- Fork of xslx Community edition to support styles (missing in OSS version upstream).

Hope it'll be useful to anyone who is interested in local-first stuff.

Similar Projects

Data●●Solid

Kkr-Query2xlsx – SQL Runner to XLSX/CSV (GUI+CLI, SQLite Demo)

Exports straight from .sql to XLSX/CSV with sensible niceties — template-aware Excel exports, CSV profiles (delimiter/encoding/quoting/date formats), retry handling for deadlocks, and a demo SQLite so you can try it immediately. It’s not trying to be a BI stack; it’s focused on the boring but painful task of re-running queries and producing predictable spreadsheets. If you want multi-step ETL, dashboards, or semantic modeling, this isn’t it — but for quick, repeatable reports it’s pragmatic and usable out of the box.

Niche GemSolve My Problem
kkrysztofczyk
213mo ago
Education●●Solid

Interactive SQL Tutorial with a visual query builder

The side-by-side visual builder and live SQL editor is the real payoff — drag tables onto a canvas, draw joins, and watch the SQL and results update so JOINs actually click. It's not a novel database, but shipping an in-browser SQL sandbox with a downloadable client, sample e‑commerce dataset, and no-signup access makes this a very effective, demo-friendly way to learn tricky SQL concepts.

Crowd PleaserSlick
mootoday
203mo ago