# Dromo — MCP server on 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.

By: mcp.ai · official
Page: https://mcp.ai/dromo

## Connect (MCP protocol)
Remote MCP endpoint (HTTP, streamable): https://api.mcp.ai/p_dromo?ms=1787293620000
Add it as a custom/remote MCP connector, then authenticate when prompted.

## REST API (no MCP client required)
Every tool is also a REST endpoint, authed with a workspace API key.
Discover: GET https://api.mcp.ai/api/dromo/_endpoints   # public; lists every endpoint
Call:     POST https://api.mcp.ai/api/dromo/<endpoint>
  Authorization: Bearer sk_live_…   # create one at https://mcp.ai/settings/api-keys
  Content-Type: application/json
  Body: { …args }   →   { "ok": true, "tool": "<id>", "result": { … } }

## Developer docs
How to use (MCP or REST), markdown: https://mcp.ai/dromo/skill.md
Postman collection (v2.1): https://mcp.ai/dromo/postman.json

## Tools
- dromo_create_headless_import(schema_id: string, initial_data?: string, original_filename?: string) — 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.
- dromo_create_import_schema(name: string, hooks?: object, fields: object[], settings: object) — 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.
- dromo_delete_import_schema(id: string) — 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.
- dromo_get_import_schema(id: string) — 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
- 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.
- dromo_list_uploads(end?: integer, start?: integer) — 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
- dromo_update_import_schema(id: string, name: string, hooks?: object, fields: object[], settings: object) — 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
- dromo_upload_file_to_headless_import(file: string, upload_url: string, content_type: string) — 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

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

## Links
Docs: https://mcp.ai/docs/mcps/dromo
Website: https://mcp.ai/mcps/dromo