Map Elasticsearch Index Mappings to a Visual Diagram

Every Elasticsearch index carries a mapping — field names, types, nested objects — that normally lives as JSON behind an API call. DbSchema treats each index as a table, draws the field structure on a diagram, and lets you query with SQL and browse documents.

See keyword, text, nested, and dense_vector fields at a glance
Query indices in SQL through Elasticsearch's own SQL interface
Page and filter documents in a grid — no Query DSL, no Kibana Discover
Connect to self-hosted clusters and Elastic Cloud alike

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema visualizing Elasticsearch index mappings as a diagram

Trusted by teams at

The Mapping Answers Everything
If You Enjoy Scrolling JSON

Which fields are nested? What type did that field get at index time? With dozens of indices per environment, those answers hide in walls of mapping JSON that only the engineer who wrote the index template can navigate quickly.

DbSchema renders each index's field structure — nested hierarchies included — as a diagram, so the whole team reads the data model instead of parsing it.

Visualize, Group & Publish
Every Index Mapping

Structure tools for a system that is usually explored one curl call at a time.

Turn Elasticsearch index mappings into an ER-style diagram

Field Hierarchies Without the Braces

Each index appears as a table with its fields and types, and nested object structures unfold visually — the mapping, minus the JSON archaeology.

Group Elasticsearch indices into focused diagrams

Dozens of Indices, Grouped Sanely

Split logging, search, and analytics indices into separate diagrams, color-code them, and export the views for architecture discussions.

Generate HTML documentation of Elasticsearch mappings

An Index Reference Anyone Can Open

Publish the mappings as browsable HTML — index names, field types, nested structures — for teammates who should not need API access to learn the data model.

The Cluster Shows What Is
the Model Remembers What Should Be

The imported structure lives in a design model file — readable offline, versioned in Git, and comparable against any environment's cluster.

Review Elasticsearch mappings offline in the model

Read Mappings on the Train

The model keeps the full field structure available with no cluster connection.

Track Elasticsearch mapping changes in Git

Every Field Change, Logged

Version the model in Git and mapping evolution becomes a diff, not a mystery.

Compare Elasticsearch environments against the model

Spot Drift Between Clusters

Compare the model against staging and production to catch indices that quietly diverged.

Onboard teammates from the Elasticsearch model

Onboard From the Model

New teammates study the data model from a file, not from production credentials.

Elasticsearch Connection Facts

Register the Elasticsearch JDBC driver from Elastic's download page and connect to the default HTTP port 9200 with a URL of the form jdbc:es://http://host:9200. The SQL interface ships in the Basic license tier and above, with no extra configuration. For Elastic Cloud, use the HTTPS cluster endpoint and supply your API key as the password; clusters with self-signed certificates need the CA certificate added to the Java truststore first. More on the Elasticsearch JDBC driver page.

Read Your Mappings Like a Diagram

Download without an account — Community Edition free, plus 15 days of Architect.

Download Free

Frequently asked questions

Yes. DbSchema connects using the Elasticsearch JDBC driver, treats each index as a table, and visualizes field mappings — including nested object hierarchies — as a schema diagram.

The default HTTP port is 9200, matching the JDBC URL format jdbc:es://http://host:9200.

The Elasticsearch SQL feature is included from the Basic license tier upward with no extra configuration, so DbSchema's SQL editor works against it out of the box.

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