SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

How to integrate Pigment MCP with Hermes

Connect Hermes 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.

Get started for freeGet a demo
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

Hermes is a 24/7 autonomous agent that lives on your computer or server — it remembers what it learns and evolves as your usage grows.

This guide explains the easiest and most robust way to connect your Pigment account to Hermes. You can do this through either Composio Connect CLI or Composio Connect MCP. For personal use we recommend the CLI, but you won't go wrong with MCP either.

Also integrate Pigment with

ChatGPTClaude CoworkAtomic Agent

What is Composio Connect?

Composio Connect is a consumer offering that lets anyone plug 1,700+ applications directly into their agent harness — including Hermes. It can:

  • Search and load tools from relevant toolkits on-demand, reducing context usage.
  • Chain multiple tools to accomplish complex workflows via a remote workbench, without excessive back-and-forth with the LLM.
  • Manage app authentication end-to-end with zero manual overhead.

Integrating Pigment with Hermes

Using Composio Connect CLI

1. Install the Composio CLI

Run the install script directly, or paste https://composio.dev/hermes into your Hermes chat box to have it installed for you.

bash
curl -fsSL https://composio.dev/install | bash
Hermes authenticating with Composio

2. Authenticate

Once the CLI is installed, ask Hermes to authenticate with Composio.

3. Connect to Pigment

Ask your agent to connect to Pigment, or simply request any Pigment-related task. Hermes will prompt you to authenticate and authorize access.

4. Done. You're all set with a new Pigment connection.

Using Composio Connect MCP

1. Get your MCP URL and API Key

Go to dashboard.composio.dev and copy your Connect MCP URL and API key.

Copy MCP URL and API key from Composio dashboard

2. Open the Hermes config file

bash
nano ~/.hermes/config.yaml

3. Add the Composio Connect MCP server

bash
mcp_servers:
  composio:
    url: "https://connect.composio.dev/mcp"
    headers:
      x-consumer-api-key: "YOUR_COMPOSIO_API_KEY"
    connect_timeout: 60
    timeout: 180

Save with Ctrl + O, Enter, then exit with Ctrl + X.

4. Restart your Hermes agent

Once restarted, ask your agent to connect to Pigment or request any Pigment-related task. It will prompt you to authenticate and authorize access.

5. Done!

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.

Way Forward

With Pigment connected, Hermes can now act on your behalf whenever it detects a relevant task or you ask it to.

From here, you can extend Hermes further:

  • Connect more apps: Calendar, Slack, Notion, Linear, and hundreds of others are available through the same Composio Connect setup. Each new integration compounds what Hermes can do for you.
  • Build workflows across tools: Once multiple apps are connected, Hermes can chain actions together — turn an email into a calendar invite, a Slack message into a Linear ticket, or a meeting note into a follow-up draft.
  • Let it learn your patterns: The more you use Hermes, the better it gets at anticipating how you'd handle recurring tasks. Give it feedback on drafts and decisions, and it will adapt.

If you run into trouble or want to share what you've built, join the community or check out the Docs for deeper configuration options.

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.

FRAMEWORKS

How to build Pigment MCP Agent with another framework

ChatGPT logo

ChatGPT

Use Pigment MCP with ChatGPT

Claude Cowork logo

Claude Cowork

Use Pigment MCP with Claude Cowork

Atomic Agent logo

Atomic Agent

Use Pigment MCP with Atomic Agent

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. Hermes 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