Data Studio – Open-Source Data Notebooks
Hey HN, I am Alex. I am open sourcing Data Studio, a lightweight data exploration IDE in your browser that runs locally. Try it: https://local.dataspren.com (no account needed, runs locally) More information: https://github.com/dataspren-analytics/data-studio I love working with data (Postgres, SQL, DuckDB, DBT, Iceberg, ...). I always wanted a data exploration tool that runs in my browser and just works. Without any infra or privacy concerns (DuckDB UI came quite close). Features: - Data Notebooks - SQL cells work like DBT models (they materialize to views) -…
In plain words
Data Studio is an open-source, browser-based IDE for data exploration that runs locally without requiring infrastructure or accounts. It supports SQL notebooks where cells materialize to views like DBT models, allows Python functions within SQL queries, and enables direct use of database views as dataframes. Users can work with Postgres, DuckDB, and other databases, plus transform and format Excel, CSV, Parquet, and JSON files. Designed for data analysts and engineers who want privacy-conscious, lightweight data work in their browser.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hey HN, I am Alex. I am open sourcing Data Studio, a lightweight data exploration IDE in your browser that runs locally. Try it: https://local.dataspren.com (no account needed, runs locally) More information: https://github.com/dataspren-analytics/data-studio I love working with data (Postgres, SQL, DuckDB, DBT, Iceberg, ...). I always wanted a data exploration tool that runs in my browser and just works. Without any infra or privacy concerns (DuckDB UI came quite close). Features: - Data Notebooks - SQL cells work like DBT models (they materialize to views) - Use Python functions inside of SQL queries - Use DB views directly in Python as dataframes - Transform Excel files with SQL - You can open .parquet, .csv, .xlsx, .json files nicely formatted If you like what you see, you can support me with a star on Github. Happy to hear about your feedback <3
Does a similar job
all alternatives →- OSOuterbase Studio – Open-Source Database GUI2024 · github.com · ▲356
We just launched Outerbase Studio, the open-source version of our core database offering. It works in your browser or as a desktop app and supports MySQL, PostgreSQL, and SQLite. What it does: • Connects to MySQL, PostgreSQL, and SQLite databases. • Spin up local databases directly through the UI, even if you don’t have one running. • Manage and query your data in a lightweight, intuitive interface. • Completely open source. Why we built it: We wanted to share the core Outerbase experience with the developer community as a free, open-source tool. It’s simple, fast, and removes the barriers…
Open Source PostgreSQL Studio2021 · ▲407Powerful PostgreSQL tool is now open source for self-hosting
- DUDuck-UI – Browser-Based SQL IDE for DuckDBOct 2025 · 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/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…
- OSOpen-source, browser-local data exploration using DuckDB-WASM and PRQL2024 · github.com · ▲227
Hey HN! We’ve built Pretzel, an open-source data exploration and visualization tool that runs fully in the browser and can handle large files (200 MB CSV on my 8gb MacBook air is snappy). It’s also reactive - so if, for example, you change a filter, all the data transform blocks after it re-evaluate automatically. You can try it here: https://pretzelai.github.io/ (static hosted webpage) or see a demo video here: https://www.youtube.com/watch?v=73wNEun_L7w You can play with the demo CSV that’s pre-loaded (GitHub data of text-editor adjacent projects) or upload…
- 1Y10 Years to Build a Free SQL Editor2024 · timestored.com · ▲355
I have spent large parts of the last 10+ years building an SQL Editor. The tool is targeted at data analysts, a lot of effort has gone into charting, visualizing and excel export. If this sounds useful to you, it's Free, please give it a try and let me know any feedback.
More dev tools this month
the category →
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Open-source GTM skills for technical founders
Dev tools · 30d ago · gtmcofounder.com
