{ }DevToolsDaily
DevToolsDailyDirectory
ToolsInterview Prep
New
CheatsheetsDirectoryMy spaceBlog
Ctrl + K
Ask AI

DuckDB

by DuckDB Labs

In-process analytical SQL database for fast queries over local and remote files

Visit duckdb.org FreeOpen source

DuckDB is an embedded analytical database that runs inside your process and can query CSV, Parquet, and JSON files directly with SQL. It is designed for fast OLAP workloads on a laptop, in notebooks, or in the browser via WebAssembly.

Key features

  • Query CSV, Parquet, and JSON files with SQL
  • Columnar, vectorized execution
  • Embeds in Python, R, Node.js, and more
  • WebAssembly build for the browser

Try it on DevTools Daily

Similar tools

  • ClickHouse

    Open-source column-oriented database for real-time analytics

    by ClickHouseFreemiumOpen sourceLinux, macOS, Self-hosted +2

  • DBeaver

    Universal database client for SQL and NoSQL databases

    by DBeaver CorpFreemiumOpen sourcemacOS, Windows, Linux

  • Datasette

    Explore and publish SQLite data as an interactive website and JSON API

    FreeOpen sourceCLI, Web, Self-hosted

  • Miller

    Like awk, sed, cut, and sort for name-indexed data such as CSV, TSV, and JSON

    FreeOpen sourceCLI, macOS, Windows +1

  • Neon

    Serverless Postgres with branching and scale to zero

    by Neon (Databricks)FreemiumOpen sourceWeb, API, CLI

  • PlanetScale

    Managed Postgres and Vitess (MySQL) databases built for scale

    by PlanetScalePaidWeb, CLI, API

Built a tool like DuckDB? Submit it for review

Buy me a coffeePrivacyTermsFAQChangelogFeature RequestsBlogAll ToolsPricingContact Us © Monkey SkatesHave kids?