Read-only-by-default MCP for Datanika: browse data, run dbt transforms, manage ELT pipelines.
Copy the AI prompt to install this server into Claude Code, Cursor, or another agent β or use 1-click editor setup below.
π‘ Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)
Open-source data pipeline platform β Extract, Load, Transform, and Orchestrate from a single UI.
Datanika combines dlt (extract + load) with dbt-core (transform) and adds visual pipeline management, scheduling, and monitoring β all in one Python-native platform.
Think Airbyte + dbt Cloud + Airflow β in one tool, self-hostable with Docker Compose.
π 36 Connectors β PostgreSQL, MySQL, Oracle, MongoDB, BigQuery, Snowflake, Stripe, HubSpot, Salesforce, Kafka, S3, and more
π dbt Transformations β SQL models, tests, snapshots, packages, and source freshness built in
π Visual Pipeline Builder β DAG editor with dependency management
β° Scheduling β Cron-based with APScheduler, persistent across restarts
π Monitoring β Run history, streaming logs, and dashboard stats
π Enterprise Security β RBAC, SSO (SAML/OIDC), audit logging, encrypted credentials
π 9 Languages β English, German, French, Spanish, Russian, Greek, Chinese, Arabic, Serbian
π REST API β Full CRUD with OpenAPI/Swagger docs, rate limiting, and scoped API keys
π€ AI-Agent Ready β hosted + local MCP server (25 tools), /llms.txt, agent-guide.md, 5-tier capability API, compile+preview validation, typed error codes, ?wait=true, Idempotency-Key, run cancellation
π Pipeline Templates β One-click starter templates (StripeβPostgres, PostgresβBigQuery, CSVβDuckDB) with prefilled connection configs
π Notifications β Slack, Telegram, email, and webhook alerts on run completion, plus an in-app notification center
π¦ Self-Hostable β Single docker compose up β no Kubernetes required
App available at http://localhost:3000
Datanika uses 0.x SemVer with tagged releases (v0.1.0, β¦). While pre-1.0, breaking
changes bump the minor. There is no 1.0 yet β that will mean a committed, stable
public API contract.
Self-hosting? Pin a release instead of tracking master. master is continuously
deployed to our hosted app and moves several times a day.
Every version's notes are on the Releases page.
Security advisories cite the first patched release (e.g. Patched: v0.1.0), so a pinned
tag tells you immediately whether you're affected.
The
datanika-mcpsub-package is versioned and released independently (mcp-v*tags, published to PyPI).
| Datanika | Airbyte | Fivetran | dbt Cloud | |
|---|---|---|---|---|
| Extract + Load | β 36 connectors | β 400+ | β 500+ | β |
| Transformations | β dbt built-in | β | β (add-on) | β |
| Scheduling | β Cron + DAG | β Basic | β Basic | β |
| Pipeline DAG | β Visual | β | β | β |
| Self-host | β Docker | β οΈ Needs K8s | β SaaS only | β SaaS only |
| Open source | β AGPL-3.0 | β οΈ ELv2 | β | β |
| Notifications | β Slack/Telegram/Email/Webhook | β | β | β |
| Pricing | Free forever | Free tier limited | ~$250+/mo | ~$100+/mo |
| Component | Technology |
|---|---|
| Frontend | Reflex (Python β React) |
| Backend | Starlette (via Reflex) |
| Extract + Load | dlt |
| Transform | dbt-core |
| Database | PostgreSQL 16 |
| Task Queue | Celery + Redis |
| Scheduling | APScheduler |
/llms.txt, agent-guide, 5-tier API, golden-path loop, ?wait=true, Idempotency-Key, run cancel, MCP server)deploy/helm/datanika/; installs the same image as the Compose path. Bundled Postgres/Redis are single-replica and not production-grade β point it at managed databases (see the chart README)Datanika speaks MCP, so AI agents (Claude Desktop, Claude Code, Cursor, β¦) can browse connections, preview data, compile transformations, and monitor runs natively. 25 tools β 17 read-only, 8 write. There are two ways in.
Hosted β nothing to install. Paste this wherever your client accepts a remote MCP server and authorize in the browser:
OAuth 2.1, no API key to handle. Read-only unless you grant write at consent β a client that asks for nothing gets read-only, and a pasted API key stays read-only here even if its own scopes allow writes.
Local β stdio. Published on PyPI as datanika-mcp and listed on the official MCP registry as io.datanika/datanika-mcp:
See datanika-mcp/README.md for per-client config snippets and the full tool list, or datanika.io/docs/mcp-server for the hosted walkthrough.
Additional agent resources:
/llms.txt β discovery document/api/v1/openapi.json β OpenAPI spec with typed inline schemas/api/v1/meta/agent-tiers β 5-tier capability stack (JSON)docs/api_versioning.md β stability tiers and deprecation policyCore platform is open-source (AGPL-3.0).
Cloud version adds billing, quotas, and usage metering via the datanika-cloud plugin.
Found a vulnerability? See SECURITY.md for our disclosure policy, supported versions, and reporting instructions.
We welcome contributors and design partners. Open an issue or contact info@datanika.io.
Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.
[](https://allmcps.com/mcp/datanika-mcp)<a href="https://allmcps.com/mcp/datanika-mcp"><img src="https://allmcps.com/api/badge/datanika-mcp?style=directory" alt="Datanika Mcp on AllMCPs" /></a>