postgrest

Install

postgrest on PyPI

pip install postgrest

uv add postgrest

poetry add postgrest

Package facts

Evidence: postgrest-2.31.0-py3-none-any.whl

About postgrest

from the package's own PyPI description — quoted content, verbatim

docker-compose up

uv 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

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

An async Python client for PostgREST servers that provides ORM-like query building for PostgreSQL databases exposed via PostgREST REST APIs.

Low friction: pure-Python wheel with five lightweight dependencies. Active maintenance with a recent release 70 days ago.

MIT license (permissive): you may use, modify, and distribute this package freely in commercial or private projects with minimal restrictions.

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()
        print(r.data)

asyncio.run(main())

Verdict: A well-maintained async client for PostgREST with low install friction and permissive licensing. No known vulnerabilities and top-1000 PyPI popularity make it a solid choice for projects integrating Python with PostgREST-exposed PostgreSQL databases.

Needs verification

• Whether the five runtime dependencies (httpx, pydantic, deprecation, strenum, yarl) themselves have known vulnerabilities or maintenance concerns.
• Performance characteristics and connection pooling behavior under high concurrency.
• Compatibility guarantees across PostgREST and PostgreSQL minor versions.

Similar packages