Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB

Hacker News (score: 12)

Found: October 19, 2025

ID: 1959

Description

IDE/Editor

Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB 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 with autocomplete & syntax highlighting Import CSV, JSON, Parquet, Arrow (local or remote URLs) Query history, keyboard shortcuts, theme toggle Persistent storage via OPFS (data survives browser refresh) Optional: Connect to external DuckDB servers One-liner Docker deployment or Node 20+ dev server

Technical Details:

DuckDB compiled to WASM; query execution in-browser OPFS-backed persistence Apache 2.0 licensed Runs on Chrome 88+, Firefox 79+, Safari 14+

Use Cases:

Learning SQL without setting up databases Ad-hoc data exploration (CSV → SQL in seconds) Quick prototyping before shipping to production Privacy-conscious workflows (no data leaves your browser)

GitHub: https://github.com/ibero-data/duck-ui Live Demo: https://demo.duckui.com Quick Start: docker run -p 5522:5522 ghcr.io/ibero-data/duck-ui:latest

Would love feedback on: (1) Use cases I'm missing (2) Performance bottlenecks you hit (3) Features that would make this your default SQL scratchpad.

More from Hacker

I built MindMaps for Linux and Git cmdz with quiz, typing game and cheatsheet

Database Linting and Analysis for PostgreSQL

Show HN: Kekkai – a simple, fast file integrity monitoring tool in Go

Show HN: Kekkai – a simple, fast file integrity monitoring tool in Go I built a tool called *Kekkai* for file integrity monitoring in production environments. It records file hashes during deployment and later verifies them to detect unauthorized modifications (e.g. from OS command injection or tampering).Why it matters:* Many web apps (PHP, Ruby, Python, etc.) on AWS EC2 need a lightweight way to confirm their code hasn’t been changed. * Traditional approaches that rely on metadata often create false positives. * Kekkai checks only file content, so it reliably detects real changes. * I’ve deployed it to an EC2 PHP application in production, and it’s working smoothly so far.Key points:* *Content-only hashing* (ignores timestamps/metadata) * *Symlink protection* (detects swaps/changes) * *Secure S3 storage* (deploy servers write-only, app servers read-only) * *Single Go binary* with minimal dependenciesWould love feedback from others running apps on EC2 or managing file integrity in production.

Show HN: Gocd – a lightweight Go-based CI/CD tool that runs on your dev machine

Show HN: Gocd – a lightweight Go-based CI/CD tool that runs on your dev machine I built a small project called gocd because I wanted an easy way to deploy changes from GitHub pull requests without spinning up a full CI/CD stack.The idea is simple: instead of setting up runners, servers, or cloud infrastructure, you can just run it on your laptop (or a small server). It integrates with GitHub issues and PRs, automates builds and deploys, and makes it easy to access the running app remotely (e.g. over something like Tailscale).For me, this solved the problem of quickly testing and deploying code from issues/PRs in a lightweight way. Existing CI/CD systems felt like overkill for that use case.Repo: <a href="https://github.com/simonjcarr/gocd" rel="nofollow">https://github.com/simonjcarr/gocd</a>I’d love feedback from the community — especially on whether this minimal approach to CI/CD is something others would find useful, and what features you’d expect in a tool like this.

Show HN: Pbar.io – Distributed progress bars that work in terminals and browsers

Show HN: Pbar.io – Distributed progress bars that work in terminals and browsers I built pbar.io because I was tired of SSH'ing into servers to check if my data processing scripts were still running, or worse, having them finish/crash without knowing.It's a simple REST API that lets you create and update progress bars from anywhere. The same progress bar can be viewed as terminal output (with ANSI colors), in a browser, or consumed as JSON.I'm actually tracking this HN discussion with pbar. The progress bar increases with each comment - watch it live as we discuss!Web: <a href="https://pbar.io/Y8yg3BG" rel="nofollow">https://pbar.io/Y8yg3BG</a> Terminal: curl <a href="https://pbar.io/api/bars/Y8yg3BG" rel="nofollow">https://pbar.io/api/bars/Y8yg3BG</a>More features that emerged from my own use cases: - Hierarchical progress bars (parent bars auto-aggregate children) - Python package (pip install pbar-io) that wraps tqdm - just swap the import - QR codes to monitor progress on your phone while away from desk - No auth required for quick prototypesCurious what use cases you might have for this!

Sparrow: C++20 Idiomatic APIs for the Apache Arrow Columnar Format

Intuitive find and replace CLI (sed alternative)

Nyxstone: An LLVM-based (Dis)assembly Framework

Show HN: OpenAnimation – KMP app for exploring and editing Lottie animations

Show HN: OpenAnimation – KMP app for exploring and editing Lottie animations I’ve been building OpenAnimation, a Kotlin Multiplatform app that lets you discover, view, and edit Lottie animations.You can try it live here: <a href="https://openanimation.web.app" rel="nofollow">https://openanimation.web.app</a>Source code is available here: <a href="https://github.com/orispok/OpenAnimationApp" rel="nofollow">https://github.com/orispok/OpenAnimationApp</a>I’d love to hear your thoughts and feedback!

Mangle – a language for deductive database programming

PG Auto Upgrade – Docker (and K8s) container to auto upgrade your database

Graphene OS: a security-enhanced Android build

Show HN: tsbro – TypeScript for the Browser, No Build Step

Show HN: Clippy – a better pbcopy for macOS that handles files properly

Show HN: Clippy – a better pbcopy for macOS that handles files properly I made clippy because pbcopy can't do something I needed every day: copy files to paste into GUI apps. When you pbcopy < image.png, you get raw bytes instead of a file that Slack or email can use.Clippy fixes this:- clippy report.pdf → ⌘V into any app uploads the file- curl image.png | clippy → pipes become pasteable files- clippy *.jpg → multiple files at once- Text files still work like pbcopyTechnical: Direct Objective-C bindings via CGo. Copies file references (like Finder), not contents. Auto-cleans temp files. No AppleScript hacks.Install: brew install neilberkman/clippy/clippy

Show HN: Flint – Write code your way while ensuring remote consistency

Show HN: Flint – Write code your way while ensuring remote consistency I just released my biggest project yet: Flint, a language-agnostic Git wrapper that lets developers code using their own formatting preferences locally, while automatically enforcing the project's style on push.No more fighting over tabs vs spaces or dealing with noisy diffs.GitHub: <a href="https://github.com/capsulescodes/flint">https://github.com/capsulescodes/flint</a> Documentation: <a href="https://flintable.com/docs/flint/" rel="nofollow">https://flintable.com/docs/flint/</a> Article: <a href="https://capsules.codes/en/blog/flintable/en-flintable-introducing-flint" rel="nofollow">https://capsules.codes/en/blog/flintable/en-flintable-introd...</a>

Show HN: Rust -> WASM, K-Means Color Quantization Crate for Image-to-Pixel-Art

No other tools from this source yet.