MySQLDb stores an Agent’s sessions and run history in MySQL.
Usage
Install thesqlalchemy, pymysql, and openai packages:
uv pip install sqlalchemy pymysql openai
Run MySQL
Install Docker Desktop, then start MySQL on port3306:
docker run -d \
--name mysql \
-e MYSQL_ROOT_PASSWORD=ai \
-e MYSQL_DATABASE=ai \
-e MYSQL_USER=ai \
-e MYSQL_PASSWORD=ai \
-p 3306:3306 \
mysql:8
mysql_for_agent.py
from agno.agent import Agent
from agno.db.mysql import MySQLDb
db_url = "mysql+pymysql://ai:ai@localhost:3306/ai"
db = MySQLDb(db_url=db_url)
agent = Agent(
db=db,
add_history_to_context=True,
)
agent.print_response("How many people live in Canada?")
agent.print_response("What is their national anthem called?")
Parameters
| Parameter | Type | Default | Description |
|---|---|---|---|
id | Optional[str] | None | Database ID. Derived from the connection and schema when omitted. |
db_engine | Optional[Engine] | None | SQLAlchemy database engine. Provide this or db_url. |
db_schema | Optional[str] | None | Database schema. Uses "ai" when omitted. |
db_url | Optional[str] | None | Database URL. Provide this or db_engine. |
session_table | Optional[str] | None | Table for Agent, Team, and Workflow sessions. Uses "agno_sessions" when omitted. |
memory_table | Optional[str] | None | Table for memories. Uses "agno_memories" when omitted. |
metrics_table | Optional[str] | None | Table for metrics. Uses "agno_metrics" when omitted. |
eval_table | Optional[str] | None | Table for evaluation run data. Uses "agno_eval_runs" when omitted. |
knowledge_table | Optional[str] | None | Table for knowledge content. Uses "agno_knowledge" when omitted. |
culture_table | Optional[str] | None | Table for cultural knowledge. Uses "agno_culture" when omitted. |
traces_table | Optional[str] | None | Table for traces. Uses "agno_traces" when omitted. |
spans_table | Optional[str] | None | Table for spans. Uses "agno_spans" when omitted. |
versions_table | Optional[str] | None | Table for schema versions. Uses "agno_schema_versions" when omitted. |
create_schema | bool | True | Create the database schema when it does not exist. Set to False when migrations manage it. |