MagicStack/asyncpg

Health v2 · maintenance only

Adoption not part of the score

8075 stars · 464 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

asyncpg is a fast PostgreSQL client library for Python built directly on the PostgreSQL binary protocol and designed for asyncio. It exposes native PostgreSQL features like prepared statements, scrollable cursors, and automatic composite/array type encoding without a DB-API facade.

Use cases

• connect to postgresql from python asyncio code
• run high-performance queries against postgres
• execute prepared statements with async python
• fetch large query results efficiently with cursors
• work with postgres arrays and composite types in python
• build async web backends backed by postgres

When to choose

• you use asyncio and need the fastest postgres driver for python
• you want native postgres protocol features like custom types and scrollable cursors
• you are building async applications or services on postgres

When to avoid

• you need a synchronous driver or DB-API 2.0 compatibility
• you need multi-database support beyond postgresql
• you rely on ORMs that only support psycopg-style drivers

Facets

library · maturity stable

database-driver database databases backend developer-tools python cross-platform postgresql asyncio binary-protocol prepared-statements high-performance

Member repositories

For agents

markdown · JSON · MCP: product_card(name="MagicStack/asyncpg")