eralchemy
Simple entity relation (ER) diagrams generation
Decision gist · record as of 2026-08-14
Yes. Active maintenance, no known vulnerabilities, low install friction, and a single stable runtime dependency make this a safe choice. The Apache-2.0 license is permissive. Install it if you need to visualize database schemas or SQLAlchemy models; the GraphViz system dependency is the only real prerequisite.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires GraphViz system library installed (apt install graphviz libgraphviz-dev on Debian, or available for Windows/Mac/Linux from graphviz.org).
- Python >=3.10 required.
- Low friction install with a single runtime dependency (sqlalchemy).
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions.
last release 2026-05-05 (101 days) · last repo commit 2026-05-05 · 1,424 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 3,938,903 downloads/mo, #2,442 on PyPI
Alternatives
Verify before relying
pip install eralchemy
pip install eralchemy[graphviz]
from eralchemy import render_er
render_er("sqlite:///path/to/db.db", 'erd_output.png')- Whether pygraphviz extra works reliably on all platforms (graphviz extra is noted as default when both installed)
- Performance characteristics with very large schemas or databases
- Completeness of markdown-to-diagram round-trip fidelity
What it is and what it does
eralchemy reads database schemas or SQLAlchemy ORM models and generates visual Entity Relation diagrams. It accepts input from live databases (via SQLAlchemy connection URLs), SQLAlchemy declarative bases, or markdown-format ER files, then outputs diagrams as PNG, PDF, SVG, or markdown. The tool includes a command-line interface for batch processing and a Python API for programmatic use, with options to filter tables and columns, select database schemas, and customize diagram rendering (crowfoot notation, primary key markers, layout direction).
The package depends only on sqlalchemy at runtime; graphviz or pygraphviz must be installed separately to generate image output. It supports filtering by table name and column name, schema selection for multi-schema databases, and output format selection including mermaid diagram syntax. The modular architecture is designed to eventually support other ORMs beyond SQLAlchemy.
Use it for
- Generate visual documentation of an existing PostgreSQL or SQLite database schema for team reference
- Export a SQLAlchemy ORM model as a diagram to include in project documentation or design reviews
- Create filtered ER diagrams excluding system or audit tables from a large production database
- Convert markdown ER specifications into visual diagrams for stakeholder presentation
- Batch-generate schema diagrams from multiple databases using the command-line interface
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Active maintenance, no known vulnerabilities, low install friction, and a single stable runtime dependency make this a safe choice. The Apache-2.0 license is permissive. Install it if you need to visualize database schemas or SQLAlchemy models; the GraphViz system dependency is the only real prerequisite.
Install
eralchemy on PyPI
Before you install
Low friction install with a single runtime dependency (sqlalchemy). Active maintenance with recent commits and stable production status.
Requires GraphViz system library installed (apt install graphviz libgraphviz-dev on Debian, or available for Windows/Mac/Linux from graphviz.org). Python >=3.10 required.
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions.
Quickstart
pip install eralchemy
pip install eralchemy[graphviz]
from eralchemy import render_er
render_er("sqlite:///path/to/db.db", 'erd_output.png')Verify before relying
- Whether pygraphviz extra works reliably on all platforms (graphviz extra is noted as default when both installed)
- Performance characteristics with very large schemas or databases
- Completeness of markdown-to-diagram round-trip fidelity
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 1 packagesqlalchemy |
| Maintenance | Actively maintained 101 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 3,938,903 / month, #2,442 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableIntended Audience :: DevelopersOperating System :: OS IndependentTopic :: DatabaseTopic :: Scientific/Engineering :: VisualizationTopic :: Software Development :: Libraries :: Python Modules |
Evidence: eralchemy-1.7.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “ER diagram generator”
- eralchemyGenerates Entity Relation (ER) diagrams from SQLAlchemy models or…
- django-diagramGenerates Entity Relationship Diagrams in Mermaid format from Django…
- sqlalchemy-schemadisplayGenerates entity-relationship and UML diagrams from SQLAlchemy ORM…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also paracelsus · sqlalchemy-schemadisplay · django-diagram · sqlalchemy-pgspider · alembic_utils · sqlacodegen · sqlalchemy-mixins · SQLAlchemy · graphviz · sqlbag