Solr schemas without the XML

Turn Apache Solr Collections Into Readable Diagrams

A Solr collection's schema — fields, types, analyzers, copy-field rules — decides how every search behaves. DbSchema connects over the SolrJ JDBC driver and diagrams that field structure, with SQL querying and browsable documentation on top.

  • Field types and analyzers as a diagram, not a wall of XML
  • Query collections with familiar SELECT and GROUP BY syntax
  • Check freshly indexed documents before search traffic arrives
  • Keep several collections in one project, switching without reconnecting
available for ISO-27001 certified ISO-27001 certified
Free Community Edition No signup required 15-day Architect trial included
Free Download
DbSchema presenting an Apache Solr collection schema as a diagram
100+ Databases
|See All   >

Trusted by teams at

Relevance Bugs Are Born in schema.xml
Which No One Enjoys Reading

How a field is tokenized, which copy-field rules feed it, whether it is stored or only indexed — Solr keeps all of it in configuration files that grow denser with every tuning pass. Inherit a collection, and the schema is an archaeology project.

DbSchema introspects the collection and shows the field structure as a diagram — the search engine's contract, finally at a glance.

Visualize, Query & Hand Over
Solr Collections Without XML Archaeology

Field structure, SQL access, and documentation for search teams.

Introspect Apache Solr collection fields into a diagram
From schema.xml to a Picture

Connect to a core or collection and DbSchema renders every defined field with its type — the structure behind the search, without opening a config file.

Query Apache Solr with SQL in the DbSchema editor
SQL In, Search Results Out

Solr's Streaming Expressions translate a SQL subset into distributed queries; DbSchema's editor adds collection and field completion, plus COUNT, SUM, and AVG where the engine supports them.

Generate documentation of an Apache Solr collection schema
Document the Search Contract

Export the field schema as offline documentation for the application developers integrating search — which fields exist, their types, and what they mean.

Review Field Changes
Before They Reach the Index

The DbSchema model is a file that lives happily next to your Solr configset in Git. A new field or a changed type becomes a visible diff teammates approve in review — the same ritual your code already goes through, now covering the search schema.

Apache Solr schema model versioned alongside the configset in Git
Read Git Workflow Docs

Connect Over the SolrJ JDBC Bridge

Add the SolrJ JDBC driver (org.apache.solr.client.solrj.io.sql.DriverImpl) in DbSchema's driver manager and use a URL like jdbc:solr://localhost:8983?collection=mycollection — 8983 is Solr's default HTTP port, and the parameter names the collection to query. In SolrCloud, any node of the cluster works as the target, with ZooKeeper handling routing; secured clusters take username and password parameters or a Kerberos setup, depending on your configuration.

Draw the Schema Behind the Search Box

Free Community download, registration-free, with the 15-day Architect trial built in.

Download Free

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

Browse all 100+ supported databases