Skip to content
SPECIFICTION
Get listed

Apache Calcite

calcite.apache.org

Free plan APISelf-hosted
Visit calcite.apache.org
Spec score 8.1 #6 of 24 in Data Federation Software

What it is

Apache Calcite is a free, open-source data management framework for applications that need database-management components without built-in storage. It provides an industry-standard SQL parser, validator, and JDBC driver. Queries are represented as relational algebra, then transformed with planning rules and a cost model for optimization. Calcite can mediate between applications and several storage locations or processing engines, and can push computation to a source database. Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. Its JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, for API or self-hosted use. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred. It does not store data; each source must be registered through a schema or adapter.

Spec sheet

Purpose
Apache Calcite is a dynamic data management framework that provides components of a database management system while omitting data storage, data processing algorithms, and metadata storage.Read 4 Oct 2026 · calcite.apache.org
Security
Apache's Security Team coordinates vulnerability handling for Apache projects, and the project releases fixes through affected package releases.Read 4 Oct 2026 · apache.org
Support
The project directs users to its developers mailing list, Calcite Jira, Stack Overflow, and source code for help.Read 4 Oct 2026 · calcite.apache.org
Founded
2014Read 28 Sep 2026 · calcite.apache.org
Adapters
Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk.Read 4 Oct 2026 · calcite.apache.org
Contribution
The project welcomes contributions and recommends discussing large contributions through a Jira case or the developers mailing list.Read 4 Oct 2026 · calcite.apache.org
Downloads
Calcite is released as source and through Maven; the downloads page lists version 1.42.0 dated 31 May 2026.Read 4 Oct 2026 · calcite.apache.org
Federation
Calcite can mediate between applications and multiple data storage locations and processing engines, and can push computation to a source database.Read 4 Oct 2026 · calcite.apache.org
JDBC connectivity
The JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP.Read 4 Oct 2026 · calcite.apache.org
Limit
Calcite does not store or own data; a data source must be registered through a schema or adapter.Read 4 Oct 2026 · calcite.apache.org
Query optimization
Calcite represents queries in relational algebra, applies planning rules, and optimizes using a cost model.Read 4 Oct 2026 · calcite.apache.org
Release integrity
The downloads page instructs users to verify downloaded artifacts with a PGP signature or hash.Read 4 Oct 2026 · calcite.apache.org
Runtime requirements
The development page lists Git and Java JDK 8u220 or later, with Java 11 preferred, as build prerequisites.Read 4 Oct 2026 · calcite.apache.org
SQL
Calcite provides an industry-standard SQL parser, validator, and JDBC driver.Read 4 Oct 2026 · calcite.apache.org

Plans and prices

Apache Calcite Free Open source database framework · source release and Maven artifacts Read 4 Oct 2026 · calcite.apache.org

Every Apache Calcite plan and price →

Strong points and limits

Strong points

  • Free source and Maven distribution
  • Industry-standard SQL parser and JDBC driver
  • Cost-based relational query optimization
  • Adapters for varied data sources
  • Remote JDBC over JSON or Protobuf HTTP

Limits

  • Does not store data itself
  • Requires registering each data source
  • Build requires Git and Java JDK
  • No cloud-hosted option

Who it suits

Calcite suits developers building applications that need SQL parsing, query planning, JDBC access, or federation across registered data sources. It is intended for API or self-hosted deployments rather than cloud hosting.

Verdict

Apache Calcite supplies SQL, planning, JDBC, and federation components while leaving storage and processing to connected systems. Its free, self-hosted model fits developers who can provide and register those systems.

Where Specifiction places it

Alternatives to Apache CalciteAll alternatives →