# Dromo — how to use (mcp.ai)

Connect your Dromo account and use 8 tools for spreadsheets straight from your AI agent. Connect with your own API key. Dromo is an intuitive spreadsheet importer that integrates seamlessly with your product, enabling users to match columns, correct errors, perform complex validations, transform values, and upload perfectly formatted data.

## Option A — via MCP (recommended)
Remote MCP endpoint (HTTP, streamable): `https://api.mcp.ai/p_dromo?ms=1787295900000`
Add it as a custom/remote MCP connector in your client (Claude, Cursor, VS Code…), then authenticate when prompted. Once connected, ask the agent to use the server's tools (e.g. `dromo_create_headless_import`).

## Option B — via direct REST API
Base URL: `https://api.mcp.ai/api/dromo`
Auth: `Authorization: Bearer sk_live_…` — create a workspace API key at https://mcp.ai/settings/api-keys
Discover endpoints: `GET https://api.mcp.ai/api/dromo/_endpoints`

### Endpoints
- `POST https://api.mcp.ai/api/dromo/create/headless/import` — Tool to create a headless import in Dromo. Returns a signed upload URL for file uploads. Use this before uploading files to obtain the temporary upload URL.
  - body: { schema_id: string, initial_data?: string, original_filename?: string }
- `POST https://api.mcp.ai/api/dromo/create/import/schema` — Tool to create a new import schema in Dromo. Define fields, validation rules, and settings for data imports. Use this when setting up a new data import workflow or template.
  - body: { name: string, hooks?: object, fields: object[], settings: object }
- `POST https://api.mcp.ai/api/dromo/delete/import/schema` — Tool to delete an import schema in Dromo. Use when you need to remove a schema definition that is no longer needed. This action is irreversible.
  - body: { id: string }
- `POST https://api.mcp.ai/api/dromo/get/import/schema` — Tool to retrieve an import schema by ID from Dromo. Returns the complete schema definition including fields, validation rules, settings, and webhook configurations. Use this to inspect schema structur
  - body: { id: string }
- `POST https://api.mcp.ai/api/dromo/list/import/schemas` — Tool to retrieve all import schemas configured for your Dromo organization. Use this to discover available schemas, their field definitions, validation rules, and settings before creating imports.
- `POST https://api.mcp.ai/api/dromo/list/uploads` — Retrieves a paginated list of all file uploads stored by Dromo for your organization. Returns upload metadata including status, row counts, errors, user information, and file details. Use this to moni
  - body: { end?: integer, start?: integer }
- `POST https://api.mcp.ai/api/dromo/update/import/schema` — Tool to update an existing import schema in Dromo. Modifies the schema definition including fields, validation rules, and settings. Use when you need to change field configurations, add/remove validat
  - body: { id: string, name: string, hooks?: object, fields: object[], settings: object }
- `POST https://api.mcp.ai/api/dromo/upload/file/to/headless/import` — Upload a file to Dromo's headless import system using a presigned S3 URL. This action performs the actual file upload step in Dromo's headless import workflow: 1. First, create a headless import via P
  - body: { file: string, upload_url: string, content_type: string }

## Example prompts
- "What can I do in Dromo?"
- "Show me a summary of my Dromo account"

## More
- Page: https://mcp.ai/dromo
- Agent spec (llms.txt): https://mcp.ai/dromo/llms.txt
- Postman collection: https://mcp.ai/dromo/postman.json