Pigment MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Pigment MCP or direct API to import planning data, query workspaces, update models, and export reports through natural language.

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

Try Pigment now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Pigment
Try asking
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.

SETUP GUIDE

Connect Pigment MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["pigment"],
  mcp: true,
});
Create a session scoped to Pigment and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "List all workspaces in my Pigment account",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a Pigment request
SETUP GUIDE

Connect Pigment API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["pigment"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Pigment
3

Run Pigment tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List all workspaces in my Pigment account" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the Pigment tool calls through the session, and print the final answer

Why Use Composio?

AI Native Pigment Integration

  • Supports both Pigment MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for importing, modeling, exporting, and querying Pigment workspace data

Secure API Key Management

  • Securely store and use your Pigment API key without hard-coding it in agent logic
  • Central place to manage, scope, and revoke Pigment access
  • Per user and per environment credentials for safer deployments

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 Pigment
  • Scoped, least privilege access to Pigment workspaces and planning 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, Pigment 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 Pigment 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 Pigment account settings, then paste it once on Composio's connection page. Composio stores it encrypted and uses it only for the Pigment actions your agent runs. Nobody else in your workspace can read it, and you can revoke it inside Pigment at any time.

When you connect a Pigment account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Pigment 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 Pigment. If Pigment 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 Pigment 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 Pigment 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 Pigment rejects the old key. Create a new key in Pigment and reconnect the account from the Composio dashboard or by asking your agent to reconnect Pigment. Nothing else changes.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, which covers most personal Pigment use. Paid plans add higher limits and team features. Your Pigment 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 Pigment accounts).

With Composio, you connect Pigment 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 Pigment.It takes 30 seconds.

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

Start building