ERD Visualizer

Understanding a complex schema can be difficult through text alone. DBStudio's ERD (Entity-Relationship Diagram) Visualizer provides an interactive, auto-generated map of your database architecture.

Core Features

Auto-Generated Diagrams

The ERD Visualizer reads your database schema and renders:

• Tables and Views: All entities as draggable nodes.
• Foreign Keys: Animated lines connecting related tables.
• Column Details: Primary keys, types, nullable flags.

Interactive Canvas

• Auto-Layout: Dagre-powered algorithm organizes tables for readability.
• Drag & Drop: Reposition tables freely.
• Zoom & Pan: Navigate large schemas with ease.
• MiniMap: Quick overview for complex databases.

Draft Mode

Design new tables before they exist in your database:

1. Click Add Table to create a draft node.
2. Define columns, types, and constraints.
3. Draw relationships by connecting column handles.
4. Click Publish to generate migration SQL.

Migration SQL Generation

When you publish draft tables, DBStudio generates:

• CREATE TABLE statements with proper types.
• ALTER TABLE statements for foreign key constraints.
• Compatible syntax for your database type (MySQL/PostgreSQL/SQLite).

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  customer_id INTEGER REFERENCES customers(id),
  total DECIMAL(10,2) NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);

Sticky Notes

Add sticky notes to annotate your ERD:

• Document business logic.
• Mark areas for refactoring.
• Leave notes for teammates.

Saving & Loading

Save your ERD layout to reload later. Useful for:

• Preserving custom arrangements.
• Sharing designs with teammates.
• Versioning schema evolution.

Export

Export your ERD as a PNG screenshot for documentation or presentations.