supabase/postgrest-py(opens in a new tab)
Language: Python
PostgREST client for Python. This library provides an ORM interface to PostgREST
- stars
- 322
- watchers
- 5
- forks
- 70
- open issues
- 7
- Last updated
- 09/09/2025
Language: Python
PostgREST client for Python. This library provides an ORM interface to PostgREST
Warning
This repository has been moved to the supabase-py monorepo.
PostgREST client for Python. This library provides an "ORM-like" interface to PostgREST.
If you want to use a local PostgREST server for development, you can use our preconfigured instance via Docker Compose.
docker-compose up
Once Docker Compose started, PostgREST is accessible at http://localhost:3000.
poetry add postgrest
pip install postgrest
import asyncio from postgrest import AsyncPostgrestClient async def main(): async with AsyncPostgrestClient("http://localhost:3000") as client: r = await client.from_("countries").select("*").execute() countries = r.data asyncio.run(main())
await client.from_("countries").insert({ "name": "Việt Nam", "capital": "Hà Nội" }).execute()
r = await client.from_("countries").select("id", "name").execute() countries = r.data
await client.from_("countries").update({"capital": "Hà Nội"}).eq("name", "Việt Nam").execute()
await client.from_("countries").delete().eq("name", "Việt Nam").execute()
await client.rpc("foobar", {"arg1": "value1", "arg2": "value2"}).execute()
git clone https://github.com/supabase/postgrest-py.git
cd postgrest-py
poetry install
poetry run pre-commit installpoetry run pytest
Read more here.
We are building the features of Firebase using enterprise-grade, open source products. We support existing communities wherever possible, and if the products don’t exist we build them and open source them ourselves. Thanks to these sponsors who are making the OSS ecosystem better for everyone.