Skip to content
Utilora

SQL File Explorer - Query CSV, Parquet & JSONL

Data Tools

Drop CSV, Parquet, or JSONL here / click to upload

Supports: .csv, .parquet, .jsonl, .ndjson, .json

What is SQL File Explorer - Query CSV, Parquet & JSONL?

SQL Explorer runs full SQL queries against local files entirely in your browser using DuckDB WASM. You can upload CSV, Parquet, or JSONL files and query them using standard SQL - no database server, no upload to a remote service. DuckDB is an embedded analytical database designed for fast columnar analytics, making it surprisingly capable for a browser-based tool. It handles complex queries including joins across multiple files, window functions, aggregations, and nested data structures.

How it works

DuckDB WASM loads into a Web Worker. When you upload a file, DuckDB registers it as a virtual table (read_csv_auto, read_parquet, read_json). Your SQL query is executed against DuckDB's in-memory engine. Results are streamed back and displayed in a table, with the option to export as CSV.

Features & Benefits

  • Full SQL on local files - SELECT, WHERE, GROUP BY, JOINs, window functions
  • Supports CSV (auto-detected), Parquet, JSONL, and JSON files
  • Powered by DuckDB WASM - the same engine used in production data pipelines
  • Your data never leaves your browser - runs entirely client-side

Frequently Asked Questions

What SQL dialect is supported?

DuckDB SQL - a superset of standard SQL with analytical extensions including window functions, UNNEST, LIST functions, and more. See duckdb.org for the full reference.

How large a file can it handle?

DuckDB WASM handles files up to several hundred MB comfortably in modern browsers. Performance depends on available RAM and the complexity of your query.

Is my data uploaded anywhere?

No. DuckDB runs entirely in a Web Worker in your browser via WebAssembly. The WASM binary (~7MB) is downloaded once from a CDN and cached; your data files never leave your device.

Can I query multiple files?

Yes. Upload multiple files and reference them by name in SQL. For example: SELECT a.*, b.name FROM read_csv_auto('orders.csv') a JOIN read_csv_auto('customers.csv') b ON a.customer_id = b.id

What happened to Vortex file support?

Vortex (SpiralDB's columnar format) is not yet supported by DuckDB WASM. We'll add it when a stable DuckDB extension ships.

Related Tools

Multi-Format Log Parser

Parse bulk log lines from nginx, Apache, syslog, logfmt, and JSON formats into structured JSONL. File upload supported. Runs in your browser.

CSV Data Explorer - Column Analysis & Regression

Upload a CSV to auto-detect column types, spot missing values, and fit a linear regression - all locally in your browser.

Log Clusterer - Group Repeated Log Patterns

Paste raw log lines and instantly cluster repeated patterns using TF-IDF and DBSCAN - runs 100% in your browser via WebAssembly.

Popular Utilities

JSON Formatter & Validator

Format, validate, and minify JSON instantly in your browser. Your data never leaves your device.

JWT Decoder

Decode JWT tokens and inspect header and payload instantly in your browser. Your tokens never leave your device.

Word Counter

Count words, characters, sentences, and estimate reading time instantly in your browser. No sign-up required.

Learn More & Guides

Zero-Backend Architecture: What It Means and Why It Matters

Zero-backend applications execute entirely in the browser, eliminating server-side privacy risks. Learn what zero-backend architecture means, how it works technically, and why it represents the future of privacy-conscious software.

11 min read

The Case for Local-First Tools in the Age of Cloud AI

Cloud AI promises power but sacrifices privacy. Explore the advantages of local-first tools that run AI in your browser-offline capability, no data sharing, and genuine user control.

9 min read

Why Privacy Guarantees Should Be Verifiable, Not Promised

Privacy policies mean nothing if they can't be verified. Learn why verifiable privacy-through architecture, open-source code, and auditability-is essential for tools that handle sensitive data.

10 min read

Building a Personal Developer Utility Suite with Browser Tools

Create your own toolkit of browser-based developer utilities. Learn how local tools for JSON formatting, regex testing, and JWT decoding can streamline your workflow without sending data to third-party services.

8 min read