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/openai @ai-sdk/mcp
Install the Composio SDK and Claude Agent SDK
2

Create Tool Router Session

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

const composio = new Composio({ apiKey: 'your-api-key' });

console.log("Creating Tool Router session...");
const { mcp } = await composio.create('your-user-id');
console.log(`Tool Router session created: ${mcp.url}`);
Initialize the Composio client and create a Tool Router session
3

Connect to AI Agent

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

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: mcp.url,
    headers: { 'x-api-key': 'your-composio-api-key' }
  }
});

const tools = await client.tools();

const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{ role: 'user', content: 'List all recent spreadsheet uploads in Dromo' }],
  stopWhen: stepCountIs( 5 )
});

console.log(`Agent: ${text}`);
Use the MCP server with your AI agent
SETUP GUIDE

Connect Dromo API Tool with your Agent

1

Install Composio

typescript
npm install @composio/openai
Install the Composio SDK
2

Initialize Composio and Create Tool Router Session

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

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');
Import and initialize Composio client, then create a Tool Router session
3

Execute Dromo Tools via Tool Router with Your Agent

typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'List all spreadsheet uploads from last week'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute Dromo actions with your Agent

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