SQLite Schema Diagram Generator

• schemaspy

  17 3,005 9.5 HTML

  Database documentation built easy

  

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

• sqlite-schema-diagram

  2 - -

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• SQLpage

  36 777 9.8 Rust

  SQL-only webapp builder, empowering data analysts to build websites and applications quickly

• paracelsus

  1 74 7.9 Python

  Visualize SQLAlchemy Databases using Mermaid or Dot Diagrams.

Paracelsus creates diagrams in markdown or dot format for SQLAlchemy defined databases.

https://github.com/tedivm/paracelsus

• HomeBrew

  1,281 39,373 10.0 Ruby

  🍺 The missing package manager for macOS (or Linux)

  

Are you using SQLite that ships with macOS, or SQLite installed from homebrew?

I had a different problem in the past with the SQLite that ships with macOS, and have been using SQLite from homebrew since.

So if it’s the one that comes with macOS that gives you this problem that you are having, try using SQLite from homebrew instead.

https://brew.sh/

• sqlite-schema-diagram

  1 18 5.4 Makefile

  Fork of https://gitlab.com/Screwtapello/sqlite-schema-diagram (by o0101)

This is very cool. Reminds me of my days 13 years ago using dot to draw complex planaarized graph diagrams before switching to physics / springs models, graph embeddings, and other cool things.

Nice to see a really good use for dot.

I created a fork on GitHub as a fork there'll be easier for me to come back to, find, organize and use (and may be for others too): https://github.com/o0101/sqlite-schema-diagram

I hope you don't mind? If you don't want ur code there let me know and I'll sadly but obediently take it down and just link to it from someplace on there I can readily find. :)

• prisma2d2

  1 0 6.0 Rust

  Visualize Prisma schemas with a D2 diagram

  

I built something similar for Prisma recently: https://github.com/irreducible-io/prisma2d2/

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• wwwsqldesigner

  1 2,846 0.6 JavaScript

  WWW SQL Designer, your online SQL diagramming tool

• pdot

  1 - -

My project pdot^1 has a full-ERD mode but it's honestly less useful than the semi-interactive/contextual mode of navigating schema subgraphs in a database of any size. pdot can output mermaid and render other graphs too, like trigger cascades and grant inheritance.

^1 https://gitlab.com/dmfay/pdot

• SchemaCrawler

  8 1,548 9.7 Java

  Free database schema discovery and comprehension tool

• azimutt

  2 1,006 8.8 Elm

  Next-Gen ERD: Design, Explore, Document and Analyze your database

  

I just want to get a basic overview quickly.

An old colleague of mine created an interactive web app that does this. We use it internally and I find it super useful. Supports SQLite, among others: https://azimutt.app/

• mejram

  1 2 2.5 F#

  Database analysis by using information tables and conventions

I did something related to this https://github.com/wallymathieu/mejram

Suggest a related project