Design and Manage Apache Solr Databases Visually with DbSchema

DbSchema lets you design, manage, and document Apache Solr databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Apache Solr database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Apache Solr JDBC Driver

Collection and Core Architecture

Apache Solr is a widely adopted enterprise search platform built on Apache Lucene that powers full-text search, faceted navigation, and real-time indexing for applications of all sizes. In standalone mode, Solr organizes data into cores, each with its own schema and index. In SolrCloud mode, data is stored in collections distributed across nodes and coordinated by Apache ZooKeeper for high availability and automatic failover. Each collection schema defines fields with types, analyzers, and copy-field rules that control how text is tokenized and indexed. DbSchema connects to Solr through the SolrJ JDBC driver and introspects collection field schemas, rendering them as schema diagrams that make the field structure visible without reading raw schema.xml files.

Writing SQL Queries Against Solr Collections

Solr exposes a SQL interface through Streaming Expressions that translates a subset of standard SQL into native Solr queries executed across distributed collection shards. DbSchema's SQL editor connects over this interface and provides auto-completion for collection names and field names, allowing analysts to write SELECT, GROUP BY, and ORDER BY statements without learning the Solr query syntax. Complex boolean search filters can be passed as WHERE predicates, and aggregation functions like COUNT, SUM, and AVG are supported where Solr's streaming aggregation engine allows them. Results appear in a paginated grid that is easy to copy for reporting.

DbSchema SQL editor querying Apache Solr collections with streaming expressions SQL

Exploring Indexed Documents with the Data Explorer

The DbSchema data explorer lets you page through indexed Solr documents without writing a query. You can filter the result set by any field value, which internally translates to a Solr filter query, and sort rows by numeric or date fields. This is especially useful for verifying that a newly indexed batch of documents contains the expected fields and values before opening the collection to search traffic. For SolrCloud collections with multiple shards, the explorer merges results transparently so you see a unified view of the full collection rather than shard-by-shard segments.

Exploring Apache Solr indexed documents with DbSchema data explorer

Connection Setup and JDBC URL

To connect DbSchema to Apache Solr, add the SolrJ driver JAR (org.apache.solr.client.solrj.io.sql.DriverImpl) to DbSchema's driver manager. The JDBC URL format is jdbc:solr://localhost:8983?collection=mycollection, where 8983 is Solr's default HTTP port and mycollection is the name of the collection to query. For SolrCloud deployments you may point the URL at any node in the cluster; the ZooKeeper ensemble handles routing internally. Authenticated clusters require adding username and password parameters or configuring Kerberos, depending on your security setup. Once connected, DbSchema lists all fields defined in the collection schema for visualization.

Apache Solr collection schema diagram in DbSchema showing field types and analyzers

Why Teams Use DbSchema with Apache Solr

  • Visualize Solr collection field schemas as diagrams, making it easier to understand complex schema.xml configurations without reading raw XML.
  • Write SQL-style aggregation queries against Solr collections in the SQL editor and export results to CSV for reporting.
  • Validate newly indexed document batches by browsing collection contents in the data explorer before promoting to production.
  • Generate offline schema documentation for Solr collections that can be shared with application developers integrating search features.
  • Manage multiple Solr collections in a single DbSchema project, switching between them in the schema canvas without reconnecting.
  • Use DbSchema's layout editor to document the relationship between Solr collections and the upstream databases that feed them.