Diagram and Sync Your Aurora MySQL Clusters

DbSchema gives Aurora MySQL 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 fast schema design, query iteration, and safe MySQL-compatible deployments, 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 Aurora MySQL Features Download Aurora MySQL JDBC Driver · All drivers

Amazon Aurora MySQL is a cloud-native relational engine designed to deliver up to five times the throughput of standard MySQL by decoupling compute from distributed storage. Clusters expose a writer endpoint and one or more reader endpoints, and schemas evolve independently of instance scaling. DbSchema connects to Aurora MySQL using the standard MySQL JDBC driver — the same driver used for any MySQL 8-compatible database — so there is no extra driver installation required.

Visual ER Diagrams for Aurora Cluster Schemas

DbSchema introspects the Aurora cluster schema and renders every table, column, foreign key, and index as a navigable ER diagram. You can group related tables into diagram layouts, annotate relationships, and share diagrams with your team as HTML documentation — without keeping a live connection open.

Download DbSchema Free See Aurora MySQL Features

Schema Synchronization Between Aurora and Upstream MySQL

Production Aurora clusters frequently diverge from development MySQL instances during feature work. DbSchema's schema comparison tool connects to two environments simultaneously — or compares a live cluster against a saved schema file — and generates the exact ALTER statements needed to bring them back into alignment. You review the diff before any SQL runs.

SQL Editor Connected to Aurora Writer and Reader Endpoints

The built-in SQL editor supports the full MySQL dialect and Aurora-specific extensions such as parallel query hints and SELECT INTO OUTFILE S3. You can maintain separate connection profiles for the writer endpoint and the reader endpoint, keeping analytical queries off the writer node.

Set Up the Aurora MySQL Connection

1. Grab the DbSchema installer; the free download requires no signup and unlocks a 15-day Pro trial.
2. Start a new connection and select MySQL; DbSchema downloads the standard MySQL JDBC driver automatically, since Aurora MySQL speaks the same protocol.
3. For schema changes and DDL, point the connection at the cluster writer endpoint on port 3306: jdbc:mysql://cluster.cluster-id.region.rds.amazonaws.com:3306/dbname.
4. For read-heavy workloads, create a second profile targeting the reader endpoint instead (cluster.cluster-id-ro.region.rds.amazonaws.com), keeping analytical queries off the writer node.
5. Optionally authenticate with IAM: generate a short-lived token via the AWS SDK, supply it as the password, and enable SSL with ?useSSL=true&requireSSL=true. Connect to reverse-engineer the schema.

Aurora MySQL Workflow Advantages in DbSchema

• Offline schema design — model schema changes in DbSchema without a live Aurora connection, then apply them when ready.
• Multi-environment diff — compare dev, staging, and production Aurora clusters and generate targeted migration scripts.
• ER diagram exports — auto-generate HTML or PDF schema documentation for audit and onboarding.
• Git-based versioning — commit the DbSchema project file to Git so every schema change is tracked alongside application code.
• Query profiles — maintain named connection profiles for writer and reader endpoints within a single DbSchema project.

Ready to stop guessing which Aurora environment has the latest schema change? Download DbSchema for free and diagram your Aurora MySQL cluster from the writer endpoint in minutes.