OData MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with OData MCP or direct API to discover metadata, list entity sets, query data, and create or update records through natural language.

OData logoOData
Basic

OData is a web protocol that exposes data via HTTP in the OData V2 format. Use it to discover service metadata and work with exposed entity sets.

7 Tools

Try OData now

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

TOOL ROUTER PLAYGROUND
OData
Try asking
TOOLS

Supported Tools

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

Create Entity

Create one entity or a bounded tree of new related entities in exactly one OData V2 POST.

Delete Entity

Delete one metadata-keyed OData V2 entity using HTTP DELETE when metadata permits it.

Get Entity

Retrieve one metadata-declared OData V2 entity by its complete typed key and optionally project selected structural properties.

Get Entity Schema

Return normalized CSDL keys, structural properties, navigation relationships, and effective restrictions for one exact entity set in the connected OData V2 service.

List Entities

Validate the connected OData V2 service and list its metadata-declared entity sets, ordered keys, and effective query and write restrictions.

Query Entities

Return exactly one bounded page from a metadata-declared OData V2 entity set using validated filtering, projection, and ordering; expansion is not supported.

Update Entity

Partially update one metadata-declared OData V2 entity through POST method tunneling with MERGE semantics.

SETUP GUIDE

Connect OData MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/openai @ai-sdk/mcp
Install the Composio SDK for Python or TypeScript
2

Initialize Client and Create Tool Router Session

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

const composio = new Composio({ apiKey: 'your-api-key' });
const session = await composio.create('your-user-id');
console.log(`Tool Router session created: ${session.mcp.url}`);
Import and initialize the Composio client, then create a Tool Router session for OData
3

Connect to AI Agent

typescript
import { openai } from '@ai-sdk/openai';
import { experimental_createMCPClient as createMCPClient } from '@ai-sdk/mcp';
import { generateText } from 'ai';

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: session.mcp.url,
    headers: {
      'x-api-key': 'your-composio-api-key',
    },
  },
});

const tools = await client.tools();
const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{
    role: 'user',
    content: 'YOUR_SPECIFIC_PROMPT_HERE'
  }],
  maxSteps: 5,
});

console.log(`Agent: ${text}`);
Use the MCP server with your AI agent (Anthropic Claude or Mastra)
SETUP GUIDE

Connect OData API Tool with your Agent

1

Install Composio

typescript
npm install @composio/openai
Install the Composio SDK
2

Initialize Composio and Create Tool Router Session

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

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');
Import and initialize Composio client, then create a Tool Router session
3

Execute OData Tools via Tool Router with Your Agent

typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'YOUR_SPECIFIC_PROMPT_HERE'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
Get tools from Tool Router session and execute OData actions with your Agent

Why Use Composio?

AI Native OData Integration

  • Supports both OData MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your OData data

Managed Auth

  • Built-in Basic Auth handling with secure credential storage and authentication
  • Central place to manage, scope, and revoke OData access
  • Per user and per environment credentials instead of hard-coded keys

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 OData
  • Scoped, least privilege access to OData 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

Start with OData.It takes 30 seconds.

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

Start building