[BUG] ImportError with MYSQL

[muthukumar-relevantz]

Description

I am getting " ImportError: Unable to import required packages for MySQL loader. Run `pip install --upgrade ‘embedchain[mysql]’ " as a error while running crew. I am using MySQLSearchTool - as specified in the docs. I verified the installation of embedchain - and it is there. Can someone please help.

Steps to Reproduce

Import -> from crewai_tools import MySQLSearchTool
run -> crewai run

Expected behavior

The MYSQL Connector should connect with the database

Screenshots/Code snippets

Operating System

Windows 10

Python Version

3.11

crewAI Version

0.102.0

crewAI Tools Version

=0.102.0,<1.0.0

Virtual Environment

Venv

Evidence

Possible Solution

The unavailability of MySQL reference in Loaders is the issue - may be.

Additional context

NA

[Vidit-Ostwal]

Can you confirm whether the your virtual environment has this particular package or not?

[omar-saadoun]

I do have the packages installed but also get an error:

/connector/abstracts.py", line 697, in config
raise AttributeError(f"Unsupported argument '{key}'") from None
AttributeError: Unsupported argument 'url'

I tried overriding but still same issue:

class FixedMySQLLoader(MySQLLoader):
def _setup_loader(self, config):
import mysql.connector as sqlconnector
parsed_url = urlparse(config['url'])

    connection_config = {
        'host': parsed_url.hostname,
        'user': parsed_url.username,
        'password': parsed_url.password,
        'database': parsed_url.path.lstrip('/'),
        'port': parsed_url.port or 3306
    }
    self.connection = sqlconnector.connect(**connection_config)

Create the tool with the fixed loader

tool = MySQLSearchTool(
db_uri=db_uri,
table_name="menu_items_normalized_v1_1"
)
tool.loader = FixedMySQLLoader(config={'url': db_uri})

[gvcoder]

Can you confirm whether the your virtual environment has this particular package or not?

Yes, I confirm. I re-verified it once again. Infact I tried to write a simple connector with python - it works from the same folder. But crewai is not detecting. strange.!!!!

[Vidit-Ostwal]

Hi @gvcoder, I tried to check whether the venv has the module called embedchain.
But didn't find one.

Can you again confirm whether you were able to find the embedchain module?

Additionally, can you try add embedchain by using uv add embedchain and then check again.
Thanks

Let me know, will try to fix this.

[gvcoder]

Yes @Vidit-Ostwal - embedchain module is available in the folder.

[Vidit-Ostwal]

Hi @gvcoder, I think I understand the issue in here, so if we try to run crewai run, over the cli.
It will try to make a uv with dependencies in, pyproject.toml. There crewai_tools is given under optional dependency.

This needs to get changed I believe, crewai_tools, should be installed while making the virtual environment.

[project.optional-dependencies]
tools = ["crewai-tools>=0.37.0"]
embeddings = [
    "tiktoken~=0.7.0"
]

[Vidit-Ostwal]

I think this should solve this issue.

[gvcoder]

[project]
name = "sqlapp"
version = "0.1.0"
description = "sqlapp using crewAI"
authors = [{ name = "Your Name", email = "you@example.com" }]
requires-python = ">=3.10,<3.13"
dependencies = [
"crewai[tools]>=0.102.0,<1.0.0"
]

[project.scripts]
sqlapp = "sqlapp.main:run"
run_crew = "sqlapp.main:run"
train = "sqlapp.main:train"
replay = "sqlapp.main:replay"
test = "sqlapp.main:test"

[build-system]
requires = ["hatchling"]
build-backend = "hatchling.build"

[tool.crewai]
type = "crew"

So - the suggested change is add this with the existing pyproject.toml?

//[project.optional-dependencies]
tools = ["crewai-tools>=0.37.0"]
embeddings = [
"tiktoken~=0.7.0"
]//

[Vidit-Ostwal]

The suggested changes is to have crewai-tools get installed, when crewai gets installed.

Otherwise you can also explicitly, get crewai and crewai-tools get installed, in your own pyproject.toml file

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[lucasgomide]

I think it was fixed since we have crew pyproject template added crewai[tool] already