Folder = Table.
Point at a folder or S3 prefix. Each subfolder becomes its own table automatically — no schemas, no config.
VS Code extension · v1.1
SQL for your files.
Inside VS Code.
Right-click a CSV, JSON, Parquet, or S3 file — get a queryable SQL table. Powered by DuckDB. 100% local.
See it in 60 seconds
Query any file
One extension, every format your team keeps sending you.
-
CSV
Auto-detected delimiters, headers, and types.
-
JSON
Nested objects, arrays, and mixed schemas.
-
Parquet
Columnar reads — millions of rows, milliseconds.
-
TSV
Tab-separated files, no config required.
-
JSONL / NDJSON
Streamed logs and events, one row per line.
-
S3
Point at a bucket or prefix — auto-detected region.
Three things you'll love
S3-native.
Auto-detected regions, AWS profile support, files streamed to a local temp dir. Your bucket, your credentials, your control.
100% local.
No accounts, no cloud, no telemetry. Your data never leaves your machine — the extension talks only to DuckDB and your files.
How it works
-
Install
One command in your terminal, or one click in the Marketplace.
$ code --install-extension arunkumar1997.file-sql -
Load a file
Right-click any file in Explorer → Open with File SQL.
Explorer → right-click 'sales.parquet' → Open with File SQL -
Query
Write SQL, press Ctrl+Enter. Results in the panel below.
SELECT * FROM sales LIMIT 10;
See it in your editor
Two ways in, one workflow — no dialogs, no plugins to configure.
s3:// URI or point at a folder outside your
workspace.