supabase-python

Develop FastAPI applications with Supabase authentication, storage, and SQLModel database operations.

705|56|Updated Dec 26, 2025
One-click install
npx skills add https://github.com/alinaqi/claude-bootstrap --skill supabase-python-alinaqi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-python
Source: https://github.com/alinaqi/claude-bootstrap/tree/main/skills/supabase-python
Command: npx skills add https://github.com/alinaqi/claude-bootstrap --skill supabase-python-alinaqi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires fastapi, uvicorn, supabase, python-dotenv, sqlmodel, asyncpg, alembic, pydantic-settings, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a robust framework for building Python web applications that leverage Supabase for authentication, storage, and real-time features, combined with SQLAlchemy/SQLModel for type-safe database interactions.

Core Features & Use Cases

  • Backend Development: Rapidly build APIs with FastAPI.
  • Database Management: Utilize SQLModel for defining and querying database models.
  • Authentication: Integrate Supabase Auth for user sign-up, sign-in, and sign-out.
  • Storage: Handle file uploads and downloads with Supabase Storage.
  • Real-time: Implement real-time data subscriptions using Supabase's real-time capabilities.
  • Use Case: Develop a social media application where users can sign up, post content, upload profile pictures, and see real-time updates from other users.

Quick Start

Run the FastAPI application using uvicorn.

Frequently Asked Questions about supabase-python

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I integrate Supabase authentication into a FastAPI application?▼

FastAPI applications integrate Supabase authentication to handle user sign-up, sign-in, and sign-out operations. This Skill provides the framework combining Supabase Auth for identity management with FastAPI routing.

Can I use SQLModel and SQLAlchemy together with Supabase in a Python backend?▼

Yes, you can use SQLModel and SQLAlchemy with Supabase in a Python backend. This combination enables type-safe database operations while leveraging Supabase for authentication, storage, and real-time data capabilities.

What is the best way to handle async file uploads to Supabase Storage using Python?▼

Handling async file uploads to Supabase Storage in Python is best achieved by utilizing async I/O operations within a FastAPI application. This Skill manages file upload and download processes directly through Supabase Storage.

Does Python support real-time data listening with Supabase?▼

Python supports real-time data listening with Supabase through asynchronous operations. This Skill implements real-time data subscriptions, allowing applications to receive live database updates.

Do I need asyncpg to perform async database operations with FastAPI and SQLModel?▼

Yes, asyncpg is required to perform async database operations with FastAPI and SQLModel. It enables efficient asynchronous I/O for database interactions, complementing the SQLAlchemy and Supabase integration.

Why use Alembic with SQLModel for database management in a FastAPI project?▼

Using Alembic with SQLModel in a FastAPI project provides structured database migration management. Alembic handles schema versioning while SQLModel defines type-safe database models for querying operations.