Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Apache Calcite

calcite.apache.org

  • Free plan
  • API
  • Self-hosted

What Apache Calcite is

Apache Calcite is a free data management framework for applications that need SQL handling and query planning across data sources. It supplies database-management components, including a SQL parser, validator, and JDBC driver, but it does not store data or provide data-processing algorithms or metadata storage. Calcite represents queries in relational algebra, applies planning rules, and uses a cost model to optimize them. It can connect applications with multiple storage locations and processing engines, and can push computation to a source database. Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. The JDBC driver supports local connections and remote connections through JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, and can run as an API or self-hosted software. A data source must be registered using a schema or adapter. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred.

Who it suits

Calcite suits developers building applications that need SQL parsing, query optimization, or access to multiple data sources. It is a fit for teams prepared to register their own sources and manage a self-hosted or API-based setup.

Good to know, and what to watch

  • Provides a SQL parser, validator, and JDBC driver
  • Optimizes queries using relational algebra and a cost model
  • Can push computation to a source database
  • Lists adapters for databases, engines, and file formats
  • Free; available as source and through Maven
  • Does not store or own data
  • Sources must be registered through a schema or adapter
  • Build requires Git and Java JDK 8u220 or later

Apache Calcite

Free

Free plan

The verdict

Apache Calcite provides SQL and query-planning components for applications that need to work across data sources. It does not supply storage, so teams need to connect and register their own sources.

What the maker publishes

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

Checked against the maker's pages on 4 Oct 2026.