How to integrate Pigment MCP with Atomic Agent

Connect Atomic Agent to Pigment MCP. Review actuals versus budget for q4, export monthly revenue plan from pigment, and more using natural language, with authentication handled for you.

Pigment logoPigment
Api Key

Pigment is a business planning platform for modeling, importing, and exporting workspace data. It helps teams automate planning workflows and keep business data organized.

26 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,700+ apps through Composio, including Pigment.

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 Pigment account. See the Atomic Agent documentation for installation instructions.

Also integrate Pigment with

How Atomic Agent connects to Pigment

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 Pigment 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 Pigment. It searches Composio for the right tool.
  4. On first use, open the sign-in link returned in the chat. Connect your Pigment 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 Pigment MCP server, and what's possible with it?

The Pigment MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Pigment account. It provides structured and secure access to your applications, planning blocks, views, files, imports, and data flows, so your agent can inspect workspace structure, export business data, upload files, start imports, and monitor data operations on your behalf.

  • Explore your planning workspace: Have your agent list applications, blocks, views, files, import configurations, and data flows available in Pigment.
  • Export planning data: Direct your agent to export lists, metrics, tables, or views as CSV files with the required filters, scenarios, fields, and formatting options.
  • Manage file-based imports: Let the agent upload files, push CSV data into Pigment, start Looker imports, and check import progress and results.
  • Run business data flows: Instruct your agent to trigger configured data flows and check their current status and per-step results.
  • Monitor workspace snapshots: Have your agent list scheduled, active, completed, and failed snapshots for Pigment applications.

Use Pigment from Atomic Agent

With your account connected, ask Atomic Agent to work with Pigment 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 Pigment action and event your agent gets out of the box.

Download File

Download the raw bytes of one file from a Pigment application.

Export List

Download a Pigment List as CSV through v1 with property selection, item and property filters, and formatting options.

Export List (Legacy)

Download a List as CSV through Pigment's officially published unversioned legacy endpoint with all documented filters and formatting options.

Export Metric

Download a Pigment Metric as CSV through v1 with scenarios, deprecated dimension filters, recursive filters, and formatting options.

Export Metric (Legacy)

Download a Metric as CSV through Pigment's officially published unversioned legacy endpoint with scenarios, deprecated and recursive filters, and all documented formatting options.

Export Table

Download a Pigment Table as CSV through v1 with metrics, scenarios, filters, selected fields, and formatting options.

Export Table (Legacy)

Download a Table as CSV through Pigment's officially published unversioned legacy endpoint with metrics, scenarios, filters, selected fields, and formatting options.

Export View

Download a Pigment view as CSV through the v1 endpoint, optionally choosing comma or semicolon delimiters.

Export View (Legacy)

Download a view as CSV through Pigment's officially published unversioned legacy endpoint; prefer v1 for new workflows.

Get Data Flow Status

Get the current status and per-step results of a Pigment Data Flow execution.

Get Import Status

Get v1 status for a CSV, integration, list-copy, or metric-copy import, optionally including the detailed report.

Get Import Status (Legacy)

Get CSV import status through Pigment's officially published unversioned legacy endpoint; prefer the v1 action for new workflows.

List Applications

List Pigment applications visible to the Modeling Metadata API key owner.

List Application Snapshots

List scheduled, in-progress, completed, and failed Pigment application snapshots.

List Blocks

List visible Pigment Lists, Transaction Lists, Metrics, and Tables, optionally for one application.

List Data Flows

List the Data Flows visible in one Pigment application.

List Files

Return one cursor-controlled page of file metadata for a Pigment application, newest first.

List Import Configurations

List Pigment import configurations, optionally narrowing the results by application and block.

List Views

List Pigment view metadata, optionally narrowing the results by application and block.

Push CSV Import

Upload CSV bytes to start a Pigment v1 import and return an import ID for status checks.

Push CSV Import (Legacy)

Upload CSV bytes to start an import through Pigment's officially published unversioned legacy endpoint; prefer v1 for new workflows.

Push Looker Import

Start a Pigment v1 Looker import from a saved configuration; the official contract declares no request body.

Push Looker Import (Legacy)

Start a Looker import through Pigment's officially published unversioned legacy endpoint; the documented operation has no request body.

Trigger Data Flow

Start one Pigment Data Flow execution and return its execution ID for status checks.

Trigger Import

Trigger a configured integration import, list-to-list copy, or metric-to-metric copy and return its import ID.

Upload File

Upload one file to a Pigment application and return the created file's metadata.

FAQ

Frequently asked questions

With a standalone Pigment MCP server, the agents and LLMs can only access a fixed set of Pigment tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Pigment 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 Pigment tools.

Yes, absolutely. You can configure which Pigment 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 Pigment data and credentials are handled as safely as possible.

Start with Pigment.It takes 30 seconds.

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

Start building