How to integrate Hub Planner MCP with OpenAI Agents SDK

GET STARTED FOR FREE
Framework Integration Gradient
Hub Planner Logo
open-ai-agents-sdk Logo
divider

Introduction

This guide walks you through connecting Hub Planner to the OpenAI Agents SDK using the Composio tool router. By the end, you'll have a working Hub Planner agent that can show all upcoming project bookings for my team, log 8 hours timesheet for john doe, list all unassigned resources this month through natural language commands.

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

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

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 Hub Planner
  • Configure an AI agent that can use Hub Planner as a tool
  • Run a live chat session where you can ask the agent to perform Hub Planner operations

What is open-ai-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 Hub Planner MCP server, and what's possible with it?

The Hub Planner MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Hub Planner account. It provides structured and secure access so your agent can perform Hub Planner operations on your behalf.

Supported Tools & Triggers

Tools
Add Clients to ProjectTool to add clients to a project by project ID.
Add project custom field choicesAdd choices to a project custom field template of SELECT, RADIO, or CHECKBOX type.
Add Projects to GroupTool to add projects to a project group in Hub Planner.
Add Project TagsTool to add tags to a Hub Planner project.
Add Resource Custom Field ChoicesTool to add choices to a resource custom field template of SELECT, RADIO, or CHECKBOX type.
Add Resources to ProjectTool to add resources to a project by project ID.
Add Resources to Resource GroupTool to add resources to a resource group by group ID.
Add Resource TagsTool to add tags to a resource in Hub Planner.
Create Billing RateTool to create a new billing rate in Hub Planner.
Create BookingTool to create a new booking for a resource on a project in Hub Planner.
Create Booking CategoryTool to create a new booking category in Hub Planner.
Create ClientTool to create a new client in Hub Planner.
Create Cost CategoryTool to create a new project cost category in Hub Planner.
Create EventTool to create a new event in Hub Planner.
Create HolidayTool to create a new holiday in Hub Planner.
Create MilestoneTool to create a new milestone for a project in Hub Planner.
Create ProjectTool to create a new project in Hub Planner.
Create Project Custom Field TemplateTool to create a new project custom field template in Hub Planner.
Create Project GroupTool to create a new project group in Hub Planner.
Create Project TagTool to create a new project tag in Hub Planner.
Create ResourceTool to create a new resource in Hub Planner.
Create Resource Custom Field TemplateTool to create a new resource custom field template in Hub Planner.
Create Resource TagTool to create a new resource tag in Hub Planner.
Create Time EntryTool to create a new time entry for a resource on a project in Hub Planner.
Create VacationTool to create a new vacation request for a resource in Hub Planner.
Delete Billing RateTool to delete a specific billing rate by ID in Hub Planner.
Delete BookingTool to delete a specific booking by ID in Hub Planner.
Delete BookingsTool to delete multiple bookings by IDs, resource ID, or project ID.
Delete ClientTool to delete a specific client by ID in Hub Planner.
Delete Cost CategoryTool to delete a specific project cost category by ID in Hub Planner.
Delete EventTool to delete a specific event by ID in Hub Planner.
Delete HolidayTool to delete a specific holiday by ID in Hub Planner.
Delete MilestoneTool to delete a specific milestone by ID in Hub Planner.
Delete ProjectTool to delete a specific project by ID in Hub Planner.
Delete Project Custom Field TemplateTool to delete a project custom field template by its ID.
Delete Project GroupTool to delete a specific project group by ID in Hub Planner.
Delete ProjectsTool to delete multiple projects by their IDs in a single operation.
Delete Project TagTool to delete a specific project tag by ID in Hub Planner.
Delete ResourceTool to delete a specific resource by ID.
Delete Resource Custom Field TemplateTool to delete a specific resource custom field template by ID.
Delete resourcesTool to delete multiple resources by their IDs in a single operation.
Delete Resource TagTool to delete a specific resource tag by ID in Hub Planner.
Delete Time EntriesTool to delete multiple time entries by their IDs in a single operation.
Delete Time EntryTool to delete a specific time entry by ID in Hub Planner.
Delete VacationTool to delete a specific vacation by ID in Hub Planner.
Get Billing Rate by IDTool to retrieve a specific billing rate by ID from Hub Planner.
Get Booking by IDTool to retrieve a specific booking by ID from Hub Planner.
Get Booking Category by IDTool to retrieve a specific booking category by ID from Hub Planner.
Get Client by IDTool to retrieve a specific client by ID from Hub Planner.
Get Cost CategoryTool to retrieve a specific project cost category by ID from Hub Planner.
Get Event by IDTool to retrieve a specific event by ID from Hub Planner.
Get Holiday by IDTool to retrieve a specific holiday by ID from Hub Planner.
Get MilestoneTool to retrieve a specific milestone by ID from Hub Planner.
Get ProjectTool to retrieve a specific project by ID from Hub Planner.
Get Project Custom Field TemplateTool to retrieve a specific project custom field template by ID.
Get Project Custom Field TemplatesTool to retrieve all project custom field templates defined for your Hub Planner account.
Get Project GroupTool to retrieve a specific project group by ID from Hub Planner.
Get Project TagsTool to retrieve all tags associated with a specific Hub Planner project.
Get Resource by IDTool to retrieve a specific resource by ID from Hub Planner.
Get Resource Custom Field TemplateTool to retrieve a specific resource custom field template by ID from Hub Planner.
Get Resource Custom Field TemplatesTool to retrieve custom field templates defined for resources in your Hub Planner account.
Get Resource TagsTool to retrieve all tags associated with a specific resource from Hub Planner.
Get Time Entry by IDTool to retrieve a specific time entry by ID from Hub Planner.
Get Vacation by IDTool to retrieve a specific vacation by ID from Hub Planner.
List Billing RatesTool to retrieve all billing rates from Hub Planner.
List Booking CategoriesTool to retrieve all booking categories from Hub Planner.
List BookingsTool to retrieve all bookings from Hub Planner with pagination support.
List Category GroupsTool to get all category groups from Hub Planner.
List ClientsTool to get all clients from Hub Planner.
List Cost CategoriesTool to retrieve all project cost categories from Hub Planner.
List EventsTool to retrieve all events from Hub Planner.
List HolidaysTool to retrieve all public holidays from Hub Planner.
List Project GroupsTool to get all project groups from Hub Planner.
List Project ManagersTool to get all project managers from Hub Planner.
List ProjectsTool to retrieve all projects from Hub Planner.
List Project TagsTool to retrieve all project tags from Hub Planner.
List Resource GroupsTool to get all resource groups from Hub Planner.
List ResourcesTool to get all resources from Hub Planner.
List Resource TagsTool to get all resource tags from Hub Planner.
List Time EntriesTool to get all time entries from Hub Planner.
List Unassigned WorkTool to retrieve all unassigned work from Hub Planner.
List VacationsTool to retrieve all vacations from Hub Planner.
Patch BookingTool to partially update an existing booking in Hub Planner.
Patch VacationTool to partially update an existing vacation by ID in Hub Planner.
Remove Client From ProjectsTool to remove a client from one or more projects in Hub Planner.
Remove Project From GroupsTool to remove a project from one or more project groups in Hub Planner.
Remove Project TagTool to remove a tag from a Hub Planner project.
Remove Resource from ProjectsTool to remove a resource from one or more projects in Hub Planner.
Remove Resource TagTool to remove a tag from a resource.
Search Billing RatesTool to search billing rates in Hub Planner with filters.
Search Booking CategoriesTool to search booking categories in Hub Planner with filters.
Search BookingsTool to search bookings in Hub Planner with advanced filters.
Search ClientsTool to search clients with filters in Hub Planner.
Search Cost CategoriesTool to search project cost categories in Hub Planner with filters.
Search EventsTool to search events with filters in Hub Planner.
Search HolidaysTool to search holidays with filters in Hub Planner.
Search MilestonesTool to search milestones in Hub Planner with filters.
Search Project Custom FieldsTool to search project custom field templates by type, label, or required status.
Search ProjectsTool to search projects with filters in Hub Planner.
Search Resource Custom Field TemplatesTool to search resource custom field templates by type, label, or other properties.
Search resourcesTool to search for resources with various filters in Hub Planner.
Search Time EntriesTool to search time entries with filters in Hub Planner.
Search VacationsTool to search vacations in Hub Planner with advanced filters.
Set Project ManagersTool to set project managers for a Hub Planner project.
Update Billing RateTool to update an existing billing rate by ID in Hub Planner.
Update BookingTool to update an existing booking in Hub Planner by ID.
Update Booking CategoryTool to update an existing booking category by ID in Hub Planner.
Update ClientTool to update an existing client by ID in Hub Planner.
Update Cost CategoryTool to update an existing project cost category by ID in Hub Planner.
Update EventTool to update an existing event in Hub Planner by ID.
Update HolidayTool to update an existing holiday by ID in Hub Planner.
Update MilestoneTool to update an existing milestone by ID in Hub Planner.
Update Project Custom Field TemplateTool to update an existing project custom field template in Hub Planner.
Update Project GroupTool to update an existing project group by ID in Hub Planner.
Update Hub Planner projectsTool to update one or more projects in Hub Planner.
Update Project TagTool to update an existing project tag by ID in Hub Planner.
Update Resource Custom Field TemplateTool to update an existing resource custom field template in Hub Planner.
Update Resource GroupTool to update an existing resource group by ID in Hub Planner.
Update ResourcesTool to update one or more resources in Hub Planner.
Update Resource TagTool to update an existing resource tag by ID in Hub Planner.
Update Time EntryTool to update an existing time entry by ID in Hub Planner.
Update VacationTool to update an existing vacation by ID in Hub Planner.

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

What is Tool Router?

Composio's Tool Router 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 Tool Router

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

How the Tool Router works

The Tool Router 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 Hub Planner 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 Hub Planner.

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 Hub Planner Tool Router session
session = composio.create(
    user_id=user_id,
    toolkits=["hub_planner"]
)

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 hub_planner.
  • The router checks the user's Hub Planner connection and prepares the MCP endpoint.
  • The returned session.mcp.url is the MCP URL that your agent will use to access Hub Planner.
  • This approach keeps things lightweight and lets the agent request Hub Planner 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 Hub Planner. "
        "Help users perform Hub Planner 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 Hub Planner 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 Hub Planner 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 Hub Planner.
  • 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 Hub Planner and open-ai-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=["hub_planner"]
)
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 Hub Planner. "
        "Help users perform Hub Planner 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 Hub Planner MCP with OpenAI Agents SDK to build a functional AI agent that can interact with Hub Planner.

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 Hub Planner MCP Agent with another framework

Claude Agent SDK

Claude Agent SDK

Use Hub Planner MCP with Claude Agent SDK

Google ADK

Google ADK

Use Hub Planner MCP with Google ADK

LangChain

LangChain

Use Hub Planner MCP with LangChain

Vercel AI SDK

Vercel AI SDK

Use Hub Planner MCP with Vercel AI SDK

Mastra AI

Mastra AI

Use Hub Planner MCP with Mastra AI

LlamaIndex

LlamaIndex

Use Hub Planner MCP with LlamaIndex

CrewAI

CrewAI

Use Hub Planner MCP with CrewAI

Claude Code

Claude Code

Use Hub Planner MCP with Claude Code

Codex

Codex

Use Hub Planner MCP with Codex

FAQ

What are the differences in Tool Router MCP and Hub Planner MCP?

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

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

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

Book a call↗Get started for free