Design and Manage OrientDB Databases Visually with DbSchema

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

OrientDB is a multi-model database engine that stores data simultaneously as documents, graph vertices and edges, key-value pairs, and objects. This flexibility makes it powerful but also harder to reason about structurally — a class in OrientDB can act as a document collection, a vertex type, or both. DbSchema connects via JDBC, reads the class hierarchy, and renders vertex-edge relationships alongside document class structures in a single ER-style diagram.

Visualize Class Hierarchies and Graph Relationships

OrientDB's class system supports inheritance, and edge classes define explicit typed relationships between vertex types. DbSchema surfaces both in the diagram canvas, letting you see the document schema and the graph topology together rather than consulting two separate tools or catalog queries.

DbSchema displaying OrientDB class properties and their data types

Query Vertices and Edges Interactively

OrientDB supports a SQL dialect extended with graph traversal keywords such as TRAVERSE and MATCH. DbSchema's query builder helps construct OrientDB-compatible SELECT statements against vertex and edge classes without hand-writing every clause from scratch.

Query builder constructing a SELECT query against OrientDB vertex classes

Browse Vertices, Edges, and Documents

The data explorer lets you page through stored vertices, edge records, or document class entries one class at a time. When you need to verify that graph relationships were written correctly after a bulk import, or audit document contents following a schema change, browsing records in DbSchema is faster than crafting one-off traversal scripts.

Data explorer browsing OrientDB vertex and document records

Connecting to OrientDB

OrientDB listens on port 2424 for binary (JDBC) connections and port 2480 for the HTTP API. The JDBC URL format is jdbc:orient:remote:host:2424/dbname. Download the OrientDB JDBC driver from the official OrientDB repository and register it in DbSchema's driver manager before connecting. For OrientDB Enterprise Edition, the same driver and URL format apply — point the host to the enterprise server address. Ensure the OrientDB server process is running and reachable on port 2424 before initiating the connection.

Why Use DbSchema with OrientDB

  • Render document classes and graph vertex/edge types together in one diagram
  • Browse class inheritance chains to understand your OrientDB schema hierarchy
  • Run OrientDB SQL including TRAVERSE and MATCH graph traversal statements
  • Generate schema documentation for teams unfamiliar with multi-model concepts
  • Audit edge records and document class contents without writing one-off scripts