See NuoDB's Distributed Schema in a Single Diagram

DbSchema gives NuoDB teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See NuoDB Features Download NuoDB JDBC Driver · All drivers

NuoDB is a durable distributed SQL database built on a peer-to-peer transaction engine architecture. Its runtime consists of transaction engines (TEs) that handle query processing and storage managers (SMs) that persist data to disk. Unlike shared-disk databases, NuoDB has no single point of coordination — transaction engines communicate directly. DbSchema connects via the NuoDB JDBC driver, reads the schema from the broker, and provides visual schema design, SQL editing, and data exploration tools for NuoDB environments.

SQL Editor with NuoDB Dialect Support

DbSchema's SQL editor connects to a NuoDB broker and supports NuoDB SQL syntax, including STORE IN clauses for directing table storage to specific storage managers and NuoDB-specific system catalog queries. Query results are displayed in a paginated table with column-level filtering.

Download DbSchema Free See NuoDB Features

Browsing Data Across NuoDB Storage Managers

NuoDB's data explorer lets you browse table contents stored across multiple storage managers without needing to know the physical data distribution. You can filter rows, inspect column values, and paginate through result sets from any table in the schema — the broker routes the query to the appropriate transaction and storage engines transparently.

Schema Synchronization for NuoDB Deployments

NuoDB schema changes applied in a development database need to reach staging and production without manual DDL reconciliation. DbSchema connects to two NuoDB instances, generates a structural diff, and presents the ALTER and CREATE statements required to synchronize them. Changes can be reviewed and selectively applied.

Design a NuoDB Connection Profile in DbSchema

NuoDB's driver isn't bundled with DbSchema, so locate it first, then the broker handles the rest of the routing for you.

1. Locate nuodbjdbc.jar in your NuoDB installation, typically at $NUODB_HOME/jar/nuodbjdbc.jar.
2. In DbSchema, go to Settings > Drivers and register that JAR.
3. Create a new connection pointed at the broker address, port 48004 by default, giving the URL jdbc:com.nuodb://host:48004/dbname.
4. Specify the database name and schema as separate parameters in the connection dialog.
5. Connect — the broker automatically routes the session to an available transaction engine, and DbSchema builds the ER diagram from there.

The NuoDB broker must be running and the target database must already be in the started state before DbSchema can connect to it.

What Makes DbSchema a Fit for NuoDB

• Broker-aware connection — DbSchema connects through the NuoDB broker, which handles TE routing automatically.
• Schema visualization — render NuoDB tables, relationships, and indexes as navigable ER diagrams.
• Cross-environment sync — diff NuoDB development and production schemas and generate precise migration DDL.
• Offline design — model schema changes locally in DbSchema without impacting a running NuoDB cluster.
• SQL development — write and test NuoDB SQL in the editor before embedding queries in application code.

Managing a distributed NuoDB deployment across transaction engines and storage managers? Download DbSchema and get one visual diagram of the whole schema instead of piecing it together from broker queries.

Related databases

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

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases