python install_error ai_generated true

ModuleNotFoundError: No module named 'psycopg2'

ID: python/sqlalchemy-missing-driver

Also available as: JSON · Markdown · 中文
80%Fix Rate
90%Confidence
0Evidence
2025-08-01First Seen

Version Compatibility

VersionStatusIntroducedDeprecatedNotes
3.x active — — —

Root Cause

The database driver for PostgreSQL is not installed in the Python environment.

generic

中文

Python 环境中未安装 PostgreSQL 数据库驱动程序。

Workarounds

  1. 95% success Install psycopg2 using pip 
    pip install psycopg2-binary
  2. 85% success Switch to a different driver like asyncpg 
    # Change connection string to use asyncpg
engine = create_engine('postgresql+asyncpg://user:pass@localhost/db')

Dead Ends

Common approaches that don't work:

  1. Installing a different driver without changing the connection string 70% fail

    The connection string still references psycopg2.

  2. Using a virtual environment without activating it 80% fail

    The module is installed but not accessible.