Repository files navigation

Generate database comments from Prisma schema to a MySQL database.

It is based on the following code idea. Thank you @Jyrno42 .

• prisma/prisma#8703 (comment)

• Create a migration SQL for theALTER TABLE table_name MODIFY COLUMN column_name column_type COMMENT "comment"; statement based on the information in theschema.prisma file.
  • Comments written with triple slashes (///) are eligible.
• Supports only column comments for now (PRs are welcome).

Install this package.

npm install --save-dev prisma-mysql-comments-generator

Add the generator to theschema.prisma

generatorcomments {provider="prisma-mysql-comments-generator"}

Runnpx prisma generate to trigger the generator.A SQL file withALTER TABLE table_name MODIFY COLUMN column_name column_type COMMENT "comment"; is generated in the migrations folder.

MIT

thelinuxlich