JSON
untangled.
Visualize, flatten, query with SQL, ask AI, profile, and export — all in your browser. Your data never touches a server.
NO SIGN-UP · FREE FOREVER · WORKS OFFLINE
Core Capabilities
Three tools. One workflow.
Visual Explorer
Flatten deeply nested JSON into clean relational tables. Arrays become linked tables with preserved relationships. Instantly.
SQL Playground
Full DuckDB engine in your browser via WebAssembly. JOINs, CTEs, window functions, aggregations — real analytics SQL.
Total Privacy
Zero network requests for your data. Everything runs in the browser memory sandbox. Close the tab and it's gone.
Meet
Dot AI
Your SQL co-pilot. Describe what you need in plain English — Dot AI writes optimized DuckDB SQL with full conversation context. One click to run it.
ordersSELECT category, SUM(amount) AS total_revenue, COUNT(*) AS num_orders FROM orders GROUP BY category ORDER BY total_revenue DESC;
Full Toolkit
Everything built in.
Data Profiler
Instant statistical overview — column types, distributions, null rates, cardinality. Know your data before you query it.
Visual Join Builder
Drag-and-drop relationship diagrams. See how flattened tables connect and build joins visually.
Monaco Editor
The same editor as VS Code. Syntax highlighting, intelligent autocomplete, keyboard shortcuts.
Multi-Format Export
Export query results as XLSX spreadsheets or Apache Parquet. Charts built in for visualization.
Query History
Every query saved automatically. Pin favorites, reuse SQL snippets, never lose your work.
Flexible Input
Paste raw text, drag & drop files, or fetch from any URL. JSON, nested or flat — it handles everything.
Workflow
Three steps. That's it.
Drop your data
Paste JSON, drag a file, or enter a URL. No configuration needed.
Auto-flattened
Nested structures are mapped into clean relational tables instantly.
Query & export
Write SQL, ask AI, chart results, export as XLSX or Parquet.
Audience
Built for people who build things.
Backend Engineers
Debug API responses, inspect nested payloads, and trace data flows — without throwaway scripts.
Data Engineers
Profile, flatten, and query raw JSON pipelines with full SQL — right in the browser.
Data Analysts
Run SQL on JSON datasets. No database setup, no Python. Just answers.
QA Engineers
Validate complex payloads, spot schema edge cases, cross-reference structures.
Product Managers
Turn JSON exports into readable tables and charts. No engineering help needed.
Architecture
Under the hood
Stop fighting
nested JSON.
Drop your data. Get answers. Nothing to install. Nothing to sign up for.
Launch Dotpath