# Apache Calcite

**Canonical:** https://apis.io/providers/apache-calcite/  
**APIs profiled:** 3

Apache Calcite is a dynamic data management framework developed by the Apache Software Foundation that provides SQL parsing, query planning and optimization, and data federation capabilities. It serves as the SQL engine and query optimizer for many big data systems including Apache Hive, Druid, Flink, Kafka Streams, and others. Calcite provides a Java API for embedding SQL capabilities into applications, a JDBC adapter for connecting heterogeneous data sources, and an extensible relational algebra framework for building custom query optimizers.

## Kin Score — 25.0 / 100 (emerging)

Scored 2026-08-20 under rubric 0.12.0. Trend: flat (+0.0 from 25.0).

| Facet | Score |
|---|---|
| Discoverability | 64.8 |
| Contract Quality | 0.0 |
| Governance | 15.2 |
| Contract Governance | 15.2 |
| Operational Transparency | 36.8 |
| Developer Ergonomics | 33.3 |
| Commercial Clarity | 26.3 |
| Access Clarity | 26.3 |

## Agent readiness — 3.0 (human-only)

| Dimension | Value |
|---|---|
| Spec Presence | no |
| Agentic Access | no |
| Reversibility Documented | no |
| MCP Server | no |
| Auth Clarity | no |
| Idempotency | no |
| Error Semantics | no |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | no |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | no |
| Agent Card | no |
| Dry Run Mode | no |

## Access

Freemium — onboarding: unknown, pricing: freemium, trial: no (confidence: medium).

## APIs (3)

- **Apache Calcite Java API** — The Apache Calcite Java API provides SQL parsing, validation, query planning, and optimization capabilities for embedding in JVM applications. It exposes a relational algebra fr...
- **Apache Calcite JDBC API** — The Apache Calcite JDBC adapter provides a standard JDBC interface over heterogeneous data sources. Applications use it to issue SQL queries across multiple data formats and sto...
- **Apache Calcite Avatica API** — Apache Avatica is a framework for building database drivers derived from Apache Calcite. It provides a JSON/Protobuf-over-HTTP remote protocol for JDBC clients to connect to Cal...

## Security (2)

- **Apache Calcite Domain Security** — TLSv1.3 · HSTS · DMARC
- **Apache Calcite Vulnerability Disclosure** — security.txt · contact published

## Plans (1)

- **Apache Calcite Plans Pricing**

## Use cases (5)

- **Embedding SQL in Applications** — Add SQL querying capability to Java applications using the Calcite Java API without a full database.
- **Building Query Engines** — Use Calcite as the SQL parsing and optimization layer in custom query engine implementations.
- **Data Virtualization** — Federate queries across multiple heterogeneous data sources using Calcite adapters.
- **OLAP Query Optimization** — Accelerate analytical queries using materialized view rewriting and lattice-based summary tables.
- **SQL Dialect Translation** — Parse SQL in one dialect and transpile it to another using Calcite's SQL generation framework.

## Tags

Apache, Data Federation, Framework, Open-Source, Query Optimization, SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/apache-calcite/). Scores are computed from the provider's own public artifacts under a published rubric.