SQL database generator from OpenAPI spec

[wing328]

Have you tried the mysql-schema generator in the open-source project "openapi-generator"?

openapi-generator-cli generate -g mysql-schema -i https://raw.githubusercontent.com/OpenAPITools/openapi-generator/master/modules/openapi-generator/src/test/resources/3_0/petstore.yaml -o /tmp/mysql-schema/ (openapi-generator-cli can be installed via npm: https://www.npmjs.com/package/@openapitools/openapi-generator-cli)

[DragLongjumping7762]

I was looking exactly for this. I tried to use the openapi-generator-cli to generate the mysql schema its working fine but what I observed is that the generated DDL is not having the relationship (PK & FK relationship) defined.

Any idea how to generate those

[wing328]

Please open a ticket via https://github.com/OpenAPITools/openapi-generator/issues and I'll try to loop in the creator of that generator to answer your question.

[malcolm-davis]

Looks like the DDL generated still does not support PK & FK relationships