---
title: DuckLocal — DuckDB desktop app for SQL on your local files
description: Query CSV, Parquet, JSON and Excel files locally with DuckDB SQL. No server, upload, account or telemetry.
image: https://ducklocal.app/og-image.jpg?v=2
language: en
---

# DuckLocal

Query CSV, Parquet, JSON and Excel files with DuckDB, right where they sit on your computer. No server, upload or account needed.

DuckLocal is a free, open-source desktop app for Mac, Windows and Linux, licensed under Apache-2.0.

## Your agent in the terminal, your data in DuckLocal

Your agent writes a `.dash` file. You review it in DuckLocal and comment right on the charts.

- `ducklocal schema` lists every file, table and column. `--stats` adds exact per-column statistics.
- `ducklocal query` takes one SQL statement and returns bounded JSON. A cut-off result says so.
- `ducklocal open` sends a query or dashboard to the open window. `--state` reads back what you see.
- `ducklocal check` validates a `.dash` file before you see it. Dashboards diff and commit like code.
- `ducklocal comments` lets the agent edit a chart you commented on, reply and resolve the thread.
- `ducklocal presence` shows in the window which chart the agent is reading or editing.

```bash
ducklocal schema ./data/
ducklocal query --sql "SELECT count(*) FROM 'sales.csv'"
```

Connect your agent in three steps:

1. In DuckLocal, open **Command line & AI…** and click **Install command** to put `ducklocal` on your PATH.
2. Click **Add to Claude Code** to install the official skill. For Codex or Cursor, click **Copy brief** and paste it in.
3. Hand the task to your agent in the terminal, then review the result and comment in DuckLocal.

The demo on the homepage is computed from the tutorial's 224-row `sales.csv` sample. The website sends no AI requests, and posting a comment never starts an agent by itself.

Read [SQL for AI agents](https://ducklocal.app/use-cases/ai-agent-sql/), the [CLI reference](https://ducklocal.app/docs/cli) and the [dashboard guide](https://ducklocal.app/docs/dashboards).

## From a file to an answer

1. **Drop in a file.** Drag in a CSV, a spreadsheet or a whole folder. There is no import step.
2. **It's a table already.** `sales.csv` becomes the table `sales`, with its columns in the sidebar. The file is never copied or changed.
3. **Ask with SQL.** Press ⌘↵ for the answer, then chart it or save it as CSV or Parquet.

```sql
SELECT channel, round(sum(revenue), 2) AS revenue
FROM sales
GROUP BY channel
ORDER BY revenue DESC;
```

DuckLocal opens CSV, TSV, Parquet, JSON and NDJSON, Excel and OpenDocument spreadsheets, DuckDB databases, whole folders and S3 storage, all where they are.

## After the first answer

- Profile a query to see which step took the time.
- See the nulls, distinct values and range of every column in a result.
- Attach more DuckDB or SQLite databases, and manage extensions from the sidebar.
- On a Mac, open Parquet and DuckDB files from Finder, or preview them with Quick Look.

## Your data stays yours

- Files are read where they are, never copied or uploaded.
- There is no account, telemetry or cloud service.
- Nothing goes online until you turn it on.
- Open source under Apache-2.0, so every line is there to read.

## Questions people ask

### What is DuckLocal?

A free, open-source desktop app for querying the data files on your computer with SQL. DuckDB runs inside the app, so every file you drop in is a table you can query.

### Does DuckLocal upload my data?

No. Files are read where they are and are never copied, uploaded or changed. There is no account and no telemetry.

### Which file formats can it open?

CSV, TSV, Parquet, JSON and NDJSON, Excel and OpenDocument spreadsheets, DuckDB databases, whole folders, and files in Amazon S3 or S3-compatible storage.

### Which systems does it run on?

macOS 12 or later on Apple silicon, 64-bit Windows 10 or later, and x86_64 Linux with glibc 2.35 or newer.

### How large can my data be?

DuckDB queries the files directly, without loading them into the app first. The results grid shows up to 100,000 rows, and exports write the full result.

### Can AI agents like Claude Code or Codex use it?

Yes. The ducklocal command runs SQL from the terminal and prints JSON. The official skill teaches an agent to check the schema before it queries.

## Links

- [Download DuckLocal](https://github.com/JetSquirrel/DuckLocal/releases/latest)
- [Getting started](https://ducklocal.app/docs/getting-started)
- [10-minute tutorial](https://ducklocal.app/docs/tutorial)
- [Local data analysis](https://ducklocal.app/use-cases/local-data-analysis/)
- [DuckDB GUI](https://ducklocal.app/use-cases/duckdb-gui/)
- [Parquet viewer](https://ducklocal.app/use-cases/parquet-viewer/)
- [Query CSV with SQL](https://ducklocal.app/use-cases/query-csv-with-sql/)
- [Query Excel with SQL](https://ducklocal.app/use-cases/query-excel-with-sql/)
- [Query JSON with SQL](https://ducklocal.app/use-cases/query-json-with-sql/)
- [SQL dashboards](https://ducklocal.app/use-cases/sql-dashboards/)
- [DuckLocal vs DBeaver](https://ducklocal.app/compare/ducklocal-vs-dbeaver/)
- [Blog](https://ducklocal.app/blog/)
- [Documentation](https://ducklocal.app/docs/)
- [Source code](https://github.com/JetSquirrel/DuckLocal)
- [中文](https://ducklocal.app/zh/)
- [日本語](https://ducklocal.app/ja/)

Source: https://ducklocal.app/
