supabase
Supabase client for Python.
Decision gist · record as of 2026-08-14
Yes. Supabase-py is actively maintained, has no known vulnerabilities, installs with low friction, and is widely used (top 1000 on PyPI). It's the right choice if you're already using Supabase or considering it as a backend. If you need PostgreSQL access without the Supabase ecosystem, a lower-level driver may be more appropriate.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires SUPABASE_URL and SUPABASE_KEY environment variables pointing to a Supabase instance; Python 3.9 or later.
- Low friction installation with a pure Python wheel.
- Actively maintained with recent commits and no known vulnerabilities.
License · maintenance · safety
MIT (permissive) — MIT license permits commercial and private use with minimal restrictions, making it suitable for most projects.
last release 2026-06-04 (71 days) · last repo commit 2026-08-12 · 2,557 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 37,817,760 downloads/mo, #719 on PyPI
Alternatives
Verify before relying
pip install supabase
import os
from supabase import create_client, Client
url = os.environ.get("SUPABASE_URL")
key = os.environ.get("SUPABASE_KEY")
supabase = create_client(url, key)
data = supabase.table("countries").select("*").execute()- Whether the package handles connection pooling or concurrent request limits in production scenarios.
- Performance characteristics when working with large result sets or high-frequency real-time subscriptions.
- Specific error handling and retry behavior for network failures or service outages.
What it is and what it does
Supabase-py is a Python client that connects your application to a Supabase backend, which provides PostgreSQL databases, user authentication, real-time data synchronization, serverless functions, and file storage. It wraps Supabase's REST and WebSocket APIs into a single cohesive client, letting you perform database operations (insert, select, update, delete, upsert), manage user sign-up and sign-in, invoke edge functions, and upload or download files from storage buckets—all from Python code.
The client is built on top of several specialized libraries (postgrest for queries, supabase-auth for user management, storage3 for file operations, realtime for subscriptions, and supabase-functions for serverless invocation) and uses httpx for HTTP requests. It's designed for applications that want a managed backend without running their own infrastructure, making it useful for web apps, data pipelines, and serverless deployments that need a quick way to connect to a hosted database and authentication system.
Use it for
- Build a Flask or FastAPI web app with GitHub OAuth login and user session management via Supabase Auth.
- Load and transform data from external sources into a Supabase PostgreSQL database for analytics or reporting.
- Create a file upload/download system where users can manage photos or documents in Supabase Storage.
- Trigger serverless functions (edge functions) from Python to run backend logic without managing servers.
- Subscribe to real-time database changes and push updates to connected clients or background workers.
- Prototype a full-stack application without setting up a separate backend server or database infrastructure.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Supabase-py is actively maintained, has no known vulnerabilities, installs with low friction, and is widely used (top 1000 on PyPI). It's the right choice if you're already using Supabase or considering it as a backend. If you need PostgreSQL access without the Supabase ecosystem, a lower-level driver may be more appropriate.
Install
supabase on PyPI
Before you install
Low friction installation with a pure Python wheel. Actively maintained with recent commits and no known vulnerabilities. Requires Python 3.9 or later.
Requires SUPABASE_URL and SUPABASE_KEY environment variables pointing to a Supabase instance; Python 3.9 or later.
License in practice
MIT license permits commercial and private use with minimal restrictions, making it suitable for most projects.
Quickstart
pip install supabase
import os
from supabase import create_client, Client
url = os.environ.get("SUPABASE_URL")
key = os.environ.get("SUPABASE_KEY")
supabase = create_client(url, key)
data = supabase.table("countries").select("*").execute()Verify before relying
- Whether the package handles connection pooling or concurrent request limits in production scenarios.
- Performance characteristics when working with large result sets or high-frequency real-time subscriptions.
- Specific error handling and retry behavior for network failures or service outages.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 7 packagesrealtimesupabase-functionsstorage3supabase-authpostgresthttpxyarl |
| Maintenance | Actively maintained 71 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 37,817,760 / month, #719 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Operating System :: OS IndependentProgramming Language :: Python :: 3 |
Evidence: supabase-2.31.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “real-time database python”
- supabasePython client library for Supabase that provides unified access to…
- singlestoredbProvides a DB-API 2.0 compatible Python interface to SingleStore, a…
- realtimeA Python client for Supabase Realtime that sends ephemeral broadcast…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also postgrest · storage3 · supabase-functions · supabase-auth · supafunc · gotrue · realtime · querysource · sqlalchemy-aurora-data-api · pyhdb