{"library":"psycopg2","type":"library","category":null,"description":"The most widely used PostgreSQL adapter for Python. Sync only. Two packages on PyPI: psycopg2 (source, requires libpq dev headers) and psycopg2-binary (pre-compiled, no system deps). Official docs explicitly warn against psycopg2-binary in production. Current version: 2.9.11 (Mar 2026). For async PostgreSQL use asyncpg or psycopg (v3). For new projects consider migrating to psycopg (v3) which has both sync and async.","language":"python","status":"active","version":"2.9.11","tags":["psycopg2","postgresql","python","database","sync"],"install":[{"cmd":"pip install psycopg2-binary","imports":["import psycopg2"]},{"cmd":"pip install psycopg2","imports":[]}],"homepage":"https://psycopg.org/","github":"https://github.com/psycopg/psycopg2","docs":"https://www.psycopg.org/docs/","changelog":"https://www.psycopg.org/docs/news.html","pypi":"https://pypi.org/project/psycopg2/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":1.8,"avg_import_s":0.05,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/psycopg2/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Tue Jun 30","last_verified":"Tue Jun 30","next_check":"Thu Jul 30","install_tag":"verified"}}