Real-time tables, readable schemas

Understand Your Apache Pinot Tables at a Glance

Born at LinkedIn and Uber, Pinot serves user-facing analytics at sub-second latency. DbSchema connects through the Pinot JDBC driver and lays those table schemas out visually — no more reading schema JSON to learn what a table contains.

  • Table structures as diagrams instead of schema JSON files
  • Offline and real-time tables side by side on one canvas
  • Confirm a new Kafka consumer writes the columns you expect
  • Record StarTree, inverted, and sorted index choices with the layout
available for ISO-27001 certified ISO-27001 certified
Free Community Edition No signup required 15-day Architect trial included
Free Download
DbSchema visualizing Apache Pinot table schemas on a canvas
100+ Databases
|See All   >

Trusted by teams at

When Offline and Real-Time Tables Drift
Your Users Notice Before You Do

Pinot feeds analytics that customers see, so a schema mismatch is a public bug. Yet each table's structure hides in its own schema JSON, and the offline and real-time variants of the same data evolve on separate paths.

DbSchema puts both variants on one canvas, where a drifted column stands out at a glance instead of surfacing in a dashboard.

Compare, Verify & Query
Pinot Schemas With Confidence

Check the schema in DbSchema before your users check the dashboard.

Compare Apache Pinot offline and real-time schemas side by side
Put Both Table Types on One Canvas

Lay offline and real-time schemas next to each other, annotate index configurations, and spot structural drift before it breaks a query.

Compose Apache Pinot aggregations visually in DbSchema
Click Together the Aggregation

Pick columns, filters, and grouping in the visual builder and inspect the generated SQL — a faster path to a first cut of a dashboard query.

Write sub-second Apache Pinot SQL in the DbSchema editor
Prove the Query Before the Dashboard

Author GROUP BY, HAVING, and DATETIMECONVERT statements with table and column completion, and page through large OLAP result sets in the grid.

Onboarding Docs That Match
What the Cluster Actually Serves

Generate HTML or PDF documentation of your Pinot tables — columns, types, and the index hints recorded on the layout — straight from what DbSchema introspected. New data engineers learn the model from a browsable reference, not from a directory of JSON files.

Open the Documentation Tool

Apache Pinot schema documentation generated by DbSchema

Point DbSchema at Your Pinot Cluster

Register the Pinot JDBC driver (org.apache.pinot.client.PinotDriver) from the Apache Pinot releases in DbSchema's driver manager, then connect with jdbc:pinot://localhost:9000 — replacing localhost with your cluster's hostname or load-balancer address. For TLS-enabled clusters, switch to the https scheme and supply the certificate configuration; further authentication depends on your deployment. Once connected, DbSchema lists every table visible to the authenticated user.

Know Your Tables Before Users Do

Grab the free build — no signup — and evaluate the Architect tier for 15 days.

Download Free

Teams working with Apache Pinot often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases