DataStudio

Explore and visualize data, entirely in your browser. Powered by WebAssembly and DuckDB. Your data stays on your machine.

Live Demo | Getting Started | Features

Roadmap

• External Storage - Mount S3 buckets
• AI UDFs - AI SQL UDFs embed(col), cosine_sim(u, v), llm(model, prompt, col)
• Ad hoc SQL - .sql file support with executor + viewer

Have a feature request? Open an issue and let us know!

---

Why DataStudio?

Most data tools require a backend, cloud account, or sending your data somewhere. DataStudio runs entirely in your browser. Python and DuckDB execute via WebAssembly, and files are stored locally using the browser's Origin Private File System. There is no server, no upload, and nothing to install.

This makes it ideal for:

• Quick data exploration: drag in a CSV or Parquet file and start querying in seconds
• Sensitive data: financial, medical, or proprietary datasets that can't leave your machine
• Offline work: everything works without an internet connection after the initial load
• Sharing analyses: notebooks use the standard Jupyter .ipynb format

Table of Contents

• Features
• Demo
• Getting Started
• Tech Stack
• Contributing
• License

Features

Feature	Description
Notebook interface	Multi-cell notebooks with Python, SQL, and Markdown cells. SQL cells automatically materialize as views accessible from Python.
In-browser execution	Python (Pyodide) and DuckDB run entirely in WebAssembly. Nothing leaves your machine.
Data visualization	Built-in charting (bar, line, area, scatter, pie) powered by ECharts.
File management	Upload, browse, and query CSV, Parquet, JSON, and Excel files.
Data validation	Built-in checks for uniqueness, not-null, accepted values, and custom SQL validations.
Excel editing with SQL	Query and transform Excel files directly using SQL.

Demo

Notebook: Python, SQL, and Charts

Excel Editing

Getting Started

Prerequisites

• Node.js 22+
• pnpm

Run locally

pnpm install
pnpm dev

Open http://localhost:3000.

Run with Docker

cp .env.example .env
docker compose up --build

Tech Stack

Technology	Role
Next.js + React 19	UI framework
Pyodide	Python compiled to WebAssembly
DuckDB	In-process analytical SQL engine
ECharts	Data visualization
CodeMirror	Code editor
Tailwind CSS + Radix UI	Styling and components

Contributing

Contributions are welcome! Feel free to open an issue or submit a pull request.

License

MIT. Copyright (c) 2026 Dataspren