Skip to main content

MkDocs plugin to render DBML as interactive ERD diagrams

Project description

MkDocs DBML Plugin

MkDocs plugin that renders DBML code blocks as interactive, visual ERD (Entity-Relationship Diagram) directly in your documentation.

Features

  • Interactive SVG diagrams — drag tables, zoom with mouse wheel (10%–300%), pan the canvas
  • Field-to-field connections — relationship lines go from the exact FK field to the exact PK field
  • Orthogonal routing — lines use right-angle paths and automatically avoid overlapping tables
  • Export — download the diagram as SVG or PNG (theme background preserved)
  • TableGroup — group tables visually with DBML TableGroup { table1 table2 }
  • Click-to-select — click any relationship line to highlight it and its connected fields
  • Crow's foot notation — classic ERD markers for one-to-one, one-to-many, many-to-many
  • Material Design 3 icons — PK, FK, NOT NULL, UNIQUE badges on fields
  • 7 color themes — default, ocean, sunset, forest, dark, dark_gray, black (default theme: black)
  • High performance — optional Cython-compiled routing engine; pure-Python fallback

Installation

From source (local project)

git clone https://github.com/ZhuchkaTriplesix/mkdocs-dbml.git
cd mkdocs-dbml
pip install -e .

From source with Cython (optional, for best performance)

If you have a C compiler available (MSVC on Windows, gcc/clang on Linux/macOS):

pip install cython
python setup.py build_ext --inplace
pip install -e .

Without Cython the plugin works fine — it falls back to a pure-Python router.

Dependencies

Installed automatically by pip install:

Package Purpose
mkdocs >= 1.0 Documentation framework
numpy >= 1.20 Layout/routing (required)
pydbml >= 1.0 DBML parser

Quick start

1. Enable the plugin in mkdocs.yml

plugins:
  - search
  - dbml

2. Write DBML in any Markdown file

```dbml
Table users {
  id integer [primary key]
  username varchar(50) [not null, unique]
  email varchar(100) [not null]
  created_at timestamp
}

Table posts {
  id integer [primary key]
  user_id integer [ref: > users.id]
  title varchar(200) [not null]
  content text
  published boolean [default: false]
  created_at timestamp
}

Table comments {
  id integer [primary key]
  post_id integer [ref: > posts.id]
  user_id integer [ref: > users.id]
  content text [not null]
  created_at timestamp
}
```

3. Build or serve

mkdocs serve        # live preview at http://127.0.0.1:8000
mkdocs build        # static output in site/

The plugin converts every ```dbml code block into an interactive SVG diagram.

Including native .dbml files

You can embed the contents of a .dbml file instead of pasting DBML inline. Paths are relative to your docs_dir.

Option 1 — single line with path (must end with .dbml, no spaces):

```dbml
schema.dbml
```

Option 2 — explicit file: or include: prefix:

```dbml
file: schemas/public.dbml
```

The file is read from docs_dir (e.g. docs/schema.dbml or docs/schemas/public.dbml). Path traversal (../) outside docs_dir is not allowed.

Configuration

All options are set under the dbml plugin entry in mkdocs.yml:

plugins:
  - dbml:
      theme: black        # default; or default, ocean, sunset, forest, dark, dark_gray
      show_indexes: true  # display index information
      show_notes: true    # display table notes

Themes

Theme Header gradient Best for
default Purple Light backgrounds
ocean Deep blue → cyan Light backgrounds
sunset Pink → blue Light backgrounds
forest Dark teal → green Light backgrounds
dark Dark violet Dark backgrounds
dark_gray Gray → slate Dark backgrounds, neutral
black Near-black → gray Dark backgrounds, high contrast

Example with the dark theme:

plugins:
  - dbml:
      theme: dark

DBML syntax cheat-sheet

Table table_name {
  column_name column_type [attributes]
}

Column attributes

Attribute Syntax
Primary key [primary key] or [pk]
Not null [not null]
Unique [unique]
Default value [default: value]
Foreign key [ref: > other_table.column]

Relationship types

Syntax Meaning Markers
ref: > table.col Many-to-one Circle → Crow's foot
ref: < table.col One-to-many Crow's foot → Bar
ref: - table.col One-to-one Bar → Bar
ref: <> table.col Many-to-many Crow's foot → Crow's foot

TableGroup

Group tables visually with a rounded border and label:

Table users { id integer [pk] }
Table posts { id integer [pk], user_id integer [ref: > users.id] }
TableGroup content {
  users
  posts
}

Indexes and notes

Table example {
  id integer [pk]
  user_id integer
  post_id integer

  indexes {
    user_id
    (user_id, post_id) [unique]
  }

  Note: 'Description of this table'
}

Full DBML specification: dbml.dbdiagram.io/docs

Interaction guide

Action How
Move a table Click and drag the table
Pan the canvas Click and drag empty space
Zoom Mouse wheel (10% – 300%)
Fullscreen Click the expand button (top-right), Esc to exit
Export SVG or PNG button (top-right); uses theme background
Highlight connections Hover over a table
Select a line Click on any relationship line
Field tooltip Hover over a field row

Project structure

mkdocs-dbml/
├── setup.py                          # package config
├── requirements.txt
├── mkdocs_dbml_plugin/
│   ├── __init__.py
│   ├── plugin.py                     # MkDocs hook + interactive JS
│   ├── renderer.py                   # DBML → SVG rendering + CSS
│   ├── layout.py                     # BFS graph layout engine
│   ├── config.py                     # theme definitions
│   ├── routing.py                    # import wrapper (Cython → Python)
│   ├── _routing.pyx                  # Cython routing (optional)
│   └── _routing_py.py               # pure-Python routing fallback
└── example/                          # demo MkDocs site
    ├── mkdocs.yml
    └── docs/
        └── *.md

Publishing to PyPI (maintainers)

pip install build twine
python -m build
twine upload dist/*

Use an API token from pypi.org/manage/account (env TWINE_USERNAME=__token__, TWINE_PASSWORD=<token>).

License

MIT

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mkdocs_dbml_plugin-1.0.6.tar.gz (25.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mkdocs_dbml_plugin-1.0.6-py3-none-any.whl (23.8 kB view details)

Uploaded Python 3

File details

Details for the file mkdocs_dbml_plugin-1.0.6.tar.gz.

File metadata

  • Download URL: mkdocs_dbml_plugin-1.0.6.tar.gz
  • Upload date:
  • Size: 25.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.11.14

File hashes

Hashes for mkdocs_dbml_plugin-1.0.6.tar.gz
Algorithm Hash digest
SHA256 3f58495e0a47a35f0cee0cac2cbbcc5e5e062a460b34d4386bcc91950a940c03
MD5 5eb2d782e17ea1de24a4caaa5050d541
BLAKE2b-256 8c4b6f6f37fd4b46f1b1481c70a672e90e6ac3c5b3571e9635edad57ec54815b

See more details on using hashes here.

File details

Details for the file mkdocs_dbml_plugin-1.0.6-py3-none-any.whl.

File metadata

File hashes

Hashes for mkdocs_dbml_plugin-1.0.6-py3-none-any.whl
Algorithm Hash digest
SHA256 757525c75ab771a3cce7cb2f2ada67814870941e1ae0d43779e583f7c7a2f9de
MD5 125e623a8d2ce39e8002cfb69ab8fb78
BLAKE2b-256 7279cae34cfe1e96fdd6c85193804b22e77acb706fca11dd60aa44f83821a7ed

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page