Dataki for MySQL
Ask MySQL in plain English
Ask your MySQL database questions in plain English. Dataki writes the SQL, runs it with a read-only user and charts the answer — in the browser, or from Claude, ChatGPT or Cursor.
Connects directly A read-only user, over TLS, from one fixed IP.
Which products sold the most units last month?
Trail runner 2 sold 1,842 units in August, about a fifth more than any other product.
01Questions
What people ask MySQL
Each one becomes a query against MySQL, run read-only, with the SQL shown beside the chart so anyone who reads SQL can check it. Anything worth keeping goes on a dashboard that refreshes on its own.
- What was the average order value by country last month?
- Which products are out of stock but still getting orders?
- How many orders were refunded each week, and what were they worth?
- Which customers ordered more than three times this year?
02From your assistant
Ask MySQL from Claude, ChatGPT or Cursor
Dataki runs a hosted MCP server. Add it to your assistant once and it can read your MySQL schema and run read-only queries through Dataki. The assistant gets the rows back; the MySQL credentials stay encrypted in Dataki and never reach the model.
Setup for your assistant:
Show me daily orders and revenue for the last 30 days from the shop database, as a chart.
- list_sources · finds MySQL · shop
- get_data_context · reads the tables and what the columns mean
- query · runs the SQL read-only, returns the rows
- render_ui · draws the chart from those rows, in the chat
https://dataki.ai/api/mcp 03Setting it up
Connecting MySQL
A read-only user, over TLS, from one fixed IP. The setup guide covers it step by step.
- Setup
- About 5 minutes.
- Connects from
34.89.253.13, one fixed address to allow.- Encryption
- TLS whenever the server offers it. The server certificate is not verified, and client certificates are not supported.
- What it reads
- Tables and views in the database you name.
Live dashboards
Every answer can become a live dashboard.
Ask in plain English. Dataki writes the SQL, runs it on your database and charts the answer. Keep it as a dashboard with its own link, and your team sees current numbers every time they open it.
3 views · Updated just now
One click turns the answer into a dashboard:
Always current. The query runs again whenever the dashboard opens, so Friday's meeting sees Friday's numbers.
- Share it
- Send the link to anyone. Viewers are free on every plan.
- Refine it
- The SQL is always visible. Adjust it by hand or ask for a change.
- Embed it
- Put the same dashboard in your own product with two HTML tags.
Using Dataki with MySQL
- Can I query MySQL in plain English instead of writing SQL?
- Yes. Dataki reads your MySQL schema, turns a plain-English question into a query, runs it on MySQL and returns a chart. The query is shown with every result, so you can check or edit it.
- Is there a hosted MySQL MCP server?
- Yes, Dataki. Its remote MCP server reaches MySQL through a read-only connection you set up once in Dataki: nothing to install, and no connection string in your assistant's config. Assistants can list sources, read the schema and what it means, run read-only SQL, draw charts in the conversation and save dashboards. Every query is logged with the key that ran it.
- How do I build a dashboard from MySQL data without an ETL pipeline?
- Connect MySQL to Dataki with a read-only connection, ask your question and save the answer as a dashboard widget. Dataki queries MySQL live, so there is no pipeline to build, no warehouse to sync and no copy of your data to maintain.
- Can Claude, ChatGPT or Cursor query my MySQL data?
- Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect MySQL to Dataki, add that URL as a connector in Claude or ChatGPT (or in Cursor, VS Code or Claude Code with a Dataki key), and your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.