Documentation Index
Fetch the complete documentation index at: https://docs.praison.ai/llms.txt
Use this file to discover all available pages before exploring further.
Overview
MySQL tool allows you to query and manage MySQL databases directly from your AI agents.
Installation
pip install "praisonai[tools]"
Environment Variables
export MYSQL_HOST=localhost
export MYSQL_PORT=3306
export MYSQL_DATABASE=mydb
export MYSQL_USER=root
export MYSQL_PASSWORD=your_password
Quick Start
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)
Usage with Agent
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.
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).
mysql.execute("INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com')")
list_tables()
List all tables in the database.
tables = mysql.list_tables()
Docker Setup
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 |
