Libraries & frameworks
psycopg2
psycopg/psycopg2
Psycopg 2 is the widely used PostgreSQL adapter for Python, implementing the DB-API 2.0 spec with thread safety, cursors, async notifications, and COPY support.
Topics
Related projects
psycopg2.5kPsycopg 3 is the modern PostgreSQL adapter for Python, giving applications fast, safe database access with connection pooling and async support.
postgres8.8kPostgres.js is a fast, full-featured PostgreSQL client for Node.js with tagged-template queries, transactions, subscriptions, and type mapping.
ibis6.7kIbis is a portable Python dataframe library whose expressions compile to SQL or native engines, letting the same code run across more than 20 backends.
piccolo2kPiccolo is a fast, async-friendly Python ORM and query builder. It includes migrations, an admin interface, and scaffolding for ASGI frameworks, while staying lightweight and type-annotated.
django-migration-linter623A Django plugin that lints migrations for backward-incompatible changes and integrates with CI and makemigrations.
django-migration-linter622A Django linter that detects backward-incompatible database migrations so older codebases are not broken, usable in CI or during migration generation.