Extract/infer a pydantic model from a prexisting database

[mhlr]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

NA

Description

• Have a prexisting, possibly complex, sql database instance
• No prexisting python model classes
• Automatically generate the pydantic model corresponding to the tables in the database.

Operating System

Linux

Operating System Details

Ubuntu-22.04

SQLModel Version

0.0.8

Python Version

3.9

Additional Context

(How) can I use SQLModel to generate a pydantic model for an existing SQL database, say MS SQL Server for concreteness (but any database really)?

[YuriiMotov]

There is no such tool for now, but this feature in SQLModel's roadmap: