Skip to main content

MySQL

Store conversation history in MySQL.

Setup

# Docker
docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=praisonai mysql:8

# Install driver
pip install pymysql

Usage

from praisonai.persistence.factory import create_conversation_store

store = create_conversation_store(
    "mysql",
    url="mysql+pymysql://root:password@localhost:3306/praisonai"
)

CLI

praisonai persistence doctor --conversation-url "mysql+pymysql://root:password@localhost:3306/praisonai"

Configuration

OptionDescription
urlMySQL connection URL
pool_sizeConnection pool size (default: 5)
table_prefixTable name prefix (default: praison_)