Design and Manage Apache Ignite Databases Visually with DbSchema

DbSchema lets you design, manage, and document Apache Ignite 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 Ignite 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 Ignite JDBC Driver

Visual Schema Browsing for Apache Ignite Distributed Caches

Apache Ignite is a distributed in-memory computing platform that exposes a SQL layer over partitioned key-value caches. Caches in Ignite are projected as SQL schemas and tables, enabling standard JDBC-based tooling to connect to the cluster and query distributed data. DbSchema connects via the Ignite JDBC thin driver, reads the cache-table mappings across the cluster, and renders them as an interactive entity-relationship diagram — giving your team a clear view of what data is stored and how the schema is structured across the distributed nodes.

ER Diagrams for Ignite Cache-Table Mappings

DbSchema reads the Ignite SQL catalog and displays cache-backed tables with their column definitions and primary key mappings on a visual canvas. This helps distributed systems teams audit the data model stored across an Ignite cluster without querying system views directly or parsing Ignite configuration XML.

Building queries against Apache Ignite cache tables in DbSchema's query builder

Explore Ignite Cache Data Interactively

The DbSchema data explorer connects to Ignite and lets you browse, filter, and paginate through cache data exposed via the SQL layer. This provides a practical alternative to writing SELECT queries in the Ignite control center or Visor tool when you need to inspect specific data entries in a running cluster.

Browsing Apache Ignite cache table data in DbSchema's data explorer

SQL Editor for Distributed Ignite Queries

DbSchema's SQL editor connects to Apache Ignite and supports its distributed SQL dialect, including collocated joins, distributed aggregations, and cross-cache queries. Run SQL against your Ignite cluster from a desktop GUI without deploying a separate Ignite client application or using the Ignite shell.

Running distributed SQL queries against Apache Ignite in DbSchema's SQL editor

Connecting DbSchema to Apache Ignite

The default thin JDBC port for Apache Ignite is 10800. The JDBC URL format is: jdbc:ignite:thin://host:10800/schema. For multi-node clusters, specify multiple addresses: jdbc:ignite:thin://host1,host2:10800/schema. Download the Ignite JDBC thin driver from the Apache Ignite download page and add it to DbSchema via Connections > Manage Drivers. The thin client driver does not require embedding an Ignite node in the client process, making it suitable for connecting from external tools like DbSchema.

Why DbSchema for Apache Ignite

  • Visualize Ignite cache-table SQL mappings as an interactive schema diagram
  • Run distributed SQL queries against Ignite from a desktop client
  • Browse and filter cache data through the data explorer without writing queries
  • Document the Ignite SQL schema for distributed systems and backend teams
  • Connect to multi-node Ignite clusters using the JDBC thin driver with failover addresses