schemaspy
Database documentation built easy (by schemaspy)
dbgate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application (by dbgate)
| schemaspy | dbgate | |
|---|---|---|
| 17 | 27 | |
| 3,014 | 4,334 | |
| 1.5% | 3.7% | |
| 9.4 | 8.0 | |
| 4 days ago | 16 days ago | |
| HTML | Svelte | |
| GNU Lesser General Public License v3.0 only | MIT License |
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.
dbgate
Posts with mentions or reviews of dbgate.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-10.
- DBeaver – open-source Database client
-
Document your database simply and easily
This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.
To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/
-
15 open-source tools to elevate your software design workflow
Link | Github | License
-
👻Top 8 Free, Open Source SQL Clients🔥
DbGate works in Windows, Linux, Mac, and your web browsers without compromises in functionality. Both SQL and noSQL databases are supported, from MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, to CockroachDB.
-
Do you use pgAdmin? Why?
Have you tried dbgate? https://github.com/dbgate/dbgate
-
Is Pg Admin 4 slow and clunky or is it my PC?
Try https://dbeaver.io/ or https://dbgate.org/ (which can work in web mode)
-
Why is pgAdmin such trash?
You should try https://dbgate.org/
-
No/Low Code SQLite Front End GUI/Forms
For browsing the SQL data in an IDE, I prefer https://www.beekeeperstudio.io/ or https://dbgate.org/
-
Show HN: Slashbase – open-source collaborative IDE for databases in browser
The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs
-
SQLite GUI
DbGate (https://dbgate.org/)
What are some alternatives?
When comparing schemaspy and dbgate you can also consider the following projects:
plantuml - Generate diagrams from textual description
dbeaver - Free universal database tool and SQL client
dbml - Database Markup Language (DBML), designed to define and document database structures
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Postico - Public issue tracking for Postico
antares - A modern, fast and productivity driven SQL client with a focus in UX
graphviz
Adminer - Database management in a single PHP file
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
Sequel-Ace - MySQL/MariaDB database management for macOS
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
sqlitestudio - A free, open source, multi-platform SQLite database manager.