`supabase-py`

Python client for Supabase

Documentation: supabase.com/docs
Usage:
- GitHub OAuth in your Python Flask app
- Python data loading with Supabase

PyPI installation

Install the package (for Python >= 3.9):

# with pip
pip install supabase

# with uv
uv add supabase

# with conda
conda install -c conda-forge supabase

Usage

Set your Supabase environment variables in a dotenv file, or using the shell:

export SUPABASE_URL="my-url-to-my-awesome-supabase-instance"
export SUPABASE_KEY="my-supa-dupa-secret-supabase-api-key"

Init client:

import os
from supabase import create_client, Client

url: str = os.environ.get("SUPABASE_URL")
key: str = os.environ.get("SUPABASE_KEY")
supabase: Client = create_client(url, key)

Use the supabase client to interface with your database.

Sign-up

user = supabase.auth.sign_up({ "email": users_email, "password": users_password })

Sign-in

user = supabase.auth.sign_in_with_password({ "email": users_email, "password": users_password })

Insert Data

data = supabase.table("countries").insert({"name":"Germany"}).execute()

# Assert we pulled real data.
assert len(data.data) > 0

Select Data

data = supabase.table("countries").select("*").eq("country", "IL").execute()

# Assert we pulled real data.
assert len(data.data) > 0

Update Data

data = supabase.table("countries").update({"country": "Indonesia", "capital_city": "Jakarta"}).eq("id", 1).execute()

Update data with duplicate keys

country = {
  "country": "United Kingdom",
  "capital_city": "London" # This was missing when it was added
}

data = supabase.table("countries").upsert(country).execute()
assert len(data.data) > 0

Delete Data

data = supabase.table("countries").delete().eq("id", 1).execute()

Call Edge Functions

def test_func():
  try:
    resp = supabase.functions.invoke("hello-world", invoke_options={'body':{}})
    return resp
  except (FunctionsRelayError, FunctionsHttpError) as exception:
    err = exception.to_dict()
    print(err.get("message"))

Download a file from Storage

bucket_name: str = "photos"

data = supabase.storage.from_(bucket_name).download("photo1.png")

Upload a file

bucket_name: str = "photos"
new_file = getUserFile()

data = supabase.storage.from_(bucket_name).upload("/user1/profile.png", new_file)

Remove a file

bucket_name: str = "photos"

data = supabase.storage.from_(bucket_name).remove(["old_photo.png", "image5.jpg"])

List all files

bucket_name: str = "charts"

data = supabase.storage.from_(bucket_name).list()

Move and rename files

bucket_name: str = "charts"
old_file_path: str = "generic/graph1.png"
new_file_path: str = "important/revenue.png"

data = supabase.storage.from_(bucket_name).move(old_file_path, new_file_path)

Important: Proper Client Shutdown

To ensure the Supabase client terminates correctly and to prevent resource leaks, you must explicitly call:

client.auth.sign_out()

Release files for supabase 2.31.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for supabase 2.31.0
File	Size	Uploaded
supabase-2.31.0.tar.gz	9.8 kB	Jun 4, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for supabase 2.31.0
File	Interpreter	ABI	Platform	Reset
supabase-2.31.0-py3-none-any.whl 16.7 kB Jun 4, 2026	Python 3	none	any	Details

Total release size: 26.5 kB

Release files / supabase-2.31.0.tar.gz

Download URL	supabase-2.31.0.tar.gz
Size	9.8 kB
Tags	Source
SHA-256 checksum How to use checksums	`3467b09d00482b9a0138235bdbde7a350426f93cf2a1342372eaddfc669f1206`
BLAKE2b-256 checksum How to use checksums	`fe8e54a2f950629689b1613434a61fc3bff5f92f84ba6b20213f5b2add05c1bb`
Upload date	Jun 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.8.2`

Release files / supabase-2.31.0-py3-none-any.whl

Download URL	supabase-2.31.0-py3-none-any.whl
Size	16.7 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`25f2a99207a75f2d9377e2332783b4389cf56b02cbebdaf0c1743112dcbb704e`
BLAKE2b-256 checksum How to use checksums	`95065e6f4bf89dedadf81f893832115c1866da1aa093142c9989c2818780dae3`
Upload date	Jun 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.8.2`