Design and Manage MariaDB Databases Visually with DbSchema

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

Visual Tooling for MariaDB's Expanded Feature Set

MariaDB extends its MySQL-compatible foundation with capabilities that have no direct upstream equivalent — Galera Cluster for synchronous multi-master replication, system-versioned temporal tables that automatically retain row history, and the ColumnStore engine for analytical workloads. DbSchema handles MariaDB-specific metadata and syntax, so the visual model accurately reflects what your MariaDB instance actually supports rather than defaulting to a generic MySQL representation.

ER Diagrams for MariaDB Schemas

Connect DbSchema to any MariaDB instance and it reverse-engineers tables, views, foreign keys, and indexes into an interactive diagram. Build layouts that span multiple databases on the same MariaDB server, and use the canvas to design new tables or modify existing ones without writing DDL.

Creating a MariaDB ER diagram in DbSchema

SQL Editor with MariaDB Syntax Support

The SQL editor recognizes MariaDB-specific syntax including system-versioned table queries, temporal extensions, and Galera-specific statements. Schema-aware autocomplete surfaces column names and functions as you type, reducing the need to switch between editor and documentation.

SQL editor with MariaDB syntax support in DbSchema

Browse Data Across the Cluster

In a Galera Cluster deployment, all nodes share the same schema — connecting DbSchema to any node gives full visibility into both structure and data. Use the data explorer to paginate through rows, apply column filters, and follow foreign key links without writing SELECT queries by hand.

Browsing MariaDB table data in DbSchema's data explorer

Connecting DbSchema to MariaDB

MariaDB listens on port 3306 by default, matching the MySQL default. The JDBC URL format is jdbc:mariadb://host:3306/dbname — this uses the MariaDB Connector/J driver, which DbSchema downloads automatically and which is distinct from MySQL Connector/J. For Galera Cluster deployments, connect to any node's IP address; DbSchema reads the full schema from that node since all nodes are schema-identical. Remote access requires the same bind-address and user grant configuration as a standalone MariaDB instance.

Why DbSchema for MariaDB Projects

  • Accurately model MariaDB-specific features like temporal tables and ColumnStore schemas.
  • Design schema changes offline and synchronize them to a live MariaDB instance on demand.
  • Connect to any Galera node to inspect the full cluster schema and data in one place.
  • Generate migration scripts by diffing two MariaDB databases or a model against a live server.
  • Export schema documentation that includes MariaDB-specific column attributes and storage engines.