> ## Documentation Index
> Fetch the complete documentation index at: https://praison.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# MySQL
> Query and manage MySQL databases
The MySQL tool lets an agent query and manage MySQL databases directly.
```mermaid theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
graph LR
subgraph "MySQL"
User[User] --> Agent[Agent]
Agent --> Tool[MySQLTool]
Tool --> DB[(MySQL)]
DB --> Result[Rows]
end
classDef input fill:#8B0000,stroke:#7C90A0,color:#fff
classDef process fill:#189AB4,stroke:#7C90A0,color:#fff
classDef output fill:#10B981,stroke:#7C90A0,color:#fff
class User,Agent input
class Tool,DB process
class Result output
```
## Overview
MySQL tool allows you to query and manage MySQL databases directly from your AI agents.
## Installation
```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
pip install "praisonai[tools]"
```
## Environment Variables
```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
export MYSQL_HOST=localhost
export MYSQL_PORT=3306
export MYSQL_DATABASE=mydb
export MYSQL_USER=root
export MYSQL_PASSWORD=your_password
```
## Quick Start
```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
from praisonai_tools import MySQLTool
# Initialize
mysql = MySQLTool(
host="localhost",
database="mydb",
user="root",
password="your_password"
)
# Query
results = mysql.query("SELECT * FROM users LIMIT 5")
print(results)
```
Use the same tool with an agent — see **Usage with Agent** below, or pass env vars and options from the sections above.
## How It Works
```mermaid theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
sequenceDiagram
participant User
participant Agent
participant MySQL as MySQLTool
participant DB as MySQL
User->>Agent: "Show top products"
Agent->>MySQL: query(sql)
MySQL->>DB: SELECT
DB-->>MySQL: rows
MySQL-->>Agent: results
Agent-->>User: final answer
```
## Usage with Agent
```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
from praisonaiagents import Agent
from praisonai_tools import MySQLTool
mysql = MySQLTool(
host="localhost",
database="mydb",
user="root",
password="your_password"
)
agent = Agent(
name="DBAnalyst",
instructions="You are a database analyst. Use MySQL to query data.",
tools=[mysql]
)
response = agent.chat("Show me the top 10 products by sales")
print(response)
```
## Available Methods
### query(sql)
Execute a SQL query.
```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
from praisonai_tools import MySQLTool
mysql = MySQLTool(host="localhost", database="mydb", user="root", password="pass")
results = mysql.query("SELECT * FROM users WHERE active = 1")
```
### execute(sql)
Execute a SQL statement (INSERT, UPDATE, DELETE).
```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
mysql.execute("INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com')")
```
### list\_tables()
List all tables in the database.
```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
tables = mysql.list_tables()
```
## Docker Setup
```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
docker run -d --name mysql \
-e MYSQL_ROOT_PASSWORD=praison123 \
-e MYSQL_DATABASE=praisonai \
-p 3306:3306 \
mysql:8
```
## Common Errors
| Error | Cause | Solution |
| ------------------------------- | -------------------- | ---------------------------------------- |
| `mysql-connector not installed` | Missing dependency | Run `pip install mysql-connector-python` |
| `Connection refused` | Database not running | Start MySQL server |
| `Access denied` | Wrong credentials | Check username/password |
## Best Practices
Read `MYSQL_HOST`, `MYSQL_USER`, and `MYSQL_PASSWORD` from the environment instead of hard-coding them in the tool call.
Agent-generated `SELECT`s can return huge result sets. Instruct the agent to add `LIMIT` so results stay within the context window.
Give the agent a read-only MySQL user for analytics tasks so generated SQL cannot modify data.
## Related Tools
PostgreSQL database
SQLite database
NoSQL database