duckdb
by duckdb
DuckDB is a fast database that runs inside your own application or from a command line, with no separate server to manage. It is built for analysing data held in files such as CSV, Parquet and JSON using SQL.
- Stars
- 42.6k +26 a day
- Licence
- MIT
- Runs on
- Your computer
- Setup
- Easy
- Language
- C++
- Age
- 3044 days
What you can do with it
- Query CSV, Parquet, JSON or Excel files directly with SQL, without importing them first
- Join data from PostgreSQL, MySQL and SQLite databases in a single query
- Analyse files stored in cloud storage such as S3 or Google Cloud Storage from Python, R or the command line
Make money with it
A freelancer could offer data-cleaning and reporting services, using DuckDB to turn clients' raw exports into clear summaries quickly.
An idea, not financial advice. Check the licence before charging for anything built on it.
Ways a business could use it
- Run sales, customer or ad-spend reports straight from exported CSV files, avoiding paid analytics or data warehouse subscriptions
- Clean and combine messy spreadsheets and database exports for clients as a repeatable, scripted job
Can you use it commercially?
Free to use, change and sell, including in paid products. Keep the copyright notice.
Not legal advice. Read the project's licence file before building a product on it.
Getting it running
Download the command-line app or install a client library (for example for Python or R) by following the instructions on the DuckDB installation page.
Follow the official instructions in the project README.
Checked 27 Oct 2026. Summary drafted by AI from the project's README.
