# eralchemy/eralchemy

Entity Relation Diagrams generation tool

Repository: https://github.com/eralchemy/eralchemy
Canonical: https://ross.abutalabs.com/products/eralchemy
Language: Python
License: Apache-2.0
License Family: permissive
Topics: sql, database, schema, mysql, sqlalchemy, postgresql, visualization, documentation-tool
Last push: 2026-05-05T14:20:10+00:00

## Health v2 (maintenance only)
Score: 74/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 80, release rhythm 50, longevity 100
- inputs: {"age_days": 4144, "days_push": 120, "days_rel": 120, "gap_med": 297.0, "n_releases_24m": 3}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1426, forks 132 (observed 2026-08-28T04:04:41.641324+00:00)

## What it is
ERAlchemy is a Python tool that generates Entity Relationship diagrams from databases or SQLAlchemy models, outputting images, PDFs, or markdown .er files. It works via a command-line interface and uses Graphviz for rendering.

## Use cases
- generate an ER diagram from a postgres database
- visualize database schema as a pdf
- create entity relationship diagram from sqlalchemy models
- document database schema automatically
- export database schema to markdown er file
- exclude audit tables from schema diagram

## When to choose
- you need ER diagrams from a live database or SQLAlchemy models
- you want CLI-based schema visualization with filtering of tables/columns
- you want output as PDF, image, or markdown

## When to avoid
- you need interactive database diagramming tools with drag-and-drop editing
- you cannot install Graphviz dependencies
- you need diagrams for non-relational (NoSQL) databases

## Facets
- artifact type: cli-tool
- maturity: active
- function: data-visualization, documentation, cli, database
- domain: databases, developer-tools, documentation, data-visualization
- platform: python, cli, cross-platform
- tags: er-diagram, sqlalchemy, graphviz, schema-visualization, database-documentation

## Member repositories
- eralchemy/eralchemy (main) score 74

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:41.641324+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:37:26.400644+00:00, confidence not recorded.
  - readme: https://github.com/eralchemy/eralchemy (fetched 2026-08-28T04:04:41.641324+00:00, sha a725e75d3658)
  - registry_pypi: https://pypi.org/pypi/eralchemy/json (fetched 2026-08-29T11:49:10.064754+00:00, sha 341fce13c4ac)
- Data as of 2026-08-30T08:39:29.467469+00:00.