any way to keep a schema in the project?

I usually do supabase with prisma, going for raw Supabase made it hard to feed context to the AI, what is the recommended way to keep a snapshot of our db schema so AI always know the db state?
3 Replies
Ideagarage
Ideagarage4w ago
I'm curious how fellows do, but I'm using this to get fresh code in my supabase/schemas https://github.com/idea-garage/supatool
silentworks
silentworks4w ago
I think if you use declarative schemas you would have the db schema in your project. Also can't AI just read the migrations? or you can just create a db dump of the schema ever so often for the sake of AI. Note I don't use AI tools so my suggestions may be off as they are not from experience but from what I think would work.
garyaustin
garyaustin4w ago
"but from what I think would work" Just like an AI would do...

Did you find this page helpful?