<div align="center">

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

<img src=".github/assets/Showcase.webp" alt="DataSpren DataStudio notebook interface with Python, SQL, and charting" width="680"> </div>

Roadmap

• [ ] External Storage - Mount S3 buckets
• [ ] AI UDFs - AI SQL UDFs embed(col), cosine_sim(u, v), llm(model, prompt, col)
• [x] 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

<img src=".github/assets/Showcase.gif" alt="Notebook showcase" width="600">

Excel Editing

<img src=".github/assets/Showcase_Excel.gif" alt="Excel editing showcase" width="500">

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