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, 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
  • 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
  • High performance — optional Cython-compiled routing engine; Numba JIT 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
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: default      # color theme (see below)
      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

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
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.0.tar.gz (23.3 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.0-py3-none-any.whl (22.3 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: mkdocs_dbml_plugin-1.0.0.tar.gz
  • Upload date:
  • Size: 23.3 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.0.tar.gz
Algorithm Hash digest
SHA256 c256276a3dfd56abcb12f828d49c6f45f63851de31a71839933456911322ede1
MD5 e6073543c1979352bafcfd250c83928f
BLAKE2b-256 f99538a626b9aa157b9760d65f405739d7d39774f5ee2ebe02f7ed2d09372134

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mkdocs_dbml_plugin-1.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 9984f93d9e3b13e1dc8d5632c277589f3566591148f22cb1ab9da63929fda179
MD5 e6c40899c1837c269a11dd3d7e670124
BLAKE2b-256 51bd3a44b622f9a0ceb7570a4c002887ba1239cfb4e9fc86408ff6b2a12b089e

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