MySQL
Persist Agno sessions and other data in MySQL.
MySQLDb stores Agent, Team, and Workflow sessions, memories, knowledge, evaluations, and traces in MySQL.
Usage
Start in a virtual environment.
Install Agno, SQLAlchemy, PyMySQL with its MySQL 8 authentication extra, and the OpenAI client:
uv pip install agno sqlalchemy "pymysql[rsa]" openaifrom agno.agent import Agent
from agno.db.mysql import MySQLDb
db = MySQLDb(db_url="mysql+pymysql://ai:ai@localhost:3306/ai")
agent = Agent(db=db)Run MySQL
Install Docker Desktop, then start MySQL on port 3306:
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:8Parameters
| 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. |
runs_table | Optional[str] | None | Table for session runs. Uses "agno_runs" with the default session table, or <session_table>_runs when session_table is customized. |
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. |
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. |