Dromo MCP server

Connect Dromo to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

Deploy DromoBook a demo

What you can do with the Dromo MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the list uploads tool in Dromo
  • Use the delete schema tool in Dromo
  • Use the get schema tool in Dromo
  • Use the get headless import tool in Dromo
  • Use the delete headless import tool in Dromo
  • Use the create schema tool in Dromo

Supported Tools

list_uploads

List Uploads

Lists a range of completed imports (uploads) in your Dromo account. Returns status, row counts, field information, and the total upload count.

delete_schema

Delete Schema

Permanently deletes an import schema. Any imports or headless imports referencing this schema will no longer be able to use it.

get_schema

Get Schema

Retrieves full details of a specific import schema by ID, including all field definitions, validation rules, alternate matches, and settings.

get_headless_import

Get Headless Import

Retrieves the status and details of a specific headless import. If the import is successful, also fetches the pre-signed download URL for the processed data.

delete_headless_import

Delete Headless Import

Permanently deletes a headless import and all associated data. This action cannot be undone.

create_schema

Create Schema

Creates a new import schema defining the expected fields and their properties. Schemas are used to configure how data is matched, validated, and transformed during imports.

create_headless_import

Create Headless Import

Creates a new headless (server-side) import. You can either provide a filename to get a pre-signed upload URL for file upload, or provide structured JSON data directly via the `initialData` parameter.

update_schema

Update Schema

Updates an existing import schema. Replaces the schema's name, fields, and settings with the provided values.

list_headless_imports

List Headless Imports

Lists a page of headless imports in your Dromo account, including status, schema, filename, creation date, and pagination information.

delete_upload

Delete Upload

Permanently deletes an upload and all associated data. This action cannot be undone.

list_schemas

List Schemas

Lists all import schemas configured in your Dromo account. Schemas define the fields expected during data imports, including field types, labels, and validation rules.

get_upload

Get Upload

Retrieves detailed metadata for a specific upload, including filename, user info, timestamps, row count, and a download URL for the imported data.

download_upload

Download Upload Results

Downloads the processed JSON data for a completed upload. Use list_uploads to find upload IDs.

download_headless_import

Download Headless Import Results

Downloads the processed JSON data for a successful headless import. Use get_headless_import to check status.

Connect Dromo to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Dromo in Metorial. In your Metorial portal, enable the Dromo MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Dromo tools.

Run Dromo through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Dromo and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Dromo tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Dromo

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Confluence

Create, read, update, and delete pages, blog posts, comments, and attachments in Confluence spaces. Manage spaces, permissions, labels, and content restrictions. Search content using Confluence Query Language (CQL). Upload and download file attachments with versioning. Manage users, groups, and group memberships. Create and manage whiteboards, databases, folders, and templates. View and update inline tasks. Access audit logs.

Technical notes for Dromo

Import, validate, and transform spreadsheet data from CSV, Excel, TSV, and other file formats. Create and manage import schemas with custom field types and validation rules. Run headless (server-side) imports programmatically or use an embeddable widget for user-driven uploads. Retrieve cleaned import results and metadata, including row counts, filenames, and download URLs. Configure webhooks to receive notifications on import completion, review needs, or failures. Export processed data as CSV, Excel, or JSON. Apply custom data transformations and validations via hooks, and integrate with third-party services like Google Drive, OneDrive, Slack, and HubSpot.

Frequently asked questions

Common questions about connecting Dromo to AI agents with Metorial.

  1. How many tools does the Dromo MCP server have?
    The Dromo MCP server exposes 14 tools, including List Uploads, Delete Schema, Get Schema. Each one is governed and traced through Metorial.
  2. Dromo exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Dromo MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Dromo and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Dromo MCP server yourself or use the hosted gateway.

Connect Dromo to production AI agents

See how Metorial gives your team governed access to Dromo, with tracing and security controls built in.

Book a demoDeploy Dromo