Docs  /  MySQL AI feature packs

MySQL AI feature packs

Implements the high-priority items from the “AI features with MySQL” brainstorm:

Feature Table / store Commands
Action audit ai_features.ai_audit_log + data/ai_features/audit.jsonl ai audit <action> [preview]
Dialogue state dialogue_sessions + per-session JSON files ai dialogue set/get
Intent corrections intent_corrections ai intent correct/list
Memory promotion memory_promotion_queue ai memory promote/queue/process
Hybrid RAG log rag_query_log ai rag <query>
Command usage command_usage ai usage <command…>

Offline fallback: when MySQL is unavailable, all writes go under data/ai_features/.

Schema

mysql -u root -p < sql/ai_features_schema.sql

Also created best-effort at runtime by _MySQLAIFeatures::InitAll().

Commands

ai status
ai audit tool_run "pathfind rl train dqn"
ai dialogue set sess1 math {"topic":"algebra"}
ai dialogue get sess1
ai intent correct algebra_solve algebra_factor how do I factor x^2-1
ai intent list 20
ai memory promote ep_42 working short_term 0.8 novel discovery
ai memory queue
ai memory process 10
ai rag love your neighbor
ai rag method=rrf source=bible love neighbor
ai rag law:due process equal protection
ai usage nn math train algebra

Aliases: mysqlai …, memdb …, mysql ai ….

Lua

ai_mysql_audit("script", "note")
ai_mysql_rag_log("query text")
Generated from the project markdown docs on 2026-07-24. This is a static, self-contained site.