Design and Manage Aurora MySQL Databases with DbSchema
Build a clearer workflow for Aurora MySQL: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for fast schema design, query iteration, and safe MySQL-compatible deployments. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See Aurora MySQL Features Download Aurora MySQL JDBC Driver
What happens after you download?
Get to your first Aurora MySQL schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to Aurora MySQL or open a sample
Reverse engineer an existing Aurora MySQL database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Connecting DbSchema to Aurora MySQL
Aurora MySQL uses the standard MySQL JDBC driver, which DbSchema downloads automatically. Use the cluster
writer endpoint for schema changes and DDL operations:
jdbc:mysql://cluster.cluster-id.region.rds.amazonaws.com:3306/dbname.
For read-heavy workloads, point a separate profile at the reader endpoint
(cluster.cluster-id-ro.region.rds.amazonaws.com).
IAM database authentication is also supported: generate a short-lived token via the AWS SDK and supply it as
the password with SSL enabled (?useSSL=true&requireSSL=true). The default port is 3306.
Why Teams Use DbSchema with Aurora MySQL
- 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.