Dataki for VS Code

Query your database from VS Code

Let Copilot Chat in VS Code query your real data while you code. Dataki's hosted MCP server lets agent mode read the schema and run read-only queries on the databases you have connected, with your database credentials safe in Dataki.

  1. VS Code
  2. Dataki MCP server
  3. Your database, read-only
Signs in with
A Dataki API key, created for you when you click install.
Works in
Copilot Chat in VS Code, in agent mode.
You need
VS Code with GitHub Copilot Chat, and a Dataki account with at least one data source.
Server URL
https://dataki.ai/api/mcp
Connect VS Code See the steps

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.

  1. 01

    Add Dataki to VS Code from the connect page

    Open the VS Code steps on Dataki's connect page and click Add to VS Code. It creates a key and opens VS Code with Dataki ready to install. The server goes into your own VS Code profile, outside any repository.

  2. 02

    In VS Code, click Install

  3. 03

    Ask it something in Copilot Chat, in agent mode

    Start with What data can you see in Dataki?.

Add it to a workspace by hand

Put this in .vscode/mcp.json. The file lives in your repository, so the key stays out of it: VS Code asks for the key the first time it connects and keeps it in its own secret storage.

.vscode/mcp.json 
{
  "servers": {
    "dataki": {
      "type": "http",
      "url": "https://dataki.ai/api/mcp",
      "headers": {
        "Authorization": "Bearer ${input:dataki_key}"
      }
    }
  },
  "inputs": [
    {
      "type": "promptString",
      "id": "dataki_key",
      "description": "Dataki API key",
      "password": true
    }
  ]
}

02Ask it

What to ask in Copilot Chat, in agent mode

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

VS Code reaches every source your Dataki account can open, and one question can draw on several of them.

04Worth knowing

What VS 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 in your config
VS Code holds one revocable key in its secret storage. 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 VS Code

How do I add a database MCP server to VS Code?
Connect the database to Dataki with a read-only user, then add Dataki's hosted MCP server to VS Code: one click on Dataki's connect page, or a .vscode/mcp.json entry that prompts for the key. Ask in Copilot Chat in agent mode.
Does VS Code get my database password?
No. Your database credentials stay encrypted in Dataki and never reach VS Code or any model. VS Code calls Dataki's MCP server, Dataki runs the SQL with a read-only role, and only the results reach the conversation.
Can Copilot 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. Copilot can create and edit Dataki dashboards, which live in Dataki, never in your database.
Which databases can VS 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.

Using another assistant?

Connect VS Code. Ask it something.

Connect a source to Dataki, add the server to VS Code, and your first answer is one question away. Anything worth keeping becomes a live dashboard with its own link.

Connect VS Code Talk to us