Supabase DB

Interacting with Supabase databases, user authentication, and storage buckets using the Python client.

Lord1Egypt Updated 2 repo stars

File contents

Supabase Db

Overview

Supabase is an open-source Firebase alternative providing database, auth, file storage, and real-time listeners.

When to Use This Skill

Use to quickly store structured relational data in PostgreSQL without maintaining a server.

Quick Start (with runnable code examples)

from supabase import create_client

url = "https://your-project.supabase.co"
key = "your-anon-key"
supabase = create_client(url, key)

# Insert a row into the profiles table
data = supabase.table("profiles").insert({"username": "Lord1Egypt"}).execute()
print(data.data)

Advanced Usage

Set up row-level security (RLS) policies, storage bucket uploads, and auth flow redirects.

Key References

Dependencies

  • supabase>=2.0.0

Lord1Egypt/ai-skillforge/tree/main/js/skills/gemini/supabase-db commit d0a6ba7298

Frequently asked questions

npx skillmds@latest add lord1egypt/supabase-db-2