Apache Calcite
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.
Limited machine-readable signal and partial portal coverage — documentation a human can read, but little a machine or agent can consume without scraping.
API Evangelist profiles Apache Calcite the way a machine reads it — 30 machine-readable artifacts across 3 APIs, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.
Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Apache Calcite scores 33.3/100 (thin), with a separate agent-readiness read of 7/100 (human only). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.
Kin Score
This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance.
Kin Score
How this is scored →scored 2026-07-27 · rubric v0.5
How we profile Apache Calcite
Each block below is one kind of artifact we hold for Apache Calcite. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.
APIs 3
Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.
Individual APIs this provider publishes, each with its own machine-readable definition.
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...
Pricing Plans 1
Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the six things the Kin Score reads for commercial clarity.
Published pricing tiers and plan structures.
Rate Limits 1
Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.
Documented rate limits and quota policies.
Apache Calcite Rate Limits
RATE LIMITSFinOps 1
Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.
Cost, billing, and metering signals for API financial operations.
Apache Calcite Finops
FINOPSFeatures 10
The notable capabilities this provider advertises, captured as structured features so they can be searched and compared instead of read one landing page at a time.
Notable capabilities this provider offers.
SQL Parsing and Validation
Parse and validate SQL queries using an extensible SQL grammar with support for SQL:2003 and beyond.
Query Optimization
Cost-based and rule-based query optimization using a volcano-style optimizer with pluggable optimization rules.
Relational Algebra
Extensible relational algebra framework for representing and transforming query plans as expression trees.
Data Federation
Federate queries across heterogeneous data sources including CSV, JSON, JDBC databases, and Elasticsearch.
Adapter Framework
Pluggable adapter API for connecting new data sources to the Calcite SQL engine.
Materialized Views
Automatic materialized view recognition and query rewriting for query acceleration.
Streaming SQL
SQL extensions for querying streaming data sources with window functions and temporal predicates.
Lattices and Tiles
Summary table recommendation and query rewriting using lattice structures for OLAP workloads.
JDBC Driver
Standard JDBC driver for issuing SQL queries against Calcite-connected data sources.
Avatica Remote Protocol
JSON/Protobuf-over-HTTP remote JDBC protocol for connecting clients to Calcite-based query servers.
Scroll within the panel for all 10 ·
Security Posture 2
Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.
Authentication, domain security, vulnerability disclosure, and trust-center signals.
Use Cases 5
What developers actually build with this provider — captured so the catalogue answers 'what is this for', not just 'what does this expose'.
What developers build with this provider.
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.
Integrations 7
Pre-built integrations with other platforms tell you where this provider already fits in a stack.
Pre-built integrations with other platforms and tools.
Apache Flink
Flink uses Calcite for SQL parsing and query optimization in Flink SQL and Table API.
Apache Hive
Hive uses Calcite for cost-based query optimization in HiveQL query planning.
Apache Druid
Druid uses Calcite for SQL query parsing and planning against its time-series data store.
Apache Kafka
ksqlDB and Kafka Streams use Calcite for SQL stream processing query planning.
Apache Beam
Beam SQL uses Calcite for query planning on PCollection-based streaming and batch pipelines.
Elasticsearch
Calcite provides a SQL adapter for querying Elasticsearch indices using standard SQL.
Apache Kylin
Kylin uses Calcite as its SQL engine for OLAP cube query planning and execution.
Scroll within the panel for all 7 ·
Resources
Every other property we hold for Apache Calcite — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.
Get Started 1
Portal, sign-up, and the first successful call
Documentation 1
Reference material describing how the API behaves
Design & Contract 1
Pagination, idempotency, versioning, errors, and events
Build 3
SDKs, sample code, and the tooling you integrate with
Access & Security 2
Authentication, authorization, and security posture
Operate 2
Status, limits, changes, and where to get help
Commercial 1
Pricing, plans, and the legal terms of use
← All providers · Data indexed from github.com/api-evangelist/apache-calcite · machine-readable index on apis.io