datanika-mcp
The Datanika MCP server lets you interact with the Datanika data platform — browsing connections, previewing data, managing dbt transformations, monitoring runs, and orchestrating pipelines.
Read-Only Capabilities (always available)
Agent info: Retrieve the 5-tier agent capability stack description
Connection management: List all connections, get connection details by ID, and list supported connection types with their config schemas
Data exploration: Introspect schemas/tables of a connection, preview the first N rows of a table, and execute read-only SQL queries
dbt transformations: Compile a dbt transformation (resolves Jinja,
ref(),source()without executing), or compile + execute to preview result rowsUploads & pipelines: List all uploads (extract + load jobs), pipelines (dbt orchestration), and transformations
Run monitoring: List runs with filters (by type and status), get details of a specific run, and fetch run logs
Data catalog: List all catalog entries (source tables and dbt models) and get details of a specific catalog entry
Write Capabilities (require --allow-write flag)
Create resources: Create new data connections, uploads, pipelines, and dbt SQL transformations
Bulk import: Bulk-create connections, uploads, pipelines, and transformations in one call using the JSON v2 import format (validates everything before creating anything)
Trigger runs: Trigger upload, pipeline, and transformation runs — with an optional
waitflag to block until completion (up to 120s)
Provides tools for compiling, previewing, and validating dbt transformations, as well as listing and triggering dbt runs and managing dbt orchestration pipelines.
Datanika MCP Server
mcp-name: io.datanika/datanika-mcp
MCP server for Datanika — browse connections, preview data, compile and validate dbt transformations, monitor runs, and manage pipelines from Claude Desktop.
Read-only by default. Pass --allow-write to enable creating resources and triggering pipeline runs.
Install
# From PyPI (recommended)
uvx datanika-mcp --help
# From git
uvx --from "git+https://github.com/datanika-io/datanika-core#subdirectory=datanika-mcp" datanika-mcp --helpRelated MCP server: @us-all/dbt-mcp
Claude Desktop Configuration
Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows):
Read-only (recommended)
{
"mcpServers": {
"datanika": {
"command": "uvx",
"args": [
"--from", "git+https://github.com/datanika-io/datanika-core#subdirectory=datanika-mcp",
"datanika-mcp",
"--url", "https://app.datanika.io",
"--api-key", "YOUR_API_KEY"
]
}
}
}With write access
{
"mcpServers": {
"datanika": {
"command": "uvx",
"args": [
"--from", "git+https://github.com/datanika-io/datanika-core#subdirectory=datanika-mcp",
"datanika-mcp",
"--url", "https://app.datanika.io",
"--api-key", "YOUR_API_KEY",
"--allow-write"
]
}
}
}Environment variables
You can also configure via environment variables:
{
"mcpServers": {
"datanika": {
"command": "uvx",
"args": [
"--from", "git+https://github.com/datanika-io/datanika-core#subdirectory=datanika-mcp",
"datanika-mcp"
],
"env": {
"DATANIKA_URL": "https://app.datanika.io",
"DATANIKA_API_KEY": "YOUR_API_KEY",
"DATANIKA_ALLOW_WRITE": "true"
}
}
}
}Available Tools
Always available (read-only)
Tool | Description |
| Get the 5-tier agent capability stack |
| List supported connection types with config schemas |
| List all connections in the org |
| Get connection details by ID |
| List schemas/tables of a source connection |
| Preview first N rows of a table |
| Execute a read-only SQL query |
| Compile a dbt transformation (no execution) |
| Compile + execute, return preview rows |
| List all uploads |
| List all pipelines |
| List all transformations |
| List runs with optional filters |
| Get run details by ID |
| Get run logs |
| List catalog entries (source tables + dbt models) |
| Get catalog entry details |
Requires --allow-write
Tool | Description |
| Create a new data connection |
| Create a new upload (extract + load) |
| Create a new pipeline (dbt orchestration) |
| Create a new dbt SQL transformation |
| Bulk-create resources from JSON v2 format |
| Trigger an upload run |
| Trigger a pipeline run |
| Trigger a transformation run |
Self-hosted
Point --url at your instance. Use the backend port (8000) — 3000 is the
Reflex frontend and serves no /api/v1:
datanika-mcp --url http://localhost:8000 --api-key etf_your_keyReleasing (maintainers)
datanika-mcp publishes to PyPI via GitHub Actions Trusted Publishing (OIDC — no stored API token). To cut a release (from master):
Bump
versioninpyproject.toml.Tag and push — the tag version must match
pyproject.toml:git tag mcp-v0.2.0 git push origin mcp-v0.2.0The
Release datanika-mcp to PyPIworkflow builds the sdist + wheel and publishes. Verify:uvx datanika-mcp --helpresolves from PyPI.
First-release setup: a one-time PyPI trusted-publisher must be configured (project
datanika-mcp, repodatanika-io/datanika-core, workflowrelease-mcp.yml, environmentpypi) before the first tag will publish. See the infra human-locker.
License
AGPL-3.0 — same as the core Datanika platform.
Maintenance
Latest Blog Posts
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/datanika-io/datanika-core'
If you have feedback or need assistance with the MCP directory API, please join our Discord server