Link to home
Start Free TrialLog in
Avatar of Software Software
Software SoftwareFlag for Austria

asked on

MariaDB: How to make a ER-Diagram like MySQL Workbench

Hello,
I want to make with an existing database and tables an ER-Diagram like mySQL Workbench.
The tables (over 200) are displayed overlapped in mySQLWorkbench. So, I am looking for an alternative.
I am using MariaDB/HeidiSQL.
Which software is free and has these functions?

* Import ERD as png and pdf?
*  Reverse Engineering (make from an existing database a ERD)
* Triggers should also be displayed in the ERD
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Check out DBeaver:
https://mariadb.com/kb/en/library/graphical-and-enhanced-clients-dbeaver/

A brief list of basic features can be found below:
•Data viewer and editor: sorting, filtering, image displaying, export of selected data and much more.
•Metadata browser: possibility to view and edit existing tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions, etc), security entities (users, roles, etc).
•Data transfer: export and import for files in various formats (CSV, HTML, XML, XLS, XLSX).
•ER diagrams: possibility to automatically generate ER diagrams for a database/schema (diagram will contain all schema tables) or for a single table and export the diagram in a suitable format.
•SQL editor: possibility to organize all your scripts in folders, reassign database connections for particular scripts.
•Data and metadata search: full-text data search using against all chosen tables/views.
•Database structure comparing: possibility to perform objects structure compare.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.