Dynamically creating table and data model

[Muzzamil1]

Hi all!
Is it possible to generate the data model dynamically? 
My use case is that the frontend user should be able to add, modify and delete tables in the database and work with them afterward. As far as I know, the schema is saved in the Prisma data model file, which should be deployed after changes in the schema. Is there a way to deploy changes in the schema directly?

[nikolasburk]

Hey @Muzzamil1, if I understand your question correctly, you're looking for a way to programmatically migrate the database schema. Ist that correct?

If so, then this is currently not natively supported by Prisma Migrate unfortunately, we already have an open issue for this here. As a workaround, you can consider invoking the prisma migrate commands from Node.js.

Also, this library might be helpful for you: https://github.com/amplication/prisma-schema-dsl

Let me know if that helps or if you have any further questions, always happy to help!

[Muzzamil1]

Thanks @nikolasburk for answering!
Yeah, you are right. I'm looking for a way to programmatically migrate the database schema. It would be great to have this feature built-in
in Prisma.
Thanks, will look into both solutions that you provided.

[vineyrawat]

@Muzzamil1 Did you found any way for doing this cause I'm also facing this problem. It would be great if you share. Thanks in advance.

[Muzzamil1]

Unfortunately No

[Muzzamil1]

Please don't mention it.

Please share the solution here if you found a way. That will be very helpful

[Malenconiaprincep]

@nikolasburk may I ask when it is planned to be developed? This is not a good fit for low-code development right now.

[TejasThombare20]

Hi all! Is it possible to generate the data model dynamically?  My use case is that the frontend user should be able to add, modify and delete tables in the database and work with them afterward. As far as I know, the schema is saved in the Prisma data model file, which should be deployed after changes in the schema. Is there a way to deploy changes in the schema directly?

@Muzzamil1 have you got the solutions for your case