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

Uploaded Python 3

File details

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

File metadata

  • Download URL: mkdocs_dbml_plugin-1.0.7.tar.gz
  • Upload date:
  • Size: 25.9 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.7.tar.gz
Algorithm Hash digest
SHA256 68f7b1bb28bba79adfa6337ff5d69e47ecf318fda1978db5ec502f7b195e2417
MD5 b29221f7676c5de99382e9ed5695d68d
BLAKE2b-256 ccacd5893cb6c75f2e3fb5951b5d6890d1ed35cdbf4c793c9e8848c1e8eaf537

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mkdocs_dbml_plugin-1.0.7-py3-none-any.whl
Algorithm Hash digest
SHA256 4b2edfddda90cd68d6c27c56d7226f3cb8bb14101bea1bedc5d6d880271d48d4
MD5 191dab3ab3b073fac4ebf5c795cc702d
BLAKE2b-256 8afe7205f85a55b1919b19af9502084286096f6796155c75cc05f8ede1a226ae

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