SELECT city, AVG(order_value) FROM orders GROUP BY 1 ORDER BY 2 DESC;
Chat with your MySQL database in plain English
Connect MySQL to your Kanaries workspace and ask questions the way you would ask a colleague. The AI assistant writes the SQL, runs it, and answers with charts — so insights stop waiting on queries.
mysql://your-host:3306 → kanaries.workspace·credentials stored encrypted
how it works
One session. Three steps.
From connection string to answered question, everything happens inside the Kanaries workspace.
01 · connect
Point Kanaries at your MySQL database
Enter your host, user, and database. Kanaries connects securely and brings your tables into the workspace — no agents to install, nothing to migrate.
workspace — new connection (mysql) 
02 · model
Shape the data you want to talk about
Import the tables you need, or let the SQL assistant help you write a query. The result becomes a dataview — a clean slice of your database, ready for conversation.
workspace — dataview (sql assistant) 
03 · ask
Ask questions, get charts back
Open AIChat and ask in plain English. The assistant writes the SQL, runs it against your dataview, and replies with charts and summaries you can drop straight into your next report.
aichat — analytics session
why chat
Why chat beats the query editor
[input]
Plain-English querying
Ask "Show the distribution of review_score" or "Which segment grew fastest last quarter?" — natural language in, real query out. No JOIN syntax between you and your answer.
[output]
Charts, not just result sets
The assistant pairs an LLM with a code interpreter, so answers arrive as professional visualizations built from your live MySQL data — not as walls of rows to squint at.
[trust]
Your credentials stay yours
Connection details are encrypted in transit and at rest. The assistant only touches the dataviews you define, so you decide exactly which slice of the database joins the conversation.
faq
Questions, answered
Can't find what you're looking for? Reach our team from the contact page and we'll get back to you.
Do I need to know SQL to chat with my MySQL database?
+
No. You ask questions in plain English — like "Show the distribution of review_score" — and the AI assistant writes the SQL, runs it against your database, and answers with charts and summaries. If you do know SQL, the SQL assistant is there when you want to shape a dataview yourself.
How do I connect my MySQL database to Kanaries?
+
Enter your MySQL host, port, username, password, and database name in the workspace. Kanaries establishes the connection securely, and you can then import the tables you need or query a slice of your data into a dataview.
Is my MySQL connection information secure?
+
Yes. Connection details are encrypted in transit and stored encrypted, so your credentials remain private and protected.
What kinds of questions can I ask about my data?
+
Anything you would normally answer with a query: distributions, trends over time, top-N rankings, comparisons between segments, or open-ended prompts like "Recommend an interesting chart from this dataset."
What types of charts can the assistant generate?
+
Bar charts, line charts, scatter plots, histograms, pie charts, and more — the assistant picks a sensible visualization for your question, or you can ask for a specific chart type.
How accurate are the answers?
+
The assistant pairs a large language model with a code interpreter, so answers come from real queries executed against your actual data, not from guesswork. For complex questions, refining your prompt or narrowing the dataview improves results.
also speaks
The same conversation, other databases
mysql> \q
Leave the SQL to the assistant
Close the console, keep the answers. Connect your MySQL database and ask your first question in minutes.