PlanetScale logo

Dataki for PlanetScale

Ask PlanetScale in plain English

Connect PlanetScale to Dataki with a read-only password and ask your database questions in plain English. Dataki connects over TLS and keeps the answers as live dashboards.

Connects directly A read-only password, over TLS.

app.dataki.ai / chat PlanetScale · main

What were orders worth each day this past week?

Reading the schema, writing the query…
SQL 150 ms · read-only
SELECT DATE(created_at) AS day, SUM(total) AS revenue
FROM   orders
WHERE  created_at >= CURDATE() - INTERVAL 6 DAY
GROUP BY day ORDER BY day;
Order value by day 7 rows
MonTueWedThuFriSatSun $0$10K$20K$30K$40K

Saturday was the busiest day, with $31K in orders. The week came to $167K.

01Questions

What people ask PlanetScale

Each one becomes a query against PlanetScale, 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.

  • How many orders came in each day this week, and what were they worth?
  • Which merchants had the most failed payments last month?
  • What is the average time between sign-up and first order?
  • Which SKUs sold more this month than last?

02From your assistant

Ask PlanetScale from Claude, ChatGPT or Cursor

Dataki runs a hosted MCP server. Add it to your assistant once and it can read your PlanetScale schema and run read-only queries through Dataki. The assistant gets the rows back; the PlanetScale credentials stay encrypted in Dataki and never reach the model.

Setup for your assistant:

Claude · dataki (MCP) PlanetScale · main

Chart daily orders and their value for the last 14 days from PlanetScale.

  1. list_sources · finds PlanetScale · main
  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 PlanetScale

A read-only password, over TLS. 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.

app.dataki.ai/dashboards/order-value-by-day PlanetScale · main

3 views · Updated just now

Order value by day 7 rows
MonTueWedThuFriSatSun $0$10K$20K$30K$40K

One click turns the answer into a dashboard:

app.dataki.ai/dashboards/order-value-by-day

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 PlanetScale

Can I query PlanetScale in plain English instead of writing SQL?
Yes. Dataki reads your PlanetScale schema, turns a plain-English question into a query, runs it on PlanetScale and returns a chart. The query is shown with every result, so you can check or edit it.
Is there a hosted PlanetScale MCP server?
Yes, Dataki. Its remote MCP server reaches PlanetScale 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 PlanetScale data without an ETL pipeline?
Connect PlanetScale to Dataki with a read-only connection, ask your question and save the answer as a dashboard widget. Dataki queries PlanetScale 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 PlanetScale data?
Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect PlanetScale 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.