SchemaCrawler
wwwsqldesigner
| SchemaCrawler | wwwsqldesigner | |
|---|---|---|
| 8 | 1 | |
| 1,553 | 2,847 | |
| - | - | |
| 9.7 | 0.6 | |
| 5 days ago | 12 months ago | |
| Java | JavaScript | |
| GNU General Public License v3.0 or later | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
SchemaCrawler
- SQLite Schema Diagram Generator
- [Look for advice ]for choice of tools/diagram for mapping database
-
Automatically Document Your Database in Markdown
Grab the Python script of "markdown.py" from SchemaCrawler's GitHub repository, and save it in your local directory.
-
Create Nice-looking Schema Diagrams in PlantUML
Take a look at SchemaCrawler, which extends functionality by connecting to your database server and generating a PlantUML schema diagram from it using this technique.
-
How to Document Your Cassandra Database with One Command (and Nothing to Install)
You can save the output with an additional --output-file /share/schema.txt argument, and the file will be created in your local directory. schemacrawler help will give you more information, as well as the SchemaCrawler website. Now you are ready to connect to your own database. If you need help on how to construct the connection URL, take a look at ing-bank/cassandra-jdbc-wrapper.
-
Generate (Good Looking) PlantUML Diagrams for Your Database
Try it out. Make sure that you have Docker installed on your system, or download SchemaCrawler. Download a sample SQLite database called "chinook-database-2.0.1.sqlite" into your current directory.
-
Use schemacrawler to generate Mermaid diagram
schemacrawler website
wwwsqldesigner
What are some alternatives?
Mermaid - Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.
sqlite-schema-diagram
datahub - The Metadata Platform for your Data Stack
prisma2d2 - Visualize Prisma schemas with a D2 diagram
Hibernate - Hibernate's core Object/Relational Mapping functionality
pdot
marquez - Collect, aggregate, and visualize a data ecosystem's metadata
mejram - Database analysis by using information tables and conventions
plantuml - Generate diagrams from textual description
HomeBrew - 🍺 The missing package manager for macOS (or Linux)
H2 - H2 is an embeddable RDBMS written in Java.
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)