dbdocs now supports Many-to-many Relationships!

When drawing the many-to-many relationship, you no longer need to create an associative (join) table. Instead, just define it directly, such as:

Table books {
  id int [pk]
  ...
}

Table authors {
  id int [pk]
  ...
}

Ref books_authors: books.id <> authors.id // many-to-many

For more DBML syntax updates, please check out our docs!

Today we provide you with another powerful tool for documenting your database - Multiple Schemas.

Previously you could only define the table names, and when loaded into dbdocs it falls into the default “public” schema.

Now, you can define the tables with full schema names:

Table ecommerce.products {
  ...
}

Moreover, you can make cross-schemas relationships and use enums from different schemas.

Table orders {
  id int [pk, ref: < ecommerce.order_items.order_id]
  status core.order_status
  ...
}

Enum core.order_status {
  ...
}

For more DBML syntax updates, please check out our docs!

The recent outbreak in our country is severe, but that doesn't stop us from improving dbdocs. This time, we bring you the Markdown support for the notes of tables & fields.

Now you can restructure your notes by styling your texts, adding code blocks for database scripts, related links, and so much more.

Manage better & view all your database projects via new project list views.

Simply run the dbdocs ls command on the dbdocs CLI version 0.6.1

Or open your organization page by select "My Projects" in the account dropdown menu

Your savior, a.k.a save diagram's table positions, is here!

It's very time-consuming before to always move tables around at the beginning of each session.

Now you can sign in & modify the diagram's table positions in your projects. Then every time you & your guests visit, the arrangement in diagrams will stay still.