How to integrate Attio MCP with OpenAI Agents SDK

Trusted by
AWS
Glean
Zoom
Airtable

30 min · no commitment · see it on your stack

Attio logo
OpenAI Agents SDK logo
divider

Introduction

This guide walks you through connecting Attio to the OpenAI Agents SDK using the Composio tool router. By the end, you'll have a working Attio agent that can add a meeting note to john smith’s record, find all companies added this week, list recent notes for acme corp through natural language commands.

This guide will help you understand how to give your OpenAI Agents SDK agent real control over a Attio account through Composio's Attio MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

Also integrate Attio with

TL;DR

Here's what you'll learn:
  • Get and set up your OpenAI and Composio API keys
  • Install the necessary dependencies
  • Initialize Composio and create a Tool Router session for Attio
  • Configure an AI agent that can use Attio as a tool
  • Run a live chat session where you can ask the agent to perform Attio operations

What is OpenAI Agents SDK?

The OpenAI Agents SDK is a lightweight framework for building AI agents that can use tools and maintain conversation state. It provides a simple interface for creating agents with hosted MCP tool support.

Key features include:

  • Hosted MCP Tools: Connect to external services through hosted MCP endpoints
  • SQLite Sessions: Persist conversation history across interactions
  • Simple API: Clean interface with Agent, Runner, and tool configuration
  • Streaming Support: Real-time response streaming for interactive applications

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

The Attio MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Attio account. It provides structured and secure access to your team’s relationship and workflow data, so your agent can perform actions like creating records, managing notes, searching your CRM, and organizing lists on your behalf.

  • Automated record management: Effortlessly create, update, or permanently delete records for people, companies, deals, and more in your Attio workspace.
  • Smart note taking and retrieval: Let your agent create, list, or delete notes attached to any record, keeping important context and meeting details organized for your team.
  • Powerful object and list navigation: Retrieve and explore all available objects or lists within your workspace, making it easy for your AI to understand and organize your CRM structure.
  • Advanced record search and filtering: Find specific CRM records either by unique ID or by searching with custom attributes, ensuring your agent surfaces the right data when you need it.
  • Comprehensive workspace insight: Get detailed information about object types and their attributes, so your AI-powered workflows always use the right fields and relationships.

Supported Tools & Triggers

Tools
Assert Company (Create or Update)Creates or updates a company record in Attio using a unique attribute to search for existing companies.
Assert Person RecordTool to create or update person records using a unique attribute to search for existing people.
Assert User Record (Create or Update)Creates or updates a user record in Attio using a unique attribute to search for existing users.
Assert Workspace (Create or Update)Creates or updates a workspace record in Attio using a unique attribute to search for existing workspaces.
Create AttributeTool to create a new attribute on an object or list in Attio.
Create CommentTool to create a new comment on a thread, record, or list entry in Attio.
Create CompanyCreates a new company record in Attio.
Create Deal RecordTool to create a new deal record in Attio.
Create ListTool to create a new list in Attio.
Create NoteThis tool creates a new note on a given record in Attio.
Create ObjectTool to create a new custom object in your Attio workspace.
Create PersonCreates a new person record in Attio.
Create RecordThis tool creates a new record in Attio for a specified object type (people, companies, deals, users, workspaces, etc.
Create Select OptionTool to add a new select option to a select or multiselect attribute in Attio.
Create StatusTool to add a new status to a status attribute on either an object or a list.
Create TaskTool to create a new task in Attio.
Create User RecordCreates a new user record in Attio.
Create WebhookTool to create a webhook and subscribe to events in Attio.
Create Workspace RecordCreates a new workspace record in Attio.
Delete CommentTool to delete a comment by its comment_id.
Delete CompanyTool to delete a company record from Attio by its record_id.
Delete DealTool to delete a deal record from Attio by its record_id.
Delete List EntryTool to delete a single list entry by its entry_id in Attio.
Delete NoteThis tool allows users to delete a specific note in Attio by its ID.
Delete PersonTool to delete a person record from Attio by its record_id.
Delete RecordThis tool allows you to delete a record from Attio permanently.
Delete TaskTool to delete a task by its task_id.
Delete UserTool to delete a user record from Attio by its record_id.
Delete WebhookTool to delete a webhook by its webhook_id.
Delete Workspace RecordTool to delete a workspace record from Attio by its record_id.
Find RecordThis tool allows users to find a record in Attio by either its unique ID or by searching using unique attributes.
Get Attribute DetailsTool to get information about a single attribute on either an object or a list.
Get CommentTool to get a single comment by its comment_id in Attio.
Get CompanyTool to get a single company record by its record_id in Attio.
Get Deal RecordTool to get a single deal record by its record_id in Attio.
Get ListTool to retrieve details of a single list in your Attio workspace.
Get List EntryTool to get a single list entry by its entry_id.
Get NoteTool to get a single note by its note_id in Attio.
Get ObjectTool to get a single object by its object_id or slug.
List Record EntriesTool to list all entries, across all lists, for which a record is the parent.
Get Current Token InfoTool to identify the current access token, the workspace it is linked to, and any permissions it has.
Get TaskTool to get a single task by its task_id in Attio.
List TasksTool to list all tasks in the workspace.
Get WebhookTool to get a single webhook by its webhook_id in Attio.
Get Workspace MemberTool to get a single workspace member by their workspace_member_id.
Get Workspace RecordTool to get a single workspace record by its record_id.
List Attribute OptionsTool to list all select options for a particular attribute on either an object or a list.
List AttributesTool to list the attribute schema for an Attio object or list (including slugs, types, select/status config) to enable correct filtering and writes.
List Attribute StatusesTool to list all statuses for a particular status attribute on either an object or a list.
List Call RecordingsTool to list all call recordings for a meeting in Attio.
List CompaniesTool to list company records in Attio with optional filtering and sorting.
List Company Attribute ValuesTool to get all values for a given attribute on a company record.
List Company Record EntriesTool to list all entries across all lists for which a company record is the parent in Attio.
List Deal EntriesTool to list all entries across all lists for which a deal record is the parent in Attio.
List Deal Record Attribute ValuesTool to retrieve all values for a specified attribute on a deal record in Attio.
List Deal RecordsTool to list deal records in Attio with the option to filter and sort results.
List List Entry Attribute ValuesTool to retrieve all values for a specified attribute on a list entry in Attio.
List ListsThis tool retrieves all lists available in the Attio workspace, sorted as they appear in the sidebar.
List MeetingsTool to list all meetings in the workspace using a deterministic sort order.
List NotesLists notes in Attio.
List ObjectsThis tool retrieves a list of all available objects (both system-defined and user-defined) in the Attio workspace via GET /v2/objects, returning key metadata including slugs and IDs for each object.
List People Attribute ValuesTool to get all values for a given attribute on a person record.
List People Record EntriesTool to list all entries across all lists for which a person record is the parent in Attio.
List Record Attribute ValuesTool to retrieve all values for a specified attribute on a record in Attio.
List RecordsThis tool lists records from a specific object type in Attio.
List ThreadsTool to list threads of comments on a record or list entry in Attio.
List User Record EntriesTool to list all entries across all lists for which a user record is the parent in Attio.
List User RecordsTool to list user records in Attio with optional filtering and sorting.
List WebhooksTool to get all webhooks in your Attio workspace.
List Workspace MembersTool to list workspace members (actors) so agents can reliably assign owners and resolve workspace-member IDs even when the optional Users standard object is disabled.
List Workspace Record Attribute ValuesTool to retrieve all values for a specified attribute on a workspace record in Attio.
List Workspace Record EntriesTool to list all entries across all lists for which a workspace record is the parent in Attio.
List Workspace RecordsTool to list workspace records with filtering and sorting options.
Patch RecordTool to update people, companies, and other records by record_id using PATCH method.
Update List Entry by Entry IDTool to update list entries by entry_id in Attio.
Get PersonTool to get a single person record by its record_id in Attio.
List Person RecordsTool to list person records from Attio with optional filtering and sorting.
Create List EntryTool to add a record to a list as a new list entry in Attio.
List List EntriesTool to list entries in a given list, with the option to filter and sort results.
List Records with QueryTool to list people, company or other records in Attio with the option to filter and sort results.
Assert List Entry by ParentTool to create or update a list entry for a given parent record in Attio.
Update List Entry by Entry ID (PUT)Tool to update list entries by entry_id in Attio using PUT method.
Assert Record (Create or Update)Tool to create or update people, companies and other records in Attio using a matching attribute.
Put Record (Overwrite)Tool to update people, companies, and other records by record_id using PUT method.
Query RecordsTool to query records for a specific Attio object using server-side filtering operators and sorting.
Search RecordsTool to fuzzy search for records across multiple objects in Attio.
Update AttributeTool to update an existing attribute by its attribute_id or slug.
Update CompanyTool to update a company record in Attio by its record_id.
Update Deal RecordTool to update an existing deal record in Attio by record ID.
Update ListTool to update an existing list in Attio.
Update ObjectTool to update a single object's configuration in Attio.
Update PersonTool to update a person record in Attio by its record_id.
Update RecordThis tool updates an existing record in Attio for a specified object type (people, companies, deals, users, workspaces, etc.
Update Select OptionTool to update an existing select option for a select or multiselect attribute in Attio.
Update StatusTool to update a status on a status attribute on either an object or a list in Attio.
Update TaskTool to update an existing task in Attio by its task_id.
Update User RecordTool to update a user record in Attio by its record_id.
Update WebhookTool to update a webhook's target URL and/or event subscriptions.
Update Workspace RecordTool to update a workspace record by ID using PATCH method.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

  1. Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
  2. Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
  3. Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Prerequisites

Before starting, make sure you have:
  • Composio API Key and OpenAI API Key
  • Primary know-how of OpenAI Agents SDK
  • A live Attio project
  • Some knowledge of Python or Typescript

Getting API Keys for OpenAI and Composio

OpenAI API Key
  • Go to the OpenAI dashboard and create an API key. You'll need credits to use the models, or you can connect to another model provider.
  • Keep the API key safe.
Composio API Key

Install dependencies

pip install composio_openai_agents openai-agents python-dotenv

Install the Composio SDK and the OpenAI Agents SDK.

Set up environment variables

bash
OPENAI_API_KEY=sk-...your-api-key
COMPOSIO_API_KEY=your-api-key
USER_ID=composio_user@gmail.com

Create a .env file and add your OpenAI and Composio API keys.

Import dependencies

import asyncio
import os
from dotenv import load_dotenv

from composio import Composio
from composio_openai_agents import OpenAIAgentsProvider
from agents import Agent, Runner, HostedMCPTool, SQLiteSession
What's happening:
  • You're importing all necessary libraries.
  • The Composio and OpenAIAgentsProvider classes are imported to connect your OpenAI agent to Composio tools like Attio.

Set up the Composio instance

load_dotenv()

api_key = os.getenv("COMPOSIO_API_KEY")
user_id = os.getenv("USER_ID")

if not api_key:
    raise RuntimeError("COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key")

# Initialize Composio
composio = Composio(api_key=api_key, provider=OpenAIAgentsProvider())
What's happening:
  • load_dotenv() loads your .env file so OPENAI_API_KEY and COMPOSIO_API_KEY are available as environment variables.
  • Creating a Composio instance using the API Key and OpenAIAgentsProvider class.

Create a Tool Router session

# Create a Attio Tool Router session
session = composio.create(
    user_id=user_id,
    toolkits=["attio"]
)

mcp_url = session.mcp.url

What is happening:

  • You give the Tool Router the user id and the toolkits you want available. Here, it is only attio.
  • The router checks the user's Attio connection and prepares the MCP endpoint.
  • The returned session.mcp.url is the MCP URL that your agent will use to access Attio.
  • This approach keeps things lightweight and lets the agent request Attio tools only when needed during the conversation.

Configure the agent

# Configure agent with MCP tool
agent = Agent(
    name="Assistant",
    model="gpt-5",
    instructions=(
        "You are a helpful assistant that can access Attio. "
        "Help users perform Attio operations through natural language."
    ),
    tools=[
        HostedMCPTool(
            tool_config={
                "type": "mcp",
                "server_label": "tool_router",
                "server_url": mcp_url,
                "headers": {"x-api-key": api_key},
                "require_approval": "never",
            }
        )
    ],
)
What's happening:
  • We're creating an Agent instance with a name, model (gpt-5), and clear instructions about its purpose.
  • The agent's instructions tell it that it can access Attio and help with queries, inserts, updates, authentication, and fetching database information.
  • The tools array includes a HostedMCPTool that connects to the MCP server URL we created earlier.
  • The headers dict includes the Composio API key for secure authentication with the MCP server.
  • require_approval: 'never' means the agent can execute Attio operations without asking for permission each time, making interactions smoother.

Start chat loop and handle conversation

print("\nComposio Tool Router session created.")

chat_session = SQLiteSession("conversation_openai_toolrouter")

print("\nChat started. Type your requests below.")
print("Commands: 'exit', 'quit', or 'q' to end\n")

async def main():
    try:
        result = await Runner.run(
            agent,
            "What can you help me with?",
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")
    except Exception as e:
        print(f"Error: {e}\n")

    while True:
        user_input = input("You: ").strip()
        if user_input.lower() in {"exit", "quit", "q"}:
            print("Goodbye!")
            break

        result = await Runner.run(
            agent,
            user_input,
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")

asyncio.run(main())
What's happening:
  • The program prints a session URL that you visit to authorize Attio.
  • After authorization, the chat begins.
  • Each message you type is processed by the agent using Runner.run().
  • The responses are printed to the console, and conversations are saved locally using SQLite.
  • Typing exit, quit, or q cleanly ends the chat.

Complete Code

Here's the complete code to get you started with Attio and OpenAI Agents SDK:

import asyncio
import os
from dotenv import load_dotenv

from composio import Composio
from composio_openai_agents import OpenAIAgentsProvider
from agents import Agent, Runner, HostedMCPTool, SQLiteSession

load_dotenv()

api_key = os.getenv("COMPOSIO_API_KEY")
user_id = os.getenv("USER_ID")

if not api_key:
    raise RuntimeError("COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key")

# Initialize Composio
composio = Composio(api_key=api_key, provider=OpenAIAgentsProvider())

# Create Tool Router session
session = composio.create(
    user_id=user_id,
    toolkits=["attio"]
)
mcp_url = session.mcp.url

# Configure agent with MCP tool
agent = Agent(
    name="Assistant",
    model="gpt-5",
    instructions=(
        "You are a helpful assistant that can access Attio. "
        "Help users perform Attio operations through natural language."
    ),
    tools=[
        HostedMCPTool(
            tool_config={
                "type": "mcp",
                "server_label": "tool_router",
                "server_url": mcp_url,
                "headers": {"x-api-key": api_key},
                "require_approval": "never",
            }
        )
    ],
)

print("\nComposio Tool Router session created.")

chat_session = SQLiteSession("conversation_openai_toolrouter")

print("\nChat started. Type your requests below.")
print("Commands: 'exit', 'quit', or 'q' to end\n")

async def main():
    try:
        result = await Runner.run(
            agent,
            "What can you help me with?",
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")
    except Exception as e:
        print(f"Error: {e}\n")

    while True:
        user_input = input("You: ").strip()
        if user_input.lower() in {"exit", "quit", "q"}:
            print("Goodbye!")
            break

        result = await Runner.run(
            agent,
            user_input,
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")

asyncio.run(main())

Conclusion

This was a starter code for integrating Attio MCP with OpenAI Agents SDK to build a functional AI agent that can interact with Attio.

Key features:

  • Hosted MCP tool integration through Composio's Tool Router
  • SQLite session persistence for conversation history
  • Simple async chat loop for interactive testing
You can extend this by adding more toolkits, implementing custom business logic, or building a web interface around the agent.

How to build Attio MCP Agent with another framework

FAQ

What are the differences in Tool Router MCP and Attio MCP?

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

Can I use Tool Router MCP with OpenAI Agents SDK?

Yes, you can. OpenAI Agents SDK 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 Attio tools.

Can I manage the permissions and scopes for Attio while using Tool Router?

Yes, absolutely. You can configure which Attio 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.

How safe is my data with Composio Tool Router?

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 Attio data and credentials are handled as safely as possible.

Used by agents from

Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai

Never worry about agent reliability

We handle tool reliability, observability, and security so you never have to second-guess an agent action.