Datadata Skills

⌘ K

███████╗██╗  ██╗██╗██╗     ██╗     ███████╗
██╔════╝██║ ██╔╝██║██║     ██║     ██╔════╝
███████╗█████╔╝ ██║██║     ██║     ███████╗
╚════██║██╔═██╗ ██║██║     ██║     ╚════██║
███████║██║  ██╗██║███████╗███████╗███████║
╚══════╝╚═╝  ╚═╝╚═╝╚══════╝╚══════╝╚══════╝

Datadata Skills

Agent skills for the Datadata analytics platform. Reusable capabilities that give AI agents procedural knowledge to interact with Datadata through natural language.

Installation

Install all Datadata skills with a single command:

npx skills add datadata-team/datadata-skills

View package on skills.sh→

Skills

datadata-api

skill

Query Datadata via CLI — run ad-hoc SQL, inspect datasource metadata, list & describe tables, download results as NDJSON/CSV.

Query Data

Search datasources — public community search, private datasource search, username/name exact match
Metadata queries — inspect datasource info, list tables, describe column schemas
Execute SQL queries — DuckDB & ClickHouse engines, cross-source joins with DuckDB
Download results — NDJSON or CSV format
Schema scanning — trigger async scans to refresh table metadata

Ingest Data

Data Spaces table management — create tables, batch insert rows, drop tables in ducklake
Ingested data is immediately queryable via execute-adhoc

Other

User info — retrieve profile & permission list via whoami
Script generation — urllib.request examples, zero extra dependencies

Triggers:

Datadatadata explorationSQL querytable inspectionexecution results

datadata-dql

skill

Write DQL (Datadata Query Language) scripts — a Starlark-based scripting language for data transformation, cleaning, generation, and custom processing logic.

Core Capabilities

DataFrame/Series operations — transformation, cleaning, aggregation, merging, anomaly detection
SQL queries — execute SQL via query() and return DataFrame
HTTP requests — call external APIs via fetch()
2D drawing — Canvas basic graphics
Built-in modules — JSON, Time, Math, and more

Triggers:

Data transformationdata cleaningdata generationcustom data processing logic

datadata-mcp

skill

Interact with Datadata via MCP Server — search datasources, explore table structures, execute SQL, manage Data Spaces tables. Agents call MCP tools directly — no CLI or manual API Key management needed.

Core Capabilities

Search datasources — public & private search by username/keyword
Metadata queries — inspect datasource info, list tables, describe column schemas
Metadata enhancement — set table & column comments for better data understanding
Execute SQL/DQL queries — DuckDB & ClickHouse engines
Data Spaces management — create tables, batch insert rows, drop tables
Schema scanning — trigger async scans to refresh table metadata

Triggers:

Datadatadata explorationSQL querytable inspectionexecution resultsdata analysiscreate tablewrite data

MCP Server

Datadata provides a standard MCP (Model Context Protocol) endpoint. Connect directly from Claude Desktop, VS Code, Cursor, or any MCP-compatible client. Two authentication methods are supported:

https://www.datadata.com/api/mcp/v1

OAuth 2.0

recommended

Select OAuth when configuring your MCP client — your browser will redirect to Datadata for authorization. This is the most standard and convenient method. Once authorized, the agent can call all MCP tools without manually managing API Keys.

API Key

You can also authenticate via API Key — see the Authentication section below for permission configuration.

Authentication

The skill supports two ways to authenticate:

Automatic

recommended

If no API Key is configured, the datadata-api skill will automatically guide you through device authorization when you first run a command — just follow the link displayed in the terminal to complete sign-in. The key is then cached locally for 90 days.

Manual

Create an API Key in the Datadata platform with the required permissions:

Permission	Purpose
queries:execute-adhoc	Run SQL queries
executions:get	Retrieve query results
datasources:read	Read datasource metadata
datasources:scan	Trigger async schema scans
data-spaces:write	Create tables and insert data

Avatar → Settings → "API Keys" (left sidebar) → Create a new key

Select the required permissions

Set it as an environment variable:

export DATADATA_API_KEY="ak_..."