MCP Server
Erdo exposes a Model Context Protocol (MCP) server that lets AI assistants and applications query your datasets, ask data questions, manage conversations, and automate analysis — all using your existing Erdo permissions. Use it to:- Connect AI assistants like Claude Desktop, Cursor, or Windsurf to your data
- Build AI-powered apps that query and visualize your data using any MCP client library
- Integrate with any LLM via Vercel AI SDK, LangChain, or direct MCP client connections
- Automate recurring analysis with heartbeat automations
- Manage knowledge with memories and skills that persist across conversations
Quick Start
1. Get an API Key
Click your profile in the bottom-left corner of Erdo and go to API Keys. Create a new key and copy the token.2. Connect to the MCP Server
The MCP endpoint ishttps://api.erdo.ai/mcp using Streamable HTTP transport. Any MCP-compatible client can connect. The organization is inferred from your API key automatically.
- Claude Desktop
- Claude Code
- Cursor
- Custom App
Add to your
claude_desktop_config.json:3. Start Using It
Once connected, the MCP client can discover and call Erdo tools. In AI assistants, try asking:- “List my datasets in Erdo”
- “What columns does the sales dataset have?”
- “How many orders were placed last month?” (uses the Data Question Answerer agent)
- “Run a SQL query on my customers dataset to find the top 10 by revenue”
- “Create a heartbeat that checks for anomalies in my revenue data every hour”
Available Tools
Erdo exposes MCP tools across data, threads, knowledge, KV stores (the shared key/value store, a.k.a. collections), artifacts, pages, agent runs, and automations. Three Platform-API surfaces have their own dedicated pages, each with the full MCP tool, REST, and CLI reference: Evals, Workstreams, and Experiments.Data Tools
erdo_list_datasets
List all datasets in your organization with name, type, description, and status. Parameters:erdo_search_datasets
Search datasets by name or description. Parameters:erdo_get_dataset_schema
Get detailed schema for a dataset including column names, types, statistics, and sample data. Parameters:erdo_gather_dataset_context
Get detailed context for multiple datasets at once — schemas, column types, statistics, descriptions, and sample data. Useful for understanding your data landscape before asking questions. Parameters:erdo_fetch_dataset_contents
Fetch raw contents of a dataset. Returns rows and columns directly without requiring a SQL query. Useful for exploring small datasets or getting a quick preview. Parameters:erdo_run_query
Run a raw SQL query directly against a dataset and return rows and columns. Use this when you already know the exact SQL you want to run. The SQL dialect depends on the dataset’s storage backend (PostgreSQL, ClickHouse, or DuckDB for file-based datasets). Parameters:erdo_query_data
Query a dataset using natural language. Describe what data you want and Erdo will generate and execute the SQL query for you. Parameters:
Returns: The generated SQL query and the results.
erdo_ask_data_question
Ask a natural language question about your data. This invokes Erdo’s Data Question Answerer agent, which analyzes datasets, writes and executes code, and returns a text answer. To visualize results, useerdo_render_chart or erdo_render_table.
Parameters:
Returns: A thread ID (for follow-up in the Erdo UI) and the agent’s text answer.
erdo_render_chart
Render a data visualization chart. Supports bar, line, pie, histogram, and scatter chart types. The chart fetches data directly from the dataset — no embedded data needed. Parameters:erdo_render_table
Render a data table. The table fetches data directly from the dataset. Parameters:erdo_create_dataset
Create a new empty dataset. After creation, useerdo_write_rows to add data. The dataset uses your organization’s default storage backend.
Parameters:
Returns: The created dataset with
id, slug, name, type, and status.
erdo_upload_dataset_file
Upload a file (CSV, TSV, Excel, JSON, JSONL, PDF, DOCX, TXT, Markdown, …) and create a dataset from it in one call. The schema is extracted before the tool returns, so the dataset is immediately queryable. Prefer this overerdo_create_dataset + erdo_write_rows when the data already exists as a file.
Parameters:
Returns:
{ dataset_id, slug, name, ready } — ready is false when the file stored but its schema could not be extracted (not yet queryable).
erdo_delete_dataset
Delete a dataset and all its data. This is permanent. Parameters:erdo_write_rows
Write or upsert rows to a dataset. For database-backed datasets (Postgres, ClickHouse), setkey_column to upsert — matching rows are updated, new rows are inserted. For file datasets (CSV), rows are always appended.
Parameters:
Returns:
{ rows_affected: number }
erdo_delete_rows
Delete rows from a dataset. Works for both file (CSV) and database-backed datasets. Parameters:
Returns:
{ rows_affected: number }
erdo_update_dataset_schema
Update a dataset’s schema: add, remove, rename columns, or change column types. Operations are applied atomically — if any fails, none are applied. Supported for CSV file datasets only. After changes, analysis is automatically refreshed. Parameters:
Operation object:
Returns:
{ columns_added, columns_removed, columns_renamed, columns_retyped, current_columns }
Integration Tools
Connect third-party apps and data sources without leaving your AI assistant. Credential-based apps (databases, API keys, service accounts) connect in one call; OAuth apps return aconnect_url for the user to open in a browser, and erdo_check_integration_connection completes the loop.
erdo_list_integrations
List the integrations connected in your organization with app identifier, name, status, and auth type.erdo_search_integration_apps
Search apps that can be connected — native integrations (databases, warehouses, APIs) plus thousands of SaaS apps. Parameters:
Returns: each app’s identifier (pass it to
erdo_connect_integration), name, auth_types, and source (native or pipedream).
erdo_connect_integration
Connect an app. Withcredentials, credential-based apps are created, verified, and activated in this one call. Without credentials, OAuth apps return a connect_url for the user to authorize in a browser.
Parameters:
Returns:
{ app, integration_id, status, connect_url?, next_step } — status is active when connected immediately, pending when browser authorization is needed.
erdo_check_integration_connection
Check whether an app is connected. For browser-authorized apps this also completes any connection the user finished sinceerdo_connect_integration was called — poll it after the user opens the connect_url.
Parameters:
erdo_discover_integration_tables
Discover what a connected database integration exposes. Withoutschema_name, lists the selectable schemas (all SQL databases and warehouses); with it, lists that schema’s tables with columns — supported for SQL databases (Postgres, MySQL, and compatible); warehouses (BigQuery, Snowflake, ClickHouse) list schemas but not per-table columns here. Use before erdo_create_integration_dataset.
Parameters:
erdo_create_integration_dataset
Create a dataset backed by a connected database integration, so its data becomes queryable (viaerdo_run_query and erdo_query_data) without copying it. Integrations that expose schemas require a schemas selection (some allow only one); apps with no queryable data (Slack, Stripe, GitHub, …) are rejected. Table/column discovery runs in the background after creation; the dataset schema appears within seconds.
Parameters:
Returns:
{ dataset_id, slug, name, status }
Thread & Conversation Tools
erdo_list_threads
List conversation threads with name, creation date, and visibility. Parameters:erdo_get_thread_messages
Get all messages from a conversation thread including content and metadata. Parameters:erdo_create_thread
Create a new conversation thread, optionally with datasets attached. Parameters:erdo_send_message
Send a message to a thread and get an AI-generated response. The message is processed by an AI agent that can analyze data, write SQL, generate charts, and more. Parameters:
Returns: The thread ID, message ID, status, and the agent’s answer.
Knowledge Tools
Knowledge records store durable context (snippet) or reusable instructions (skill) that Erdo’s agents read in future conversations. Use these to teach the workforce your definitions, rules, and procedures.
erdo_create_knowledge
Create a new Knowledge record or skill. Parameters:erdo_search_knowledge
Search Knowledge records and skills by semantic similarity. Parameters:erdo_list_knowledge
List Knowledge records and skills with optional filtering. Parameters:erdo_delete_knowledge
Delete a Knowledge object by ID (soft delete — can be recovered). Parameters:erdo_set_knowledge_visibility
Set a Knowledge object’s visibility:workspace keeps it organization-internal (the default), public opts it into anonymous external surfaces such as the website voice widget — a draft is approved in the same step and goes live immediately. Only make non-sensitive, customer-facing facts public.
Parameters:
KV (Collection) Tools
KV stores are Erdo’s shared key/value store — named, org-level stores (also called collections) holding config and values (pricing, targets, brand tokens) that stay consistent everywhere. The same stores are read by pages (erdo.kv, aliased erdo.collections), referenced from Knowledge bodies as {{slug.key}}, and reachable from the agent runtime — one store, one source of truth. Values are any JSON type. Pages also get a private, lazily-provisioned KV store of their own; these tools operate on named stores shared across pages and knowledge.
erdo_list_kv_stores
List the organization’s named KV stores with their slug and item count. Parameters: none.erdo_get_kv_item
Read one value from a named KV store by key. Use for shared config/metrics that should be consistent everywhere rather than hardcoding values. Parameters:
Returns:
{ key, value, found }.
erdo_set_kv_item
Write one value (any JSON type) to a named KV store by key — the canonical value everything references. Requires write (EDIT) access on the store. Reference it from Knowledge prose as{{kv_slug.key}} so it stays current everywhere.
Parameters:
erdo_create_kv_store
Create a named KV store — a shared key/value store for config and values referenced across pages and knowledge. Parameters:erdo_delete_kv_item
Delete one value from a named KV store by key. Requires write (EDIT) access on the store. Deleting a key that doesn’t exist is a no-op. Parameters:Artifact Tools
Artifacts are AI-generated outputs from agent runs and automations — insights, charts, metrics, alerts, and suggestions.erdo_list_artifacts
List artifacts with optional type filtering. Parameters:erdo_get_artifact
Get full details of a specific artifact including its content, metadata, and severity. Parameters:Media Tools
erdo_screenshot
Capture a screenshot of a web page and get back a signed, time-limited download URL for the PNG, plus its dimensions. Use this when you need the image file. By default it renders a public URL (a marketing site, a published Erdo page athttps://pages.erdo.ai/p/{id}, a competitor page). Pass instructions to capture a page that requires logging in first — the capture runs asynchronously (returns a job_id with status: "processing"); poll erdo_screenshot_result with that job_id until it’s done.
Parameters:
Returns
signed_url, bucket_key, media_type, width, height, and expires_at (or job_id + status for an instructed capture — fetch the result with erdo_screenshot_result).
erdo_screenshot_result
Poll an instructed (async) capture started byerdo_screenshot. Pass the job_id it returned.
Parameters:
Returns the same shape as
erdo_screenshot once status is done (signed_url, bucket_key, media_type, dimensions, expires_at); processing means try again shortly, error includes an error message.
erdo_upload_image
Upload an image so it can be attached to a data question viaerdo_ask_data_question. Pass the raw bytes as standard base64. Accepts PNG, JPEG, WEBP, or GIF, up to 5 MB.
Parameters:
Returns
{ bucket_key, media_type, width, height } — pass bucket_key in the images array of erdo_ask_data_question.
Agent Run Tools
Agent runs are the record of what agents have done — the runs behinderdo_ask_data_question, erdo_send_message, and automations.
erdo_list_agent_runs
List agent runs, filterable by agent or thread or status. Parameters:erdo_get_agent_run
Get one agent run: status, agent, output, and trace metadata. Parameters:Approval Tools
Approval requests are actions an agent paused on, awaiting a human decision. See Approvals.erdo_list_approvals
List approval requests, filterable by status. Parameters:erdo_decide_approval
Approve or reject a pending approval request so the paused agent run can continue (or be rejected). Parameters:Page Deploy Tools
Deploy HTML pages/apps to Erdo from any coding agent. Pages run in the Erdo page runtime:window.erdo gives them governed access to the datasets you grant, and the default react-tailwind runtime provides React 18, Tailwind, and the Erdo UI components (DatasetChart, DatasetTable, …). A deploy with validation errors still saves and reports them — fix with erdo_update_page and iterate until clean.
erdo_deploy_page
Deploy a new page and get back its URL plus structured validation results. Pages are private by default. Parameters:
Returns:
{ id, title, url, public_url?, public, thread_id, validation }. url is the authenticated editor view; public_url is the visitor-facing share link (present while public). Use the returned URLs verbatim — hosts differ per environment.
dataset_slugs / kv_slugs grant read; writable_dataset_slugs / writable_kv_slugs grant write. erdo.insertRows and writes to a named KV store only work when the matching writable grant was declared at deploy — otherwise they return a permission error. The page’s own private KV store and submitEvent (pipelines) need no write grant. See Build Apps.erdo_update_page
Update a deployed page. Provided fields are merged — send onlyjs to fix a script without resending html/css. Returns fresh validation results.
Parameters:
erdo_validate_page
Dry-run validation without deploying anything: HTML structure, JS/JSX syntax and runtime smoke checks,window.erdo usage, and dataset-slug references. Real data queries are additionally probed on actual deploy/update.
Parameters: same content fields as erdo_deploy_page (html, css, js, runtime, dataset_slugs).
Automation Tools
Heartbeats are recurring agents that analyze your data on a schedule and generate insights, alerts, and reports.erdo_list_heartbeats
List heartbeat automations with their schedule, state, and latest execution status. Parameters:erdo_create_heartbeat
Create a recurring automation that analyzes your data on a schedule. Parameters:erdo_run_heartbeat
Manually trigger a heartbeat to run immediately, outside its normal schedule. Parameters:erdo_list_heartbeat_executions
List recent executions of a heartbeat with status, timing, and associated thread. Parameters:REST API
All MCP tools are also available as REST endpoints for direct HTTP integration. Use these when you don’t need the full MCP protocol (e.g. from LangChain, Vercel AI SDK, or custom scripts). Base URL:https://api.erdo.ai
Authentication: Pass Authorization: Bearer YOUR_API_KEY header. The organization is inferred from your API key.
Endpoint Reference
Data Endpoints
Integration Endpoints
Thread & Conversation Endpoints
Knowledge Endpoints
KV (Collection) Endpoints
Artifact Endpoints
Page Deploy Endpoints
Automation Endpoints
Agent Run Endpoints
Approval Endpoints
Manager Account Endpoints
Operate many client orgs from one credential — see Manager accounts.
Evals, Workstreams, and Experiments have their own REST endpoints — see Evals, Workstreams, and Experiments.
Examples
Scoped Tokens & External Users
When building your own app on top of Erdo, you’ll want your end-users to interact with Erdo without giving them full access to your organization. Scoped tokens solve this — they restrict access to specific datasets and threads that you choose. All tools work with scoped tokens. Each tool automatically scopes results to the resources the token has access to. Create scoped tokens via the TypeScript SDK usingcreateToken():
How scoping works
Scoped tokens are designed for your customers’ end-users. For your own team members, use organization API keys which have full access to all tools and org-wide visibility.
Building Apps with Erdo MCP
Beyond AI assistants, you can integrate Erdo’s MCP server into your own applications:- Vercel AI SDK — Connect any LLM to Erdo tools with rich chart and table rendering in React
- REST API (above) — Direct HTTP integration without MCP
- Any MCP client — Use the
Custom Apptab above to connect from TypeScript, Python, Go, or any language with an MCP client library

