This is a simple CLI to apply DDL scripts for individual objects for developers who are more comfortable writing SQL scripts.

• [x] Apply a set of individual DDL scripts to a database
• [x] Load staging data with post-process scripts for development/testing
• [x] Export data from tables & views
• [x] Generate dbdocs DBML for all (or subset) tables
• [x] Support for multiple schemas where names are unique across all schemas.
• [x] Parse files and identify dependencies. (e.g. views depend on tables)
• [x] Combine all scripts into a single file for deployment
• [ ] Support for multiple databases (e.g. postgres, mysql, mssql)
• [ ] Support for multiple schemas with the same names in multiple schemas.

Refer to the pre-requisites document for setting up the dbd cli.

Install the CLI globally using npm (or pnpm/yarn)

npm i --global @jerrythomas/dbd

Individual ddl scripts are expected to be placed under folders with names of the database object types. Subfolders are used to specify the schema names. Files are expected to have the same name as the object.

example

Node: The cli relies on dependencies mentioned in a yaml file (db.yaml) to execute scripts in a sequence. Refer to example folder.