# What is DuckDB? Definition and meaning

An embedded, columnar SQL engine that runs analytical queries inside your application or notebook.

## Definition

**DuckDB**: An embedded, columnar SQL engine that runs analytical queries inside your application or notebook.

In short: The SQLite of analytics.

## When it is used

Local analytics, data engineering and querying Parquet and CSV files.

## Where it fits

DuckDB belongs to **Query engines and warehouses** in the [Big data](/topics/big-data) topic. These are the other terms in the same group:

- **[Polars](/glossary/polars)**: A Rust-based DataFrame library with lazy query optimisation and parallel execution on Arrow memory.
- **[BigQuery](/glossary/bigquery)**: Google Cloud's fully managed, serverless data warehouse with separated storage and compute.
- **[Amazon Redshift](/glossary/amazon-redshift)**: A managed, massively parallel columnar data warehouse on AWS with provisioned and serverless options.

## Learn more

The full guide to **[DuckDB](/tools/duckdb)** explains how it works, when to use it and how it compares with the alternatives, with examples. The [glossary](/glossary) lists every term on the site from A to Z.

Previous term: [DSPy](/glossary/dspy) · Next term: [Dueling DQN](/glossary/dueling-dqn)
