MySQL

pip install "praisonai[tools]"

export MYSQL_HOST=localhost
export MYSQL_PORT=3306
export MYSQL_DATABASE=mydb
export MYSQL_USER=root
export MYSQL_PASSWORD=your_password

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)

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)

from praisonai_tools import MySQLTool

mysql = MySQLTool(host="localhost", database="mydb", user="root", password="pass")
results = mysql.query("SELECT * FROM users WHERE active = 1")

mysql.execute("INSERT INTO users (name, email) VALUES ('Bob', '[email protected]')")

tables = mysql.list_tables()

docker run -d --name mysql \
    -e MYSQL_ROOT_PASSWORD=praison123 \
    -e MYSQL_DATABASE=praisonai \
    -p 3306:3306 \
    mysql:8