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
Plans
Every plan and priceApache Calcite
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.