schemaspy
Database documentation built easy (by schemaspy)
SchemaCrawler
Free database schema discovery and comprehension tool (by schemacrawler)
schemaspy | SchemaCrawler | |
---|---|---|
17 | 8 | |
3,014 | 1,553 | |
1.5% | - | |
9.4 | 9.7 | |
4 days ago | 7 days ago | |
HTML | Java | |
GNU Lesser General Public License v3.0 only | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
schemaspy
Posts with mentions or reviews of schemaspy.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-04-06.
- Show HN: Open source database diagram editor
-
SQLite Schema Diagram Generator
You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram
- Document your database simply and easily
-
DE new on the job
I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.
-
Spring, SchemaSpy DB docs, and GitHub Pages
SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.
-
pgAdmin Generate ERD stuck on load
I like https://schemaspy.org/
- Tips on investigating new databases with minimal documentation?
-
Looking for a database documenting tool to generate docs for analysts
I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful
- What some of your recommended database mappers?
-
Schema to dia/UML/etc/whatever
https://schemaspy.org/ creates nice looking diagrams.
SchemaCrawler
Posts with mentions or reviews of SchemaCrawler.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-23.
- 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
What are some alternatives?
When comparing schemaspy and SchemaCrawler you can also consider the following projects:
plantuml - Generate diagrams from textual description
Mermaid - Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.
dbml - Database Markup Language (DBML), designed to define and document database structures
datahub - The Metadata Platform for your Data Stack
Postico - Public issue tracking for Postico
Hibernate - Hibernate's core Object/Relational Mapping functionality
graphviz
marquez - Collect, aggregate, and visualize a data ecosystem's metadata
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
H2 - H2 is an embeddable RDBMS written in Java.