duckdb

{
  "aliases": [],
  "alternatives": [
    "SQLite",
    "PostgreSQL",
    "Polars",
    "Apache Arrow"
  ],
  "build_dependencies": [
    "cmake"
  ],
  "categories": [
    "database",
    "olap",
    "data-science"
  ],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Embeddable SQL OLAP Database Management System",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:37:09+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "duckdb",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://www.duckdb.org",
  "homepage_og_description": "DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, fast \u0026 open source.",
  "homepage_og_image": "https://duckdb.org/images/sharingduckdb.jpg",
  "homepage_title": "DuckDB \u2013 An in-process SQL OLAP database management system",
  "installs_30d": 6249,
  "installs_365d": 54662,
  "installs_90d": 17409,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "MIT",
  "llm_generated_at": "2026-06-20T23:45:18+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "duckdb",
  "oldnames": [],
  "one_liner": "Embeddable SQL OLAP database engine in C++ with fast analytical queries and multi-format data support.",
  "optional_dependencies": [],
  "rank_30d": 509,
  "rank_365d": 641,
  "rank_90d": 589,
  "raw_hash": "73b6aa6f36a7c629",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/d/duckdb.rb",
  "tap": "homebrew/core",
  "test_dependencies": [
    "cmake"
  ],
  "uses_from_macos": [
    {
      "python": "build"
    }
  ],
  "version_head": null,
  "version_stable": "1.5.4",
  "versioned_formulae": [],
  "why_use_this": "DuckDB is a single-binary, serverless SQL database ideal for analytical workloads on local files or in-process within applications. It natively reads Parquet, CSV, JSON, and other formats without intermediate loading, offers PostgreSQL-compatible SQL, and excels at ad-hoc data exploration and BI tasks. Use it when you need SQLite-like simplicity but with columnar performance for analytics."
}