aio-libs/aiopg

Health v2 · maintenance only

Adoption not part of the score

1431 stars · 169 forks observed · 2026-08-28

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

aiopg is a Python library for accessing PostgreSQL databases from asyncio applications, wrapping the asynchronous features of the Psycopg driver. It provides connection pooling, async cursors, and optional SQLAlchemy Core integration via aiopg.sa.

Use cases

• query postgres from an asyncio application
• async postgres connection pool in python
• use sqlalchemy core with asyncio and postgres
• run non-blocking database queries in aiohttp web app
• listen to postgres notifications asynchronously
• migrate blocking psycopg code to asyncio

When to choose

• you need asynchronous PostgreSQL access in an asyncio-based Python app
• you want connection pooling with async/await syntax
• you use SQLAlchemy Core expressions with async execution
• you need LISTEN/NOTIFY support without blocking the event loop

When to avoid

• you use async frameworks built on asyncpg-style APIs and want maximum raw performance (consider asyncpg)
• you need full async SQLAlchemy ORM sessions (use SQLAlchemy's native asyncio support instead)
• your application is synchronous/threaded and doesn't use asyncio
• you target databases other than PostgreSQL

Facets

library · maturity active

database-driver database orm concurrency databases backend web-development developer-tools python windows cross-platform asyncio postgresql psycopg sqlalchemy connection-pool async-database linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="aio-libs/aiopg")