# DB Planner

> DB Planner is a collaborative database schema and system designer. It renders DBML (Database Markup Language) as interactive entity relationship diagrams, and Mermaid as UML class diagrams and flowcharts, on one real-time shared board. Teams import SQL from Postgres, MySQL, or MSSQL, edit both notations in a built-in editor, organize large schemas across multiple files that resolve together with no import lines, and export the result as C# models, SQL, or DBML.

The application runs at https://console.dbplanner.io. Key facts:

- Renders tables with typed fields, primary/foreign key badges, and enums as draggable cards; foreign keys draw as curved lines between the exact fields involved.
- Supports modular multi-file DBML schemas: every file in a project is resolved together, so table and enum references work across files with no import lines required (a differentiator vs dbdiagram.io's one-file-per-diagram model). Files containing dbdiagram-style `use * from './file'` lines are accepted; those lines are ignored.
- A project holds two kinds of document, and both draw onto the SAME board: database schemas written in DBML, and diagrams written in Mermaid (classDiagram and flowchart render as cards today). A diagram is not a separate mode or a separate canvas.
- Groups: a labelled frame can hold any cards together, including a Mermaid flowchart step and the DBML table it writes to. Groups are board state, so grouping never edits either document's text. This is the capability that distinguishes DB Planner from tools that draw either schemas or diagrams but not both on one surface.
- Diagram cards are laid out from the diagram's own graph when they first appear (ranked by longest path, following the Mermaid direction), then draggable like any other card; positions live on the board, never in the Mermaid text.
- A rendered board image and the marketplace schema summary cover the SCHEMA only; Mermaid diagrams are not included in either.
- Real-time collaboration: shared board, live presence, organizations with owner/admin/member roles, and per-project editor and viewer roles.
- SQL import converts DDL from Postgres, MySQL, and MSSQL into DBML.
- Export generates C# model classes (Entity Framework annotations or plain POCOs, with naming and namespace options), SQL for Postgres, MySQL, and MSSQL with per-dialect type-compatibility warnings, and DBML.
- Pricing: Free is $0 for 1 project with 10 documents (schemas or diagrams; the cap counts documents, not kinds). Pro is $5/month for unlimited projects and files plus the ability to create organizations. Organization seats are $5 per additional member per month; the owner's seat is free while Pro is active. Real-time collaboration requires Pro plus an organization. A team of three costs $15/month.
- Annotation: draggable, resizable sticky notes on the canvas in seven colors (board objects, not part of the schema), plus table and column notes written in the DBML as `Note:` / `note:` and rendered as markdown on the table card (table notes in a collapsible footer, column notes in a popup opened from an icon beside the field).
- Built-in CodeMirror editor for both notations, with syntax highlighting per document kind, bracket matching and auto-closing, auto-indent, in-editor find, and parse errors reported with line numbers; undo/redo, zoom, pan, auto-arrange layout.
- MCP (Model Context Protocol) server hosted at https://api.dbplanner.io/mcp: an MCP client such as Claude Code, Claude Desktop, or Cursor connects over HTTP, authorizes once through an OAuth 2.1 browser consent flow, and gets tools to read and edit organizations, projects, DBML/SQL schemas, Mermaid diagrams, and board layout (create_document and update_document take a kind; list_diagrams summarises what a project contains without returning content). Read and write are separate OAuth scopes (dbplanner:read, dbplanner:write) enforced server-side; no password or API key is stored in the client config.

## Pages

- [Home](https://dbplanner.io/): product overview and hero diagram
- [Features](https://dbplanner.io/features): full feature descriptions
- [Pricing](https://dbplanner.io/pricing): Free, Pro at $5/month, and organization seats at $5 per added member per month
- [FAQ](https://dbplanner.io/faq): common questions and answers
- [DB Planner vs dbdiagram.io](https://dbplanner.io/compare/dbdiagram-io): feature-by-feature comparison table

## Articles

- [What is DBML?](https://dbplanner.io/articles/what-is-dbml): the Database Markup Language explained with examples
- [dbdiagram.io alternatives](https://dbplanner.io/articles/dbdiagram-io-alternatives): comparison of database diagram tools in 2026
- [How to visualize a SQL schema](https://dbplanner.io/articles/how-to-visualize-a-sql-schema): step-by-step guide from DDL dump to shared diagram
- [DBML vs SQL](https://dbplanner.io/articles/dbml-vs-sql): how DBML and SQL DDL differ, when to use each, and how to convert between them
- [How to document a database schema](https://dbplanner.io/articles/how-to-document-a-database-schema): keeping documentation next to the schema with notes, diagrams, and exports