MySQL logo

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.

app.dataki.ai / chat MySQL · shop

Which products sold the most units last month?

Reading the schema, writing the query…
SQL 310 ms · read-only
SELECT p.name AS product, SUM(i.quantity) AS units
FROM   order_items i
JOIN   products p ON p.id = i.product_id
WHERE  i.created_at >= DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH, '%Y-%m-01')
  AND  i.created_at <  DATE_FORMAT(CURDATE(), '%Y-%m-01')
GROUP BY p.name ORDER BY units DESC LIMIT 5;
Units sold by product August · 5 rows
Trail runner 2Merino crew sockPackable rain shellInsulated bottleDaypack 22L 05001k1.5k2k

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:

Claude · dataki (MCP) MySQL · shop

Show me daily orders and revenue for the last 30 days from the shop database, as a chart.

  1. list_sources · finds MySQL · shop
  2. get_data_context · reads the tables and what the columns mean
  3. query · runs the SQL read-only, returns the rows
  4. render_ui · draws the chart from those rows, in the chat
server URL streamable http
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.

The answer is still there tomorrow.

Ask in plain language. Dataki writes the SQL, runs it against your warehouse and draws the chart. Anything worth keeping becomes a dashboard with a link — not a message that scrolls away.

app.dataki.ai / chat

Which channels actually brought in revenue last quarter?

Queried bigquery · payments · 1.2 GB scanned
SELECT channel,
       SUM(amount) AS revenue
FROM   payments
WHERE  created_at >= DATE_TRUNC(CURRENT_DATE(), QUARTER)
GROUP BY channel
ORDER BY revenue DESC

Revenue by channel

Q3 · 5 rows

Organic search
$412,900
Partner referral
$268,400
Email
$151,200
Paid social
$96,700
Direct
$61,300

One click later, that chart is a dashboard of its own:

app.dataki.ai/d/revenue-by-channel

Live, not a screenshot. It re-runs the query on a schedule, so the number your team reads on Friday is Friday's number.

  • Share the link with anyone. Viewers are free on every plan.
  • Edit the SQL by hand whenever the model gets the logic almost right.
  • Drop the same dashboard into your own product with one line of HTML.

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 against MySQL and returns a chart. The generated query is shown with every result, so you can verify or edit it.
Is there a hosted MySQL MCP server?
Dataki is one. Its remote MCP server reaches MySQL through a read-only connection you set up once in Dataki, so nothing is installed on your machine and no connection string goes into an assistant's config. It offers tools to list sources, read the schema and its documented meaning, 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 keep the answer as a dashboard widget. Dataki queries MySQL directly at read time, so there is no pipeline to build, no warehouse to sync into and no copy of your data to keep current.
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 the assistant can read the schema and run read-only queries. It gets the rows back; the credentials stay encrypted in Dataki and are never handed to the model.