Supabase Pydantic Models: Generate Pydantic Models from Your Supabase Database Schemas

[kmbhm1]

Hello everyone! I’m excited to share a new project that I’ve been working on for generating Supabase types/models.

What is it?
supabase-pydantic helps you generate Pydantic (v2) models directly from your Supabase database schema. While it’s currently focused on bridging FastAPI with supabase-py, the ultimate goal is to evolve into a versatile solution for generating models from various databases and using them across your Python stack. It takes inspiration from the TypeScript type generation capabilities in the Supabase CLI, aiming to offer a similar developer experience for Python users.

Key Features

• Seamless Model Generation: Automatically generate Pydantic models that mirror your Supabase schema, speeding up development.
• Integration with FastAPI & supabase-py: Streamline your API layers by ensuring consistent, strongly-typed data models.
• Pydantic v2 Support: Enjoy all the latest benefits of Pydantic’s improved performance and new features.
• Extensible: The codebase is designed with extensibility in mind—more databases and frameworks will be supported in the future.

Installation
The recommended installation is via pip:

pip install supabase-pydantic

You can also install with conda:

conda install -c conda-forge supabase-pydantic

Example
Try it with your local Supabase instance:

sb-pydantic gen --type pydantic --framework fastapi --local

Learn More
We’re actively working on documentation and guides. You can explore our (work-in-progress) guides website here: https://kmbhm1.github.io/supabase-pydantic

Get Involved
We’d love your feedback, suggestions, and contributions! Feel free to open issues, submit PRs, or discuss new ideas here.

Thanks for checking it out, and I look forward to hearing what you think. Let’s make Pydantic model generation from Supabase (and beyond) a breeze!