# DuckDB CLI

DuckDB CLI is an easy-to-use tool for quickly analysing large amounts of data. It is open source and self-hosted, installable on Docker Hub.

Canonical page: https://ourlocalhost.com/app/5656/duckdb-cli

## Description

DuckDB CLI is an easy-to-use tool for quickly analysing large amounts of data. Using simple commands, you can open spreadsheets or data files directly on your computer to find trends and create reports without needing a complex database server or an internet connection.

## Platform availability

Available on 0 of 10 platforms.

## Health score

83/100 (Excellent), based on 4 of 4 factors.
- Maintained: 100 (last commit 3 days ago)
- Popular: 93 (43,161 GitHub stars)
- Easy to install: 25 (0 install platforms, install notes, Docker image)
- Light to run: 100 (125 MB minimum RAM, runs on ARM)

## Links

- Official website: https://duckdb.org/2025/03/12/duckdb-ui
- GitHub: https://github.com/duckdb/duckdb
- Docker Hub: https://hub.docker.com/r/duckdb/duckdb
- Documentation: https://duckdb.org/docs

## Common questions

### How do I start DuckDB's local web UI from the CLI?

Run the CLI with the -ui argument, or execute CALL start_ui() from a DuckDB client. Both approaches install the ui extension if it is not already installed and open the local UI in a browser.

### Can I query CSV and Parquet files directly without a separate import step?

Yes. You can reference the file path in the FROM clause, for example SELECT * FROM 'myfile.csv' or SELECT * FROM 'myfile.parquet'.

### Is the DuckDB CLI a standalone binary that can be self-hosted without extra runtime dependencies?

The DuckDB CLI is described as a single, dependency-free executable. It is also precompiled.

### What build dependencies are needed to compile DuckDB for development?

DuckDB development requires CMake, Python 3, and a C++17 compliant compiler. You can compile from the root directory with make, or use make debug for a non-optimized build.

## Alternatives

- PondPilot: A blazing-fast, lightweight, 100% client-side AI-enabled data exploration tool that helps you analyze local &amp; remote data with zero set…
- SQLite: SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device.

---
Source: Our Local Host (https://ourlocalhost.com/app/5656/duckdb-cli), the self-hosted and open-source app directory.
