Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Apache Pinot website screenshot

Apache Pinot

Apache Pinot is a real-time distributed OLAP datastore designed to deliver scalable real-time analytics with low latency. It ingests data from batch and streaming sources and provides fast analytical queries for user-facing applications.

agent aware

Real signal across most facets with visible, nameable gaps — the contract exists but is thin, or the portal is good while governance and commercial terms are absent.

Kin Score

API Evangelist profiles Apache Pinot the way a machine reads it — 66 machine-readable artifacts across 5 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 Pinot scores 49.1/100 (developing), with a separate agent-readiness read of 39/100 (agent aware). 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 Kin Score How this is scored →
scored 2026-07-27 · rubric v0.5
Composite quality — 49.1/100 · developing
Contract Quality 15.5 / 25
Developer Ergonomics 1.7 / 20
Commercial Clarity 7.9 / 20
Operational Transparency 4.8 / 13
Governance 10.4 / 12
Discoverability 8.8 / 10
Agent readiness — 39/100 · agent aware
Machine-Readable Contract 18 / 18
Agentic Access Contract 15 / 15
MCP Server 0 / 12
Machine-Readable Auth 0 / 10
Idempotency 0 / 9
Stable Error Semantics 0 / 8
Request/Response Examples 0 / 7
Rate-Limit Signaling 7 / 7
Typed Event Surface 0 / 6
Agent Skills 0 / 5
Well-Known Catalog 0 / 4
Consent & Bot Identity 0 / 3

How we profile Apache Pinot

Each block below is one kind of artifact we hold for Apache Pinot. 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 5

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 Pinot Cluster API

The Cluster API from Apache Pinot — 2 operation(s) for cluster.

Apache Pinot Queries API

The Queries API from Apache Pinot — 1 operation(s) for queries.

Apache Pinot Schemas API

The Schemas API from Apache Pinot — 2 operation(s) for schemas.

Apache Pinot Segments API

The Segments API from Apache Pinot — 1 operation(s) for segments.

Apache Pinot Tables API

The Tables API from Apache Pinot — 2 operation(s) for tables.

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 Pinot Rate Limits

5 limits

RATE LIMITS

FinOps 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.

Features 7

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.

Real-Time OLAP

Sub-second analytical queries over real-time and historical data

SQL Support

Standard SQL query interface with Pinot-specific extensions

Streaming Ingestion

Real-time data ingestion from Kafka, Kinesis, and Pulsar

Batch Ingestion

Offline data ingestion from HDFS, S3, GCS, and local files

Columnar Storage

Column-oriented storage with bitmap indexing for fast queries

Multi-Tenancy

Tenant isolation for broker and server resources

Star-Tree Index

Pre-aggregated star-tree index for metric rollup queries

Scroll within the panel for all 7 ·

Semantic Vocabularies 1

JSON-LD contexts give the data shared meaning across APIs. We profile them because semantics are what let a machine reconcile 'customer' here with 'customer' somewhere else.

JSON-LD contexts and semantic vocabularies used across these APIs.

Apache Pinot Context

12 classes · 34 properties

JSON-LD

Spectral Rules 2

Governance rulesets we run against this provider's specs — the automated checks behind parts of the score. Profiling them makes the quality bar explicit and re-runnable, not a matter of opinion.

Apache Pinot API Rules

5 rules · 3 warnings

SPECTRAL

Apache Pinot API Rules

11 rules · 5 errors · 4 warnings

SPECTRAL

JSON Schema 12

Standalone JSON Schema definitions describe the data models behind the API. We profile them so the shapes are validatable on their own — useful long after a single request is forgotten.

Standalone JSON Schema definitions for this provider's data models.

ClusterInfo

5 properties

JSON SCHEMA

DataSchema

2 properties

JSON SCHEMA

FieldSpec

3 properties

JSON SCHEMA

InstanceList

1 properties

JSON SCHEMA

ResultTable

2 properties

JSON SCHEMA

Schema

4 properties

JSON SCHEMA

SegmentList

2 properties

JSON SCHEMA

SqlQueryRequest

2 properties

JSON SCHEMA

SqlQueryResponse

6 properties

JSON SCHEMA

SuccessResponse

2 properties

JSON SCHEMA

TableConfig

4 properties

JSON SCHEMA

TableList

1 properties

JSON SCHEMA

Scroll within the panel for all 12 ·

JSON Structure 12

JSON Structure captures the data shapes in a form built for tooling — a complement to JSON Schema that keeps the model machine-legible.

JSON Structure definitions describing this provider's data shapes.

Apache Pinot Cluster Info Structure

5 properties

JSON STRUCTURE

Apache Pinot Data Schema Structure

2 properties

JSON STRUCTURE

Apache Pinot Field Spec Structure

3 properties

JSON STRUCTURE

Apache Pinot Instance List Structure

1 properties

JSON STRUCTURE

Apache Pinot Result Table Structure

2 properties

JSON STRUCTURE

Apache Pinot Schema Structure

4 properties

JSON STRUCTURE

Apache Pinot Segment List Structure

2 properties

JSON STRUCTURE

Apache Pinot Sql Query Request Structure

2 properties

JSON STRUCTURE

Apache Pinot Sql Query Response Structure

6 properties

JSON STRUCTURE

Apache Pinot Success Response Structure

2 properties

JSON STRUCTURE

Apache Pinot Table Config Structure

4 properties

JSON STRUCTURE

Apache Pinot Table List Structure

1 properties

JSON STRUCTURE

Scroll within the panel for all 12 ·

Examples 12

Real request and response payloads are what turn a spec from abstract into obvious — and they're one of the twelve things an agent needs to call an API correctly on the first try.

Example request and response payloads for these APIs.

Scroll within the panel for all 12 ·

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.

Apache Pinot Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Apache Pinot Vulnerability Disclosure

security.txt · contact published

SECURITY

Agentic Access 1

An x-agentic-access contract marks which operations are safe for an agent to run on its own and which need a human in the loop. It is the difference between an API an agent can use and one it can use safely.

Recommended x-agentic-access execution contracts for AI agents.

Apache Pinot Agentic Access

12 operations · 5 acting

12 operations · 5 acting

AGENTIC

Use Cases 4

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.

User-Facing Analytics

Power user-facing dashboards like LinkedIn Who Viewed Profile

Real-Time Dashboards

Business intelligence dashboards over streaming data

Anomaly Detection

Real-time anomaly detection over metric time series

A/B Testing

Real-time experiment analysis and statistical significance

Integrations 5

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 Kafka

Real-time stream ingestion from Kafka topics

Apache Flink

Flink connector for streaming data into Pinot

Apache Superset

Visual analytics and dashboards via SQL

Presto/Trino

Federated query access to Pinot via Presto connector

Grafana

Grafana data source plugin for Pinot metrics

Resources

Every other property we hold for Apache Pinot — 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.

Documentation 1

Reference material describing how the API behaves

Agent Surfaces 2

MCP servers, agent skills, and machine-readable catalogs

Design & Contract 3

Pagination, idempotency, versioning, errors, and events

Build 1

SDKs, sample code, and the tooling you integrate with

Access & Security 2

Authentication, authorization, and security posture

← All providers · Data indexed from github.com/api-evangelist/apache-pinot · machine-readable index on apis.io