Build FastAPI backends with Supabase authentication and typed PostgreSQL access.
npx skills add https://github.com/lciacci/tessera --skill supabase-python-lciacci
Please help me install this Agent Skill. Skill: supabase-python Source: https://github.com/lciacci/tessera/tree/main/skills/supabase-python Command: npx skills add https://github.com/lciacci/tessera --skill supabase-python-lciacci
This Skill helps developers build Python web backends without having to design authentication, database access, storage, migrations, and testing patterns from scratch.
Ask the supabase-python skill to scaffold a FastAPI application with Supabase authentication, SQLModel models, asynchronous PostgreSQL access, migrations, storage, and tests.
High-intent search queries and answers about installing and using this skill.
To integrate Supabase authentication into a FastAPI backend, you use the supabase-py client alongside dependency injection to secure routes and manage user sessions. This setup handles user logins and protects API endpoints without building auth logic from scratch.
The best way to connect FastAPI to PostgreSQL with SQLModel and Supabase is by defining typed models and managing asynchronous database sessions via asyncpg. This pattern provides typed data access and integrates smoothly with Supabase backend services.
You set up Alembic migrations for FastAPI and SQLAlchemy projects by defining typed models and configuring asynchronous PostgreSQL sessions. Alembic then generates and applies database schema migrations automatically based on your SQLModel or SQLAlchemy changes.
Yes, you can use Supabase storage and realtime features in a Python API by configuring the supabase-py client within your FastAPI application. This allows your backend to handle file uploads like avatars and push realtime updates directly to connected clients.
Yes, this FastAPI Supabase pattern supports asynchronous testing by using an isolated PostgreSQL database environment. You can test CRUD routes, file storage, and authentication logic asynchronously without affecting your production data.
AdigunQDevelop full-stack FastAPI applications with Supabase authentication, database, and storage.
LevironexeEnforces Supabase @supabase/ssr separation, RLS policies, repository queries, and realtime cleanup for JavaScript frameworks.
shafibabarStandardize asynchronous FastAPI route handlers with Pydantic v2 validation and centralized error mapping.
nimranaz148Define SQLModel ORM models and CRUD operations for PostgreSQL backends.
