Skip to content
Dev Tools Library

DuckDB

SQLite for analytics: a fast embedded analytical database.

DatabaseOpen source

Embedded analytical database that runs in-process and queries CSV, Parquet and JSON files directly with SQL.

When to use

To analyze local files and datasets with SQL, without setting up a server.

When to avoid

For multi-user transactional applications or data that needs concurrent access over the network.

Alternatives

They do a similar job. Compare before choosing.

  • Embedded database in a single file.

    DatabaseOpen source
  • Ultra-fast columnar database for large-scale analytics.

    DatabaseOpen source★ 50.7K

From the same area, with a close purpose.

  • Open source BI: questions and dashboards without writing SQL.

    AppOpen source★ 50K
  • Data transformations in SQL with tests and documentation.

    CLIOpen source★ 14.1K