Skip to main content

βœ”οΈ Introducing DBML Check Constraints β€” Enforce Data Rules with Ease

Great news! We've added support for Check constraints, allowing you to set rules on your table fields to enforce data qualityβ€”such as ensuring quantities are above zero or ratings stay within a range.

Here's a simple DBML example:

Table orders {
id integer [pk, increment]
price decimal [not null, check: `price > 0`]
discount decimal [not null, default: 0, check: `discount >= 0`]

checks {
`discount < price` [name: 'valid_discount']
}
}

Previously, these had to go in notes, which meant they could disappear during SQL imports or exports. Now, define them right in DBML, import and export with accuracy, and view them in your ER diagrams and docs for clearer sharing.

DBML Check constraint

It's a simple way to make your databases more reliable and your documentation more informative. Update your diagrams now and start applying Check constraints!

πŸ“š Read the full docs β†’

We hope these enhancements improve your database design and communication experience. Try them out andΒ let us knowΒ what you think.


πŸ“Š CSV Import Support

We're excited to announce support for importing CSV files to generate DBML!

You can now upload a CSV file and automatically generate DBML table code following the CSV structure. This feature makes it easy to visualize database schemas from existing CSV files.

To get started, simply choose the Import from CSV option in your diagram.

dbdiagram Import from CSV


πŸ–ΌοΈ Diagram Views

We're excited to announce Diagram Views, a new feature that lets you create multiple customized views of your database diagram.

Now, you can filter out specific tables to highlight only the parts relevant to your current focusβ€”whether it's a particular domain, process, or team discussionβ€”all from the same underlying database structure that defined in your DBML code.

dbdiagram Diagram Views

Why you’ll like it:

  • No more overwhelming diagrams with hundreds of tables.
  • Easily switch between views to share targeted insights, like a "Customer" for only customer-related tables, or an "Orders" view for sales workflows.
  • Define one database structure and reuse it across multiple views.

Try it now:

  • Open a diagram.
  • Toggle table search panel (you can also press Cmd / Ctrl + F).
  • Add a new view, and select your tables.

Note: Saving multiple views is a Personal Pro feature. On the Free plan, you can only filter tables and save these settings in the default view.

πŸ“š Learn more β†’

Please give this feature a try and let us know what you think.


πŸ” Microsoft Entra SSO Integration

We’re excited to announce support for Microsoft Entra Single Sign-On (SSO)!

You can now log in to dbdiagram seamlessly and securely using your existing Microsoft credentials. This integration streamlines access for organizations and enhances security by leveraging Microsoft’s trusted authentication.

To get started, simply choose the Sign in with Microsoft option.


♻️ Introducing DBML TablePartial β€” Reuse Fields, Reduce Repetition

We’re excited to announce a powerful new feature in DBML β€” TablePartial!

Now you can define reusable sets of fields, settings, and indexes and inject them into multiple tables with a simple ~partial_name syntax.

Why you’ll like it:

  • βœ… Write cleaner, DRY-er (Don’t Repeat Yourself) schema definitions.
  • ♻️ Reuse common fields like timestamps and user metadata.
  • βš™οΈ Maintain consistency across your entire database with ease.

DBML TablePartial

Start using TablePartial today to simplify your DBML projects and speed up your workflow!

πŸ“š Read the full docs β†’

We hope these enhancements improve your database design and communication experience. Try them out and let us know what you think.