Error: No Module Named sqlalchemy in python – fix

At times we get error in python stating that No Module named SQLAlchemy in python or  ModuleNotFoundError: No module named ‘ SQLAlchemy’. SQLAlchemy is a popular SQL toolkit and Object-Relational Mapping (ORM) library for Python.

It looks like you’re trying to use the SQLAlchemy module in Python but encountering an error indicating that it’s not installed.

 

 

Solution for Error No Module named SQLAlchemy in python:

To resolve this issue, you need to install the SQLAlchemy package. You can do this using pip, which is the package installer for Python. Here’s how you can install SQLAlchemy:

  1. Open your command prompt or Anaconda prompt
  1. Run the following command
 
pip install Flask-SQLAlchemy

Error No Module Named sqlalchemy in python 1

This command will download and install sqlalchemy and its dependencies.

If you are using jupyter notebook you can use the same command in the notebook itself

Error No Module Named sqlalchemy in python 2

 

 

 

Verify the installation (optional):

by starting a Python interpreter or Jupyter notebook you can try to import sqlalchemy as shown below

 

from flask_sqlalchemy import SQLAlchemy

print(SQLAlchemy.__version__)

this will import the psycopg2 package and will print its version

Output:

Error No Module Named sqlalchemy in python 3

 

 

Note :

If you continue to have issues, make sure that pip is up to date, you can upgrade pip by running

 
pip install --upgrade pip

And then try installing psycopg2 again.

 

 

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.

    View all posts