there are the old ones plsm comes to mind, and then LLM - also worth noting ash can generate resources from existing DB ash_postgres/documentation/tutorials/set-up-with-existing-database.md at main · ash-project/ash_postgres · GitHub - even if you don’t need ash it might generate structured data for you (or an LLM)..

You might also try with dynamic introspection if you ever need it: Endo — Endo v0.1.24

Not sure the library is very actively maintained anymore but if it is feature-complete then that does not matter.

There is also this: GitHub - cogini/ecto_extract_migrations: Elixir library to generate Ecto migrations from a PostgreSQL schema SQL file. Uses NimbleParsec and macro-style code generation. · GitHub

Never tried it and it has not been updated in a long time but if you have the time, you might give it a shot.

None of these two address your need directly. But, in case you need a slightly different scenario in the future.

Thanks for the answers.

I went with a mixed solution. I got the LLM to generate a script that would will create the schema for a single table.