- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are some good tools to visualize MySQL database schema?
There are many tools to visualize MySQL database schema. Let us see some of them −
SchemaSpy
This tool is based on java and can be used to analyze the metadata of MySQL database schema. Also use it to generate a visual representation of schema. A type of command line tool.
The following are the features
- Supports most JDBC compliant DBMS
- Generates ER diagram for foreign keys
- Generates ER diagram for implied relationships (name, type) of a column matches a primary key
- Generates ER diagram for relationships based on rails naming conventions
- Shows column relationship and actions
- Shows routines
SchemaCrawler
This is also a tool and an API that can be used to work with MySQL database schema. SchemaCrawler supports almost all databases that contains JDBC driver. You can also use it to generate database schema diagram.
SchemaCrawler provides metadata for the following database objects −
- Column data types
- Tables and views
- Columns
- Primary keys
- Indexes
- Table constraints
- Triggers
- Foreign keys
- Routines, including functions and stored procedures
- Sequences
- Synonyms
- Privileges and grants
Advertisements