Dromo MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Dromo MCP or direct API to import spreadsheets, match columns, validate data, transform values, and upload formatted datasets through natural language.

Dromo logoDromo
Api Key

Dromo is a spreadsheet importer that lets users map, validate, and transform data before upload. It helps ensure imported data is correct, structured, and ready for your application.

8 Tools

Try Dromo now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Dromo
Try asking
TOOLS

Supported Tools

Every Dromo action and event your agent gets out of the box.

Create Headless Import

Tool to create a headless import in Dromo.

Create Import Schema

Tool to create a new import schema in Dromo.

Delete Import Schema

Tool to delete an import schema in Dromo.

Get Import Schema

Tool to retrieve an import schema by ID from Dromo.

List Import Schemas

Tool to retrieve all import schemas configured for your Dromo organization.

List Uploads

Retrieves a paginated list of all file uploads stored by Dromo for your organization.

Update Import Schema

Tool to update an existing import schema in Dromo.

Upload File To Headless Import

Upload a file to Dromo's headless import system using a presigned S3 URL.

SETUP GUIDE

Connect Dromo MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["dromo"],
  mcp: true,
});
Create a session scoped to Dromo and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "List all spreadsheet uploads from last week",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a Dromo request
SETUP GUIDE

Connect Dromo API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["dromo"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Dromo
3

Run Dromo tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List all spreadsheet uploads from last week" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the Dromo tool calls through the session, and print the final answer

Why Use Composio?

AI Native Dromo Integration

  • Supports both Dromo MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Dromo data

Managed Auth

  • Built-in OAuth handling with automatic token refresh and rotation
  • Central place to manage, scope, and revoke Dromo access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Dromo
  • Scoped, least privilege access to Dromo resources
  • Full audit trail of agent actions to support review and compliance
FAQ

Frequently asked questions

Yes, Dromo requires you to configure your own API key credentials. Once set up, Composio handles secure credential storage and API request handling for you.

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

Start with Dromo.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Dromo tool your agent needs.Free to start.

Start building