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.
What were orders worth each day this past week?
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:
Chart daily orders and their value for the last 14 days from PlanetScale.
- list_sources · finds PlanetScale · main
- 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 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.
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 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.