🏷️ Custom Properties

We're happy to announce that DBML now supports custom properties: you can add key-value pairs to your tables and columns.

Use them to record who owns a table, which fields hold personal data, or anything else your team tracks.

Write them inline in the settings list, or in a separate Metadata block:

Table users [owner: "identity-team", pii: "true"] {
  id int [pk]
  email varchar [classification: "confidential"]
}

// or keep the properties apart from the schema
Metadata Column users.email {
  masking: 'partial'
}

What's new:

• Any key you need, on tables, columns and table groups: owner, classification, retention, SLA, etc.
• Properties live in your DBML, so git versions them with the schema and your own scripts can read them.
• Filter tables and fields by key and value in dbdiagram and dbdocs, matching the whole value or just part of it.
• Read them in place: properties show up in the diagram view and in your dbdocs database doc, so whoever is reading the schema sees them without opening another tool.

Note: Custom properties and the property filter are available on all plans.

📚 Learn more →

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