Skip to content
forked from holistics/dbml

Database Markup Language (DBML), designed to define and document database structures

License

Notifications You must be signed in to change notification settings

highload-zone/dbml

 
 

Repository files navigation

DBML - Database Markup Language

Build Status npm @dbml/core npm @dbml/core downloads npm @dbml/cli npm @dbml/cli downloads

DBML (database markup language) is a simple, readable DSL language designed to define database structures.

For more information, please check out DBML homepage

Benefits

  • It is simple, flexible and highly human-readable
  • It is database agnostic, focusing on the essential database structure definition without worrying about the detailed syntaxes of each database
  • Comes with a free, simple database visualiser at dbdiagram.io
  • Also comes with a free database documentation app at dbdocs.io

Example

Example of a database definition of a simple blogging site:

Table users {
    id integer
    username varchar
    role varchar
    created_at timestamp
}

Table posts {
    id integer [primary key]
    title varchar
    body text [note: 'Content of the post']
    user_id integer
    created_at timestamp
}

Ref: posts.user_id > users.id // many-to-one

Community Contributions

About

Database Markup Language (DBML), designed to define and document database structures

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • JavaScript 54.9%
  • PEG.js 26.1%
  • TSQL 9.4%
  • Ruby 8.9%
  • Stylus 0.3%
  • Vue 0.2%
  • Shell 0.2%