Dataki for Claude Code
Query your database from Claude Code
One command lets Claude Code query your real data. Dataki's hosted MCP server lets it read the schema of the databases you have connected and run read-only queries while it works, with your connection string safe in Dataki.
- Claude Code
- Dataki MCP server
- Your database, read-only
- Signs in with
- A Dataki API key.
- Works in
- Claude Code, in any terminal.
- You need
- Claude Code, and a Dataki account with at least one data source.
- Server URL
https://dataki.ai/api/mcp
01Set it up
3 steps, a couple of minutes
Prefer buttons? Dataki's connect page walks you through the same steps and creates a key wherever one is needed.
- 01
Create a key
Open the Claude Code steps on Dataki's connect page and create a key. The page fills it into the command for you.
- 02
Run this in a terminal
Terminal claude mcp add --transport http dataki https://dataki.ai/api/mcp --header "Authorization: Bearer YOUR_DATAKI_KEY" - 03
Ask it something in Claude Code
Start with
What data can you see in Dataki?.
02Ask it
What to ask in Claude Code
The assistant finds your sources, learns what the columns mean and writes the SQL. Dataki runs it read-only, and every answer shows its query.
Which tables in the billing database hold subscriptions, and how do they join to customers?
Answered from get_data_context: the tables, columns and types, plus any metric definitions and join paths your team has recorded for that source.
How many users signed up each day since Monday's release, and how does that compare with the week before?
The assistant writes the SQL and Dataki runs it read-only. The query comes back with the answer, ready to check.
Are there any orders without a matching customer? Show me the ten most recent.
A production data check in one sentence, with no SQL client to open and no connection string in your editor.
Put a chart of daily signups for the last 90 days on a dashboard called Growth.
save_dashboard turns it into a live Dataki dashboard with its own link. It refreshes on its own, and anyone you share it with can open it, no editor needed.
03What it can reach
Any source you connect to Dataki
Claude Code reaches every source your Dataki account can open, and one question can draw on several of them.
-
PostgreSQL Connects directly
-
MySQL Connects directly
-
Amazon Redshift Connects directly
-
Google BigQuery Connects directly
-
Supabase Connects directly
-
Google Sheets Connects directly
-
CSV and Excel files Connects directly
-
Neon Connects directly
-
PlanetScale Connects directly
-
Google Analytics Through BigQuery
-
Firebase Through BigQuery
-
Google Search Console Through BigQuery
-
Cloud Firestore Through BigQuery
-
Stripe Through BigQuery
-
MongoDB Through a file or BigQuery
04Worth knowing
What Claude Code gets, and what it never does
- Treat the key like a password
- It acts as you and reaches what you can reach in Dataki. Every key has daily limits on queries and bytes scanned, every query it runs is logged under its name, and you can revoke it from Dataki at any time. Keep it out of your repositories.
- No connection string on your machine
- Claude Code holds one revocable key. The database credentials stay encrypted in Dataki, and every query runs with a read-only role.
- Your app's data, kept apart from your code
- Dataki answers from the database: signups, orders, events. It never sees your code.
More on the server itself, and every tool it offers, on the MCP server page. How credentials, keys and the query log work: security and governance.
Dataki and Claude Code
- How do I connect Claude Code to a PostgreSQL database?
- Connect the database to Dataki with a read-only user, create a Dataki API key, and run: claude mcp add --transport http dataki https://dataki.ai/api/mcp --header "Authorization: Bearer YOUR_DATAKI_KEY". Claude Code can then read the schema and run read-only queries through Dataki.
- Does Claude Code get my database password?
- No. Your database credentials stay encrypted in Dataki and never reach Claude Code or any model. Claude Code calls Dataki's MCP server, Dataki runs the SQL with a read-only role, and only the results reach the conversation.
- Can Claude Code change or delete data through Dataki?
- No. Dataki is read-only end to end: any statement that changes data is refused before it runs, and the connection itself uses a role that cannot write. Claude Code can create and edit Dataki dashboards, which live in Dataki, never in your database.
- Which databases can Claude Code query through Dataki?
- Any source connected to Dataki: Google BigQuery, PostgreSQL, MySQL, Amazon Redshift, Supabase, Google Sheets and uploaded CSV or Excel files, including hosted databases such as Neon, Amazon RDS, Cloud SQL and PlanetScale. Google Analytics 4, Firebase, Search Console, Firestore and Stripe work through their exports to BigQuery. One question can draw on several sources.
Connect Claude Code. Ask it something.
Connect a source to Dataki, add the server to Claude Code, and your first answer is one question away. Anything worth keeping becomes a live dashboard with its own link.