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.

Apache Pinot publishes 5 APIs on the APIs.io network, including Cluster API, Queries API, Schemas API, and 2 more. Tagged areas include Analytics, Database, Low Latency, OLAP, and Real-Time.

The Apache Pinot catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Apache Pinot’s developer surface includes documentation and 9 more developer resources.

20.9/100 emerging ▬ flat Agent 20/100 agent aware Full breakdown ↓
scored 2026-09-25 · rubric v0.23.0
AccessFreemium
5 APIs 7 Features 4 Use Cases
AnalyticsDatabaseLow LatencyOLAPReal-TimeApacheOpen Source

Kin Score

Kin Score Kin Score How this is scored →
scored 2026-09-25 · rubric v0.23.0
Regulatory Posture applies to this provider. Its tags matched the Horizontal (data, software, accessibility, platform) regime, so Regulatory Posture carries 15 points of the composite. If this regime is wrong for your business, say so on your provider repo — the applicability map is public and we will correct it.
Create-or-Update Ergonomics applies to this provider. This API accepts writes, so it carries 10 points of the composite. It is scored from the published contracts themselves: whether a caller can create-or-update in one call, whether the write accepts a key the caller already holds, and whether the response says which branch ran. Without that, every write needs a search-and-branch in front of it, and the first time that check is skipped a duplicate record is created. Scored against the observed mean rather than raw — a provider at the catalog average is unchanged by this facet, not penalised by it.
The six quality facets above are damped to 75 points between them, because the conditional facet above carries the other 25. That is why each facet's contribution is shown against a damped maximum: raising a quality facet moves the composite by 75% of its nominal weight, not 100%. The full arithmetic is at apis.io/rating/.
Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from github.com/api-evangelist/apache-pinot: open an issue to ask a question, or submit a pull request to add artifacts. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

APIs 5

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.

Open Collections 6

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

API Collection

OPEN COLLECTION

Pricing Plans 1

Published pricing tiers and plan structures.

Rate Limits 1

Documented rate limits and quota policies.

Apache Pinot Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Features 7

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 for all 7

Semantic Vocabularies 1

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

Apache Pinot Context

12 classes · 34 properties

JSON-LD

Spectral Rules 2

Spectral governance rulesets for linting and validating these APIs.

Apache Pinot API Rules

5 rules · 3 warnings 2 info

SPECTRAL

Apache Pinot API Rules

11 rules · 5 errors 4 warnings 2 info

SPECTRAL

JSON Schema 12

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 for all 12

JSON Structure 12

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 for all 12

Examples 12

Example request and response payloads for these APIs.

Scroll for all 12

Security Posture 2

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

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

Apache Pinot Agentic Access

12 operations · 4 acting

12 operations · 4 acting

AGENTIC

Use Cases 4

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

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

Company 1

The organization behind the API

Source (apis.yml)

apis.yml Raw ↑
aid: apache-pinot
name: Apache Pinot
description: 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.
type: Index
deliveryModel:
  model: unknown
  open_source: false
  commercial: false
  callable_host: false
  label: Delivery model not determined — needs a product licence on record
  confidence: low
  source:
  - openapi
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
position: Consuming
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-pinot.png
x-docs-platform: gitbook
x-docs-platform-confidence: high
x-docs-platform-checked: 2026-09-19
tags:
- Analytics
- Database
- Low Latency
- OLAP
- Real-Time
- Apache
- Open Source
tags_raw:
- Analytics
- Database
- Low Latency
- OLAP
- Real-Time
- Apache
- Open Source
- Open-Source
created: '2026-03-16'
modified: '2026-05-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-pinot/refs/heads/main/apis.yml
specificationVersion: '0.23'
apis:
- aid: apache-pinot:apache-pinot-cluster-api
  name: Apache Pinot Cluster API
  description: The Cluster API from Apache Pinot — 2 operation(s) for cluster.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Cluster
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-cluster-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-queries-api
  name: Apache Pinot Queries API
  description: The Queries API from Apache Pinot — 1 operation(s) for queries.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Query
  tags_raw:
  - Queries
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-queries-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-schemas-api
  name: Apache Pinot Schemas API
  description: The Schemas API from Apache Pinot — 2 operation(s) for schemas.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Schema
  tags_raw:
  - Schemas
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-schemas-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-segments-api
  name: Apache Pinot Segments API
  description: The Segments API from Apache Pinot — 1 operation(s) for segments.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Segments
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-segments-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
- aid: apache-pinot:apache-pinot-tables-api
  name: Apache Pinot Tables API
  description: The Tables API from Apache Pinot — 2 operation(s) for tables.
  humanURL: https://docs.pinot.apache.org/
  tags:
  - Tables
  properties:
  - type: OpenAPI
    url: openapi/apache-pinot-tables-api-openapi.yml
  - type: Documentation
    url: https://docs.pinot.apache.org/
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com
common:
- type: Website
  url: https://www.apache.org/
- type: AgenticAccess
  url: agentic-access/apache-pinot-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/apache-pinot-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-pinot-domain-security.yml
- type: GitHubOrganization
  url: https://github.com/apache/pinot
- type: Documentation
  url: https://docs.pinot.apache.org/
- type: SpectralRules
  url: rules/apache-pinot-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/apache-pinot-vocabulary.yaml
- type: JSONLD
  url: json-ld/apache-pinot-context.jsonld
- type: Features
  data:
  - name: Real-Time OLAP
    description: Sub-second analytical queries over real-time and historical data
  - name: SQL Support
    description: Standard SQL query interface with Pinot-specific extensions
  - name: Streaming Ingestion
    description: Real-time data ingestion from Kafka, Kinesis, and Pulsar
  - name: Batch Ingestion
    description: Offline data ingestion from HDFS, S3, GCS, and local files
  - name: Columnar Storage
    description: Column-oriented storage with bitmap indexing for fast queries
  - name: Multi-Tenancy
    description: Tenant isolation for broker and server resources
  - name: Star-Tree Index
    description: Pre-aggregated star-tree index for metric rollup queries
- type: UseCases
  data:
  - name: User-Facing Analytics
    description: Power user-facing dashboards like LinkedIn Who Viewed Profile
  - name: Real-Time Dashboards
    description: Business intelligence dashboards over streaming data
  - name: Anomaly Detection
    description: Real-time anomaly detection over metric time series
  - name: A/B Testing
    description: Real-time experiment analysis and statistical significance
- type: Integrations
  data:
  - name: Apache Kafka
    description: Real-time stream ingestion from Kafka topics
  - name: Apache Flink
    description: Flink connector for streaming data into Pinot
  - name: Apache Superset
    description: Visual analytics and dashboards via SQL
  - name: Presto/Trino
    description: Federated query access to Pinot via Presto connector
  - name: Grafana
    description: Grafana data source plugin for Pinot metrics
- type: LlmsText
  url: https://docs.pinot.apache.org/llms.txt

Work with this as data

Every provider here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for providers

9 MCP tools reach this
  • find_providersBrowse and filter every provider in the catalog.
  • get_provider_artifactsEvery artifact this provider publishes, grouped by type.
  • get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
  • get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
  • get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
  • get_provider_ratingPRO — composite, band, trend and facet scores.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This provider
curl "https://apis.io/api/v1/providers/apache-pinot"
All providers
curl "https://apis.io/api/v1/providers?limit=25"
Every operation they expose
curl "https://apis.io/api/v1/providers/apache-pinot/operations?limit=25"
How their score was established
curl "https://apis.io/api/v1/providers/apache-pinot/evidence"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.