u/viksdev

Tired of grep | awk | sort | uniq -c for log debugging — built a CLI that pipes them into a browser dashboard
▲ 28 r/DuckDB

Tired of grep | awk | sort | uniq -c for log debugging — built a CLI that pipes them into a browser dashboard

Standard story: prod alert fires, I SSH in, pull down a few hundred MB of JSONL logs, then spend 20 minutes building the same one-liner I always build:

grep ERROR app.log | grep -v noise | awk '{print $5}' | sort | uniq -c | sort -rn

Works, but it's terminal-only and I can't slice by a second dimension without rewriting it. Wanted something closer to a Splunk/Datadog view but for ad-hoc local files.

So I built a CLI that pushes local logs into a browser-side DuckDB instance:

npx duckviz ./logs/ -r

It opens a tab with the files already loaded — timeline, group-by, filter, chart. Logs never leave your machine; the CLI runs a loopback HTTP server with a bearer token and the browser pulls files locally (DNS-rebinding guard, manifest-gated, all that).

Supports JSON, JSONL, CSV, XML, and unstructured logs (LLM detects the format on first load).

Disclosure: Genuinely curious what shape of logs breaks it — drop a sample if you have a weird one.

u/viksdev — 8 days ago
▲ 16 r/DuckDB+1 crossposts

Four months ago I got tired of every "just look at this CSV" task turning into a 45-minute detour. So I built DuckViz, and it kept growing into something I didn't quite plan.

Here's what happens when you drop a CSV (or Parquet, or JSON) into app.duckviz.com:

Second 1 — it's a dashboard. DuckDB compiled to WebAssembly is doing the querying right there in your browser tab. Your file never uploads. Open devtools, check the network panel, you'll see nothing leave. Charts, filters, drilldowns, all of it — instant.

Second 30 — you ask it a question in plain English. "Show me revenue by region for customers older than 6 months." It generates the chart. The AI doesn't see your data either — it only sees your schema and writes the SQL.

Minute 2 — it's a report. Switch to Report mode and you get a rich-text doc you can write narrative in, with live charts embedded inline. Like Notion, but the charts actually query your data.

Minute 5 — it's a slide deck. Same data, presentation layout. Drop charts on slides, present from the browser. Your quarterly review just wrote itself.

Minute 6 — it looks like your brand. 10 built-in themes plus a full custom theme builder. Pick a vibe or paste your brand colors.

Minute 10 — it's inside your own product. the same thing renders inside your SaaS. Your customers' data never touches your servers either. That's the part that closes deals with security teams.

It's free to try, no signup for the demo, no email gate. The full thing — saved projects, sharing, AI — is behind a free account.

duckviz.com

Checkout the sample dashboards created using DuckViz for mock API's

https://duckviz-examples.vercel.app/

reddit.com
u/viksdev — 18 days ago