This one wires up FastAPI with Supabase by keeping auth and storage on the Supabase side while using SQLAlchemy/SQLModel for actual database queries. You get type-safe models, async sessions, and proper dependency injection for both database access and JWT validation. The setup is opinionated: structured routes, Pydantic settings, separate Supabase clients for user and admin contexts. It's built for when you want Supabase's auth and realtime features but prefer writing SQL queries through an ORM instead of the Supabase client's query builder. Includes Alembic for migrations and a clean FastAPI project structure with proper async patterns throughout.

skills.sh installs
193
GitHub stars
685
last updated
Jun 3, 2026

Install

$ npx -y skills add alinaqi/claude-bootstrap --skill supabase-python --agent claude-code

Installs into .claude/skills of the current project.

Files

Supabase + Python Skill

FastAPI patterns with Supabase Auth and SQLAlchemy/SQLModel for database access.

Sources: Supabase Python Client | SQLModel


Core Principle

SQLAlchemy/SQLModel for queries, Supabase for auth/storage.

Use SQLAlchemy or SQLModel for type-safe database access. Use supabase-py for auth, storage, and realtime. FastAPI for the API layer.


Project Structure

Sponsors

Details

Repository
github.com/alinaqi/claude-bootstrap
Categories
Backend & APIs, Python, Databases
First seen
Jun 3, 2026

More from alinaqi/claude-bootstrap

All 54
1sickn33 avatardatabasesickn33/antigravity-awesome-skillsdatabase193skills.sh installs
2alinaqi avatarsupabase-nodealinaqi/claude-bootstrapsupabase node184skills.sh installs
3personamanagmentlayer avatargrpc-expertpersonamanagmentlayer/pclExpert-level gRPC, Protocol Buffers, microservices communication, and streaming180skills.sh installs
4akillness avatarapi-designakillness/oh-my-skillsapi design174skills.sh installs
5akillness avatarapi-documentationakillness/oh-my-skillsapi documentation174skills.sh installs
6akillness avatardatabase-schema-designakillness/oh-my-skillsdatabase schema design172skills.sh installs