paracelsus
Visualize SQLAlchemy Databases using Mermaid or Dot Diagrams.
Decision gist · record as of 2026-08-14
Yes, if you use SQLAlchemy and need to document or visualize your database schema. The tool is straightforward, has low dependencies, and solves a real documentation problem. The aging maintenance status is a minor concern but not a blocker—the core feature is stable and unlikely to break with new SQLAlchemy releases. Install it if you want automated, version-controlled schema diagrams; skip it if your schema is trivial or you prefer manual diagram tools.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later.
- SQLAlchemy models must be imported before diagram generation; the package reads the model registry, similar to Alembic's migration workflow.
- Low install friction with a pure Python wheel and five straightforward dependencies.
License · maintenance · safety
permissive license (permissive) — MIT License permits free use, modification, and distribution with minimal restrictions, making it suitable for both open-source and commercial projects.
last release 2026-01-04 (222 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 203,893 downloads/mo, #9,617 on PyPI
Alternatives
Verify before relying
pip install paracelsus
paracelsus graph myapp.models.base:Base --import-module "myapp.models:*"
# or inject into markdown:
paracelsus inject README.md myapp.models.base:Base --import-module "myapp.models:*"- Whether GraphViz (dot command) must be installed separately to generate SVG/PNG output, or if it is optional for Mermaid-only workflows.
- Performance characteristics when handling large schemas with many tables and relationships.
What it is and what it does
Paracelsus is a command-line tool that reads your SQLAlchemy ORM models and automatically generates Entity Relationship Diagrams. It works by importing your model modules and inspecting the SQLAlchemy base class registry, then outputting diagrams in either Mermaid or Dot format. Mermaid diagrams render natively in many documentation systems and version control platforms, while Dot format can be further processed with GraphViz tools to create SVG or PNG images.
The tool is designed primarily for documentation and CI/CD workflows. You can generate diagrams on demand, inject them directly into markdown files with automatic updates, or use the `--check` flag to verify that documentation stays in sync with your schema. It supports filtering tables by inclusion or exclusion patterns, customizing column sort order, and handling SQLAlchemy type parameters that might break diagram rendering.
Use it for
- Auto-generate database schema diagrams in project README files and keep them synchronized with model changes via CI/CD.
- Create visual documentation of complex database relationships for team onboarding and design review.
- Embed Mermaid diagrams directly in markdown documentation that renders in GitHub, GitLab, or similar platforms.
- Validate that database documentation is current by running `--check` in precommit hooks or CI pipelines.
- Export Dot format diagrams for further editing in GraphViz or conversion to PNG/SVG for presentations.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use SQLAlchemy and need to document or visualize your database schema.
The tool is straightforward, has low dependencies, and solves a real documentation problem. The aging maintenance status is a minor concern but not a blocker—the core feature is stable and unlikely to break with new SQLAlchemy releases. Install it if you want automated, version-controlled schema diagrams; skip it if your schema is trivial or you prefer manual diagram tools.
Install
paracelsus on PyPI
Before you install
Low install friction with a pure Python wheel and five straightforward dependencies. Maintenance status is aging—last release was 222 days ago—so expect slower response to issues, though the package appears stable for its core use case.
Requires Python 3.10 or later. SQLAlchemy models must be imported before diagram generation; the package reads the model registry, similar to Alembic's migration workflow.
License in practice
MIT License permits free use, modification, and distribution with minimal restrictions, making it suitable for both open-source and commercial projects.
Quickstart
pip install paracelsus
paracelsus graph myapp.models.base:Base --import-module "myapp.models:*"
# or inject into markdown:
paracelsus inject README.md myapp.models.base:Base --import-module "myapp.models:*"Verify before relying
- Whether GraphViz (dot command) must be installed separately to generate SVG/PNG output, or if it is optional for Mermaid-only workflows.
- Performance characteristics when handling large schemas with many tables and relationships.
Package facts
| License | permissive license permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 5 packagespydotpackagingsqlalchemytypertoml |
| Maintenance | Aging 222 days since the last release |
| First released | |
| Downloads | 203,893 / month, #9,617 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
Evidence: paracelsus-0.15.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 › “sqlalchemy erd generator”
- paracelsusParacelsus generates Entity Relationship Diagrams from SQLAlchemy…
- django-diagramGenerates Entity Relationship Diagrams in Mermaid format from Django…
- sqlacodegenReads an existing database schema and generates SQLAlchemy model code…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also django-diagram · eralchemy · sqlalchemy-schemadisplay · mkdocs-mermaid2-plugin · sphinxcontrib-mermaid · mermaid-py · sqlacodegen · mkdocs-panzoom-plugin · sqlalchemy-repr · mermaid-builder