Skip to main content

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

dbdiagramdbdocs

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

dbdiagram

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

dbdiagram

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

dbdiagram

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.


πŸ•’ New Feature: Wiki Changelog

dbdocs

You know that moment when you're reading database documentation and thinking "Is this documentation up to date?" πŸ€”

We just solved that.

We're excited to announce Wiki Changelog – a collection of features that show schema changes directly in your documentation pages.

Stay in your flow. Know what changed. When it changed. Who changed it.

πŸ•’ Recent Activities & Entity Last Update​

Get a quick glance at recent schema updates directly in your wiki pages. See at-a-glance timestamps on each table, field, and schema component so you can instantly assess how current your documentation is without digging deeper.

Recent Activities

πŸ”„ Entity-Specific Changelog​

Drill down into the evolution of individual tables, table groups, or fields. Each entity now has its own changelog so you can track specific changes over time and understand how particular parts of your schema developed.

Entity Changelog

πŸ” Wiki Diff View​

Compare any two versions without leaving your documentation using Wiki Diff View. From here, you can toggle between familiar documentation style or raw code view.

Wiki Diff View

πŸ’‘ Why You'll Use It​

  • Debug issues: When something breaks or data looks wrong, quickly see what changed in specific tables or fields recently.
  • Share with teams: Point teammates to recent changes during discussions or code reviews.
  • Review before changes: Check recent activity on tables or fields before making your own modifications.
  • Track compliance: See who made what changes and when for audit trails.
  • Plan migrations: Understand change patterns before planning major schema updates.

πŸš€ Available Now​

Wiki Changelog is rolling out to all dbdocs users starting today. Check out the features in action at our live demo: Ecommerce - dbdocs.io or visit any of your existing documentation pages.

If you have any feedback for us, feel free to share it in this community post.