Great news! We're introducing Data Sample — a feature that lets you add example data rows directly alongside your table definitions in DBML. Now your diagrams can show not just schema, but actual data, making them far more meaningful and useful for team communication.

Here's a simple DBML example:

Table plans {
  id int [pk]
  name varchar
  price decimal

  Records {
    1, 'Free', 0
    2, 'Pro', 8
    3, 'Team', 15
  }
}

Define sample data right in DBML, and your diagram instantly comes alive. You can import SQL INSERT INTO statements to auto-populate records, view them in the diagram with a single click, and export back to SQL for database seeding. This keeps your reference data and schema definitions in perfect sync across docs and deployment.

Why it matters:

• Your diagrams explain themselves — team members see actual data shapes and values, not just column definitions.
• Lookup tables finally have a home — define plans, roles, and other reference tables with their data, all in one place.
• Catch schema problems early — real data reveals missing columns, type mismatches, and broken relationships before migration.
• Convert existing data seamlessly — import SQL statements and auto-convert to Records for instant visualization.
• Seed your database faster — export sample data to SQL and deploy immediately.

Note: Data Sample is available on all plans.

📚 Read the full syntax docs →

Try it out and let us know what you think!

We're excited to announce SAML Single Sign-On (SSO) support for dbdiagram!

You can now access your workspace through your organization's identity provider (like Okta) using SAML 2.0. This allows workspace admins to better manage team access and keep information more secure by centralizing authentication through a single trusted source.

To get started, simply choose the Sign in with SSO option when logging in.

Note: SAML SSO authentication is available in our Custom plan.

For detailed setup instructions, see our 📚 SAML SSO documentation.

🎅🏼 Ho ho ho, database enthusiasts!

While kids are unwrapping exciting presents this Christmas, dbdiagram users aren't left out—Santa's coming to town with our shiny new AI Assistant as a special present.

Imagine building or refining your database diagrams simply by chatting naturally. Whether you're creating new tables, adding relationships, or seeking suggestions for best practices like indexes and data types, just describe what you need, and it handles the rest.

Use AI Assistant now to boost your workflow, so you can wrap up early and enjoy more quality time with loved ones.

Note: The AI Assistant is included in our paid plans at no extra cost.
📚 Learn more about AI Assistant in our documentation →

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

You can now import your database schema directly from Oracle SQL files.

Combined with our existing Export to Oracle SQL feature, you now have full import/export support for Oracle databases.

✍️ Please note that we currently support Oracle version 19c syntax, similar to our export feature.

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.

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.