Dromo MCP server for AI agents and assistants

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

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY
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.

Yes. Composio is SOC 2 Type II compliant and is built to keep your Dromo connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.

Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.

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

Create the key in your Dromo account settings, then paste it once on Composio's connection page. Composio stores it encrypted and uses it only for the Dromo actions your agent runs. Nobody else in your workspace can read it, and you can revoke it inside Dromo at any time.

When you connect a Dromo account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Dromo as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.

Whatever the credentials you connect allow inside Dromo. If Dromo lets you scope a key to specific permissions, create a scoped one so the agent can only do what you intend. You can revoke the key inside Dromo at any time.

Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Dromo connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.

The connection stops working the moment Dromo rejects the old key. Create a new key in Dromo and reconnect the account from the Composio dashboard or by asking your agent to reconnect Dromo. Nothing else changes.

Composio's free plan includes 100,000 tool calls per month with no credit card, which covers most personal Dromo use. Paid plans add higher limits and team features. Your Dromo plan and its API limits still apply as usual.

Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Dromo accounts).

With Composio, you connect Dromo once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.

Start with Dromo.It takes 30 seconds.

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

Start building