How to integrate Hub Planner MCP with OpenAI Agents SDK

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

Hub Planner logoHub Planner
Api Key

Hub Planner is a smart resource management and scheduling platform for teams. It streamlines project planning, time tracking, and reporting for global organizations.

122 Tools

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

Also integrate Hub Planner 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 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 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 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.

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

Step by step09 STEPS
1

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
2

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
3

Install dependencies

npm install @composio/openai-agents @openai/agents dotenv

Install the Composio SDK and the OpenAI Agents SDK.

4

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.

5

Import dependencies

import 'dotenv/config';
import { Composio } from '@composio/core';
import { OpenAIAgentsProvider } from '@composio/openai-agents';
import { Agent, hostedMcpTool, run, OpenAIConversationsSession } from '@openai/agents';
import * as readline from 'readline';
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.
6

Set up the Composio instance

dotenv.config();

const composioApiKey = process.env.COMPOSIO_API_KEY;
const userId = process.env.USER_ID;

if (!composioApiKey) {
  throw new Error('COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key');
}
if (!userId) {
  throw new Error('USER_ID is not set');
}

// Initialize Composio
const composio = new Composio({
  apiKey: composioApiKey,
  provider: new OpenAIAgentsProvider(),
});
What's happening:
  • dotenv.config() loads your .env file so COMPOSIO_API_KEY and USER_ID are available as environment variables.
  • Creating a Composio instance using the API Key and OpenAIAgentsProvider class.
7

Create a Tool Router session

// Create Tool Router session for Hub Planner
const session = await composio.create(userId as string, {
  toolkits: ['hub_planner'],
});
const mcpUrl = 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.
8

Configure the agent

// Configure agent with MCP tool
const agent = new 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({
      serverLabel: 'tool_router',
      serverUrl: mcpUrl,
      headers: { 'x-api-key': composioApiKey },
      requireApproval: '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 object includes the Composio API key for secure authentication with the MCP server.
  • requireApproval: 'never' means the agent can execute Hub Planner operations without asking for permission each time, making interactions smoother.
9

Start chat loop and handle conversation

// Keep conversation state across turns
const conversationSession = new OpenAIConversationsSession();

// Simple CLI
const rl = readline.createInterface({
  input: process.stdin,
  output: process.stdout,
  prompt: 'You: ',
});

console.log('\nComposio Tool Router session created.');
console.log('\nChat started. Type your requests below.');
console.log("Commands: 'exit', 'quit', or 'q' to end\n");

try {
  const first = await run(agent, 'What can you help me with?', { session: conversationSession });
  console.log(`Assistant: ${first.finalOutput}\n`);
} catch (e) {
  console.error('Error:', e instanceof Error ? e.message : e, '\n');
}

rl.prompt();

rl.on('line', async (userInput) => {
  const text = userInput.trim();

  if (['exit', 'quit', 'q'].includes(text.toLowerCase())) {
    console.log('Goodbye!');
    rl.close();
    process.exit(0);
  }

  if (!text) {
    rl.prompt();
    return;
  }

  try {
    const result = await run(agent, text, { session: conversationSession });
    console.log(`\nAssistant: ${result.finalOutput}\n`);
  } catch (e) {
    console.error('Error:', e instanceof Error ? e.message : e, '\n');
  }

  rl.prompt();
});

rl.on('close', () => {
  console.log('\n👋 Session ended.');
  process.exit(0);
});
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 run().
  • The responses are printed to the console.
  • Typing exit, quit, or q cleanly ends the chat.

Complete Code

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

import 'dotenv/config';
import { Composio } from '@composio/core';
import { OpenAIAgentsProvider } from '@composio/openai-agents';
import { Agent, hostedMcpTool, run, OpenAIConversationsSession } from '@openai/agents';
import * as readline from 'readline';

const composioApiKey = process.env.COMPOSIO_API_KEY;
const userId = process.env.USER_ID;

if (!composioApiKey) {
  throw new Error('COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key');
}
if (!userId) {
  throw new Error('USER_ID is not set');
}

// Initialize Composio
const composio = new Composio({
  apiKey: composioApiKey,
  provider: new OpenAIAgentsProvider(),
});

async function main() {
  // Create Tool Router session
  const session = await composio.create(userId as string, {
    toolkits: ['hub_planner'],
  });
  const mcpUrl = session.mcp.url;

  // Configure agent with MCP tool
  const agent = new 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({
        serverLabel: 'tool_router',
        serverUrl: mcpUrl,
        headers: { 'x-api-key': composioApiKey },
        requireApproval: 'never',
      }),
    ],
  });

  // Keep conversation state across turns
  const conversationSession = new OpenAIConversationsSession();

  // Simple CLI
  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
    prompt: 'You: ',
  });

  console.log('\nComposio Tool Router session created.');
  console.log('\nChat started. Type your requests below.');
  console.log("Commands: 'exit', 'quit', or 'q' to end\n");

  try {
    const first = await run(agent, 'What can you help me with?', { session: conversationSession });
    console.log(`Assistant: ${first.finalOutput}\n`);
  } catch (e) {
    console.error('Error:', e instanceof Error ? e.message : e, '\n');
  }

  rl.prompt();

  rl.on('line', async (userInput) => {
    const text = userInput.trim();

    if (['exit', 'quit', 'q'].includes(text.toLowerCase())) {
      console.log('Goodbye!');
      rl.close();
      process.exit(0);
    }

    if (!text) {
      rl.prompt();
      return;
    }

    try {
      const result = await run(agent, text, { session: conversationSession });
      console.log(`\nAssistant: ${result.finalOutput}\n`);
    } catch (e) {
      console.error('Error:', e instanceof Error ? e.message : e, '\n');
    }

    rl.prompt();
  });

  rl.on('close', () => {
    console.log('\nSession ended.');
    process.exit(0);
  });
}

main().catch((err) => {
  console.error('Fatal error:', err);
  process.exit(1);
});

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

Supported Tools

Every Hub Planner action and event your agent gets out of the box.

Add Clients to Project

Tool to add clients to a project by project ID.

Add project custom field choices

Add choices to a project custom field template of SELECT, RADIO, or CHECKBOX type.

Add Projects to Group

Tool to add projects to a project group in Hub Planner.

Add Project Tags

Tool to add tags to a Hub Planner project.

Add Resource Custom Field Choices

Tool to add choices to a resource custom field template of SELECT, RADIO, or CHECKBOX type.

Add Resources to Project

Tool to add resources to a project by project ID.

Add Resources to Resource Group

Tool to add resources to a resource group by group ID.

Add Resource Tags

Tool to add tags to a resource in Hub Planner.

Create Billing Rate

Tool to create a new billing rate in Hub Planner.

Create Booking

Tool to create a new booking for a resource on a project in Hub Planner.

Create Booking Category

Tool to create a new booking category in Hub Planner.

Create Client

Tool to create a new client in Hub Planner.

Create Cost Category

Tool to create a new project cost category in Hub Planner.

Create Event

Tool to create a new event in Hub Planner.

Create Holiday

Tool to create a new holiday in Hub Planner.

Create Milestone

Tool to create a new milestone for a project in Hub Planner.

Create Project

Tool to create a new project in Hub Planner.

Create Project Custom Field Template

Tool to create a new project custom field template in Hub Planner.

Create Project Group

Tool to create a new project group in Hub Planner.

Create Project Tag

Tool to create a new project tag in Hub Planner.

Create Resource

Tool to create a new resource in Hub Planner.

Create Resource Custom Field Template

Tool to create a new resource custom field template in Hub Planner.

Create Resource Tag

Tool to create a new resource tag in Hub Planner.

Create Time Entry

Tool to create a new time entry for a resource on a project in Hub Planner.

Create Vacation

Tool to create a new vacation request for a resource in Hub Planner.

Delete Billing Rate

Tool to delete a specific billing rate by ID in Hub Planner.

Delete Booking

Tool to delete a specific booking by ID in Hub Planner.

Delete Bookings

Tool to delete multiple bookings by IDs, resource ID, or project ID.

Delete Client

Tool to delete a specific client by ID in Hub Planner.

Delete Cost Category

Tool to delete a specific project cost category by ID in Hub Planner.

Delete Event

Tool to delete a specific event by ID in Hub Planner.

Delete Holiday

Tool to delete a specific holiday by ID in Hub Planner.

Delete Milestone

Tool to delete a specific milestone by ID in Hub Planner.

Delete Project

Tool to delete a specific project by ID in Hub Planner.

Delete Project Custom Field Template

Tool to delete a project custom field template by its ID.

Delete Project Group

Tool to delete a specific project group by ID in Hub Planner.

Delete Projects

Tool to delete multiple projects by their IDs in a single operation.

Delete Project Tag

Tool to delete a specific project tag by ID in Hub Planner.

Delete Resource

Tool to delete a specific resource by ID.

Delete Resource Custom Field Template

Tool to delete a specific resource custom field template by ID.

Delete resources

Tool to delete multiple resources by their IDs in a single operation.

Delete Resource Tag

Tool to delete a specific resource tag by ID in Hub Planner.

Delete Time Entries

Tool to delete multiple time entries by their IDs in a single operation.

Delete Time Entry

Tool to delete a specific time entry by ID in Hub Planner.

Delete Vacation

Tool to delete a specific vacation by ID in Hub Planner.

Get Billing Rate by ID

Tool to retrieve a specific billing rate by ID from Hub Planner.

Get Booking by ID

Tool to retrieve a specific booking by ID from Hub Planner.

Get Booking Category by ID

Tool to retrieve a specific booking category by ID from Hub Planner.

Get Client by ID

Tool to retrieve a specific client by ID from Hub Planner.

Get Cost Category

Tool to retrieve a specific project cost category by ID from Hub Planner.

Get Event by ID

Tool to retrieve a specific event by ID from Hub Planner.

Get Holiday by ID

Tool to retrieve a specific holiday by ID from Hub Planner.

Get Milestone

Tool to retrieve a specific milestone by ID from Hub Planner.

Get Project

Tool to retrieve a specific project by ID from Hub Planner.

Get Project Custom Field Template

Tool to retrieve a specific project custom field template by ID.

Get Project Custom Field Templates

Tool to retrieve all project custom field templates defined for your Hub Planner account.

Get Project Group

Tool to retrieve a specific project group by ID from Hub Planner.

Get Project Tags

Tool to retrieve all tags associated with a specific Hub Planner project.

Get Resource by ID

Tool to retrieve a specific resource by ID from Hub Planner.

Get Resource Custom Field Template

Tool to retrieve a specific resource custom field template by ID from Hub Planner.

Get Resource Custom Field Templates

Tool to retrieve custom field templates defined for resources in your Hub Planner account.

Get Resource Tags

Tool to retrieve all tags associated with a specific resource from Hub Planner.

Get Time Entry by ID

Tool to retrieve a specific time entry by ID from Hub Planner.

Get Vacation by ID

Tool to retrieve a specific vacation by ID from Hub Planner.

List Billing Rates

Tool to retrieve all billing rates from Hub Planner.

List Booking Categories

Tool to retrieve all booking categories from Hub Planner.

List Bookings

Tool to retrieve all bookings from Hub Planner with pagination support.

List Category Groups

Tool to get all category groups from Hub Planner.

List Clients

Tool to get all clients from Hub Planner.

List Cost Categories

Tool to retrieve all project cost categories from Hub Planner.

List Events

Tool to retrieve all events from Hub Planner.

List Holidays

Tool to retrieve all public holidays from Hub Planner.

List Project Groups

Tool to get all project groups from Hub Planner.

List Project Managers

Tool to get all project managers from Hub Planner.

List Projects

Tool to retrieve all projects from Hub Planner.

List Project Tags

Tool to retrieve all project tags from Hub Planner.

List Resource Groups

Tool to get all resource groups from Hub Planner.

List Resources

Tool to get all resources from Hub Planner.

List Resource Tags

Tool to get all resource tags from Hub Planner.

List Time Entries

Tool to get all time entries from Hub Planner.

List Unassigned Work

Tool to retrieve all unassigned work from Hub Planner.

List Vacations

Tool to retrieve all vacations from Hub Planner.

Patch Booking

Tool to partially update an existing booking in Hub Planner.

Patch Vacation

Tool to partially update an existing vacation by ID in Hub Planner.

Remove Client From Projects

Tool to remove a client from one or more projects in Hub Planner.

Remove Project From Groups

Tool to remove a project from one or more project groups in Hub Planner.

Remove Project Tag

Tool to remove a tag from a Hub Planner project.

Remove Resource from Projects

Tool to remove a resource from one or more projects in Hub Planner.

Remove Resource Tag

Tool to remove a tag from a resource.

Search Billing Rates

Tool to search billing rates in Hub Planner with filters.

Search Booking Categories

Tool to search booking categories in Hub Planner with filters.

Search Bookings

Tool to search bookings in Hub Planner with advanced filters.

Search Clients

Tool to search clients with filters in Hub Planner.

Search Cost Categories

Tool to search project cost categories in Hub Planner with filters.

Search Events

Tool to search events with filters in Hub Planner.

Search Holidays

Tool to search holidays with filters in Hub Planner.

Search Milestones

Tool to search milestones in Hub Planner with filters.

Search Project Custom Fields

Tool to search project custom field templates by type, label, or required status.

Search Projects

Tool to search projects with filters in Hub Planner.

Search Resource Custom Field Templates

Tool to search resource custom field templates by type, label, or other properties.

Search resources

Tool to search for resources with various filters in Hub Planner.

Search Time Entries

Tool to search time entries with filters in Hub Planner.

Search Vacations

Tool to search vacations in Hub Planner with advanced filters.

Set Project Managers

Tool to set project managers for a Hub Planner project.

Update Billing Rate

Tool to update an existing billing rate by ID in Hub Planner.

Update Booking

Tool to update an existing booking in Hub Planner by ID.

Update Booking Category

Tool to update an existing booking category by ID in Hub Planner.

Update Client

Tool to update an existing client by ID in Hub Planner.

Update Cost Category

Tool to update an existing project cost category by ID in Hub Planner.

Update Event

Tool to update an existing event in Hub Planner by ID.

Update Holiday

Tool to update an existing holiday by ID in Hub Planner.

Update Milestone

Tool to update an existing milestone by ID in Hub Planner.

Update Project Custom Field Template

Tool to update an existing project custom field template in Hub Planner.

Update Project Group

Tool to update an existing project group by ID in Hub Planner.

Update Hub Planner projects

Tool to update one or more projects in Hub Planner.

Update Project Tag

Tool to update an existing project tag by ID in Hub Planner.

Update Resource Custom Field Template

Tool to update an existing resource custom field template in Hub Planner.

Update Resource Group

Tool to update an existing resource group by ID in Hub Planner.

Update Resources

Tool to update one or more resources in Hub Planner.

Update Resource Tag

Tool to update an existing resource tag by ID in Hub Planner.

Update Time Entry

Tool to update an existing time entry by ID in Hub Planner.

Update Vacation

Tool to update an existing vacation by ID in Hub Planner.

FAQ

Frequently asked questions

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.

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.

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.

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.

Start with Hub Planner.It takes 30 seconds.

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

Start building