How to integrate Dromo MCP with Atomic Agent

Connect Atomic Agent to Dromo MCP. List all spreadsheet uploads from this week, upload new customer data csv file, and more using natural language, with authentication handled for you.

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

Introduction

Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,500+ apps through Composio, including Dromo.

This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a Dromo account. See the Atomic Agent documentation for installation instructions.

Also integrate Dromo with

How Atomic Agent connects to Dromo

Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication.

Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account.

Connect Dromo to Atomic Agent

  1. Sign up or sign in to the Composio dashboard. Copy your API key.
  2. In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart.
  3. Ask Atomic Agent to do something in Dromo. It searches Composio for the right tool.
  4. On first use, open the sign-in link returned in the chat. Connect your Dromo account, then return to Atomic Agent to continue.

Headless setup

Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file.

bash
COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY

What is the Dromo MCP server, and what's possible with it?

The Dromo MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Dromo account. It provides structured and secure access to your spreadsheet imports and uploads, so your agent can perform actions like listing uploads, managing import sessions, handling file uploads, and automating data onboarding on your behalf.

  • Retrieve all upload sessions: Quickly ask your agent to fetch and list every spreadsheet upload in your Dromo organization for easy monitoring and management.
  • Filter and paginate uploads: Effortlessly apply filters or paginate through large numbers of uploads to find the exact import session you need.
  • Headless spreadsheet file uploads: Direct your agent to upload files to Dromo's headless import, automating the data onboarding process without manual intervention.
  • Automate validation and transformation flows: Let your agent initiate uploads that trigger Dromo's validation and transformation pipelines, ensuring data quality and consistency.

Use Dromo from Atomic Agent

With your account connected, ask Atomic Agent to work with Dromo in natural language. You can connect more apps through the same Composio integration as you need them.

Visit the Atomic Agent website or inspect the Atomic Agent source code.

Troubleshooting

Why is my API key rejected?

Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying.

Why are Composio tools unavailable after saving a key?

Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk.

Does Composio have a free plan?

The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See Composio pricing for the current limits that apply to your connection.

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.

FAQ

Frequently asked questions

With a standalone Dromo MCP server, the agents and LLMs can only access a fixed set of Dromo tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Dromo and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Atomic Agent fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Dromo tools.

Yes, absolutely. You can configure which Dromo scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Dromo data and credentials are handled as safely as possible.

Start with Dromo.It takes 30 seconds.

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

Start building