This package will generate Markdown that beautifully renders your Database schema in an easily explorable document.
$ npm install dbschema-markdown -g
Installing the package adds a dbschema-markdown
script. Point it at a schema
and the output will be written to stdout.
The schema may be retrieved from a Database endpoint:
$ dbschema-markdown "Data Source=SERVER\INSTANCE;Initial Catalog=Demo;Persist Security Info=True;User ID=APP_Demo;password=XXXXX" > schema.md
…or update existing file:
$ dbschema-markdown "Data Source=SERVER\INSTANCE;Initial Catalog=Demo;Persist Security Info=True;User ID=APP_Demo;password=XXXXX" -u "./schema.md"
If --update-file
is given, the generated Markdown will be output to the given
file between the <!-- START dbschema-markdown -->
and <!-- END dbschema-markdown -->
comment markers instead of printed to STDOUT. If the file does not exist, it
will be created (and will include the comment markers for future updates).
$ dbschema-markdown --help
Usage: dbschema-markdown [options] <connectionString>
Output a Markdown document
Options:
--update-file <file> Markdown document to update (between comment markers) or
create (if the file does not exist)
Name | Column | Type | Nullable | Default | Example | Comments |
---|---|---|---|---|---|---|
Logs | ID | int() | false | PRIMARY KEY | ||
Logs | Created | datetime() | true | (getdate()) |
This is a demo, Additional Information about the Table
Name | Column | Type | Nullable | Default | Example | Comments |
---|---|---|---|---|---|---|
Users | ID | int() | false | Primary Key | PRIMARY KEY | |
Users | Name | varchar(50) | false | Full Name |