# Xata

```json
{
  "name": "Xata",
  "slug": "xata",
  "url": "https://composio.dev/toolkits/xata",
  "markdown_url": "https://composio.dev/toolkits/xata.md",
  "logo_url": "https://logos.composio.dev/api/xata",
  "categories": [
    "developer tools & devops",
    "data & analytics",
    "productivity & project management"
  ],
  "is_composio_managed": false,
  "updated_at": "2026-03-29T06:55:54.468Z"
}
```

![Xata logo](https://logos.composio.dev/api/xata)

## Description

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Xata MCP or direct API to read, write, query, and search data through natural language.

## Summary

Xata is a serverless, scalable, branchable cloud database platform. It streamlines modern app development with hassle-free, developer-focused data management.

## Categories

- developer tools & devops
- data & analytics
- productivity & project management

## Toolkit Details

- Tools: 8

## Images

- Logo: https://logos.composio.dev/api/xata

## Authentication

- **Api Key**
  - Type: `api_key`
  - Description: Api Key authentication for Xata.
  - Setup:
    - Configure Api Key credentials for Xata.
    - Use the credentials when creating an auth config in Composio.
- **Oauth2**
  - Type: `oauth2`
  - Description: Oauth2 authentication for Xata.
  - Setup:
    - Configure Oauth2 credentials for Xata.
    - Use the credentials when creating an auth config in Composio.

## Suggested Prompts

- List all records from the customers table.
- Insert a new order with status pending.
- Update the email field for customer 101.

## Supported Tools

| Tool slug | Name | Description |
|---|---|---|
| `XATA_GET_ORGANIZATION` | Get Organization Details | Tool to retrieve detailed information about a specific organization by its ID. Use when you need to check organization status, name, billing information, or admin settings. |
| `XATA_GET_PROJECT_LIMITS` | Get project resource limits | Tool to retrieve the default resource limits for projects in a specified organization. Use when you need to check maximum instances, storage, allowed regions, or branch limits for a Xata organization. |
| `XATA_LIST_EXTENSIONS` | List Extensions | Tool to get available PostgreSQL extensions for a specific image. Use when you need to check which extensions can be enabled for a particular PostgreSQL version in an organization. |
| `XATA_LIST_IMAGES` | List Available Images | Tool to retrieve a list of all available postgres images for a specified organization and region. Use when you need to check which database images are available for deployment. |
| `XATA_LIST_INSTANCE_TYPES` | List Instance Types | Tool to retrieve a list of all instance types for the specified organization and region. Use when you need to check available instance types and their configurations including CPU, RAM, and pricing. |
| `XATA_LIST_ORGANIZATION_API_KEYS` | List Organization API Keys | Tool to retrieve a list of API keys for a specific Xata organization. Use when you need to view all API keys associated with an organization. |
| `XATA_LIST_AVAILABLE_REGIONS` | List Available Regions | Tool to retrieve a list of all regions where new branches can be deployed for the specified organization. Use when you need to check which regions are available for deploying new branches. |
| `XATA_UPDATE_ORGANIZATION` | Update Organization | Tool to update information for an existing organization, such as its name. Use when you need to modify organization details. |

## Supported Triggers

None listed.

## Installation and MCP Setup

### Path 1: SDK Installation

#### Path 1, Step 1: Install Composio

Install the Composio SDK
```python
pip install composio_openai
```

```typescript
npm install @composio/openai
```

#### Path 1, Step 2: Initialize Composio and Create Tool Router Session

Import and initialize Composio client, then create a Tool Router session
```python
from openai import OpenAI
from composio import Composio
from composio_openai import OpenAIResponsesProvider

composio = Composio(provider=OpenAIResponsesProvider())
openai = OpenAI()
session = composio.create(user_id='your-user-id')
```

```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');
```

#### Path 1, Step 3: Execute Xata Tools via Tool Router with Your Agent

Get tools from Tool Router session and execute Xata actions with your Agent
```python
tools = session.tools
response = openai.responses.create(
  model='gpt-4.1',
  tools=tools,
  input=[{
    'role': 'user',
    'content': 'List all records from the customers table in Xata.'
  }]
)
result = composio.provider.handle_tool_calls(
  response=response,
  user_id='your-user-id'
)
print(result)
```

```typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'List all records from the customers table in Xata.'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
```

### Path 2: MCP Server Setup

#### Path 2, Step 1: Install Composio

Install the Composio SDK for Python or TypeScript
```python
pip install composio claude-agent-sdk
```

```typescript
npm install @composio/core ai @ai-sdk/openai @ai-sdk/mcp
```

#### Path 2, Step 2: Initialize Client and Create Tool Router Session

Import and initialize the Composio client, then create a Tool Router session for Xata
```python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
```

```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}`);
```

#### Path 2, Step 3: Connect to AI Agent

Use the MCP server with your AI agent (Anthropic Claude or Mastra)
```python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Xata tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('Insert a new record into the orders table with customer_id 1234 and status shipped.')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
```

```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: 'Insert a new record into the orders table with customer_id 1234 and status shipped.'
  }],
  maxSteps: 5,
});

console.log(`Agent: ${text}`);
```

## Why Use Composio?

### 1. AI Native Xata Integration

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

### 2. Managed Auth

- Built-in OAuth handling with automatic token refresh and rotation
- Central place to manage, scope, and revoke Xata access
- Per user and per environment credentials instead of hard-coded keys

### 3. 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

### 4. Enterprise Grade Security

- Fine-grained RBAC so you control which agents and users can access Xata
- Scoped, least privilege access to Xata resources
- Full audit trail of agent actions to support review and compliance

## Use Xata with any AI Agent Framework

Choose a framework you want to connect Xata with:

- [OpenAI Agents SDK](https://composio.dev/toolkits/xata/framework/open-ai-agents-sdk)
- [Claude Agent SDK](https://composio.dev/toolkits/xata/framework/claude-agents-sdk)
- [Claude Code](https://composio.dev/toolkits/xata/framework/claude-code)
- [Claude Cowork](https://composio.dev/toolkits/xata/framework/claude-cowork)
- [Codex](https://composio.dev/toolkits/xata/framework/codex)
- [OpenClaw](https://composio.dev/toolkits/xata/framework/openclaw)
- [Hermes](https://composio.dev/toolkits/xata/framework/hermes-agent)
- [Google ADK](https://composio.dev/toolkits/xata/framework/google-adk)
- [LangChain](https://composio.dev/toolkits/xata/framework/langchain)
- [Vercel AI SDK](https://composio.dev/toolkits/xata/framework/ai-sdk)
- [Mastra AI](https://composio.dev/toolkits/xata/framework/mastra-ai)
- [LlamaIndex](https://composio.dev/toolkits/xata/framework/llama-index)
- [CrewAI](https://composio.dev/toolkits/xata/framework/crew-ai)
- [Pydantic AI](https://composio.dev/toolkits/xata/framework/pydantic-ai)
- [AutoGen](https://composio.dev/toolkits/xata/framework/autogen)

## Related Toolkits

- [Google Sheets](https://composio.dev/toolkits/googlesheets) - Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.
- [Supabase](https://composio.dev/toolkits/supabase) - Supabase is an open-source backend platform offering scalable Postgres databases, authentication, storage, and real-time APIs. It lets developers build modern apps without managing infrastructure.
- [Notion](https://composio.dev/toolkits/notion) - Notion is a collaborative workspace for notes, docs, wikis, and tasks. It streamlines team knowledge, project tracking, and workflow customization in one place.
- [Airtable](https://composio.dev/toolkits/airtable) - Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.
- [Codeinterpreter](https://composio.dev/toolkits/codeinterpreter) - Codeinterpreter is a Python-based coding environment with built-in data analysis and visualization. It lets you instantly run scripts, plot results, and prototype solutions inside supported platforms.
- [Asana](https://composio.dev/toolkits/asana) - Asana is a collaborative work management platform for teams to organize and track projects. It streamlines teamwork, boosts productivity, and keeps everyone aligned on goals.
- [Google Tasks](https://composio.dev/toolkits/googletasks) - Google Tasks is a to-do list and task management tool integrated into Gmail and Google Calendar. It helps you organize, track, and complete tasks across your Google ecosystem.
- [Linear](https://composio.dev/toolkits/linear) - Linear is a modern issue tracking and project planning tool for fast-moving teams. It helps streamline workflows, organize projects, and boost productivity.
- [GitHub](https://composio.dev/toolkits/github) - GitHub is a code hosting platform for version control and collaborative software development. It streamlines project management, code review, and team workflows in one place.
- [Jira](https://composio.dev/toolkits/jira) - Jira is Atlassian’s platform for bug tracking, issue tracking, and agile project management. It helps teams organize work, prioritize tasks, and deliver projects efficiently.
- [Clickup](https://composio.dev/toolkits/clickup) - ClickUp is an all-in-one productivity platform for managing tasks, docs, goals, and team collaboration. It streamlines project workflows so teams can work smarter and stay organized in one place.
- [Excel](https://composio.dev/toolkits/excel) - Microsoft Excel is a robust spreadsheet application for organizing, analyzing, and visualizing data. It's the go-to tool for calculations, reporting, and flexible data management.
- [Monday](https://composio.dev/toolkits/monday) - Monday.com is a customizable work management platform for project planning and collaboration. It helps teams organize tasks, automate workflows, and track progress in real time.
- [21risk](https://composio.dev/toolkits/_21risk) - 21RISK is a web app built for easy checklist, audit, and compliance management. It streamlines risk processes so teams can focus on what matters.
- [Ably](https://composio.dev/toolkits/ably) - Ably is a real-time messaging platform for live chat and data sync in modern apps. It offers global scale and rock-solid reliability for seamless, instant experiences.
- [Abstract](https://composio.dev/toolkits/abstract) - Abstract provides a suite of APIs for automating data validation and enrichment tasks. It helps developers streamline workflows and ensure data quality with minimal effort.
- [Abuselpdb](https://composio.dev/toolkits/abuselpdb) - Abuselpdb is a central database for reporting and checking IPs linked to malicious online activity. Use it to quickly identify and report suspicious or abusive IP addresses.
- [Addressfinder](https://composio.dev/toolkits/addressfinder) - Addressfinder is a data quality platform for verifying addresses, emails, and phone numbers. It helps you ensure accurate customer and contact data every time.
- [Agentql](https://composio.dev/toolkits/agentql) - Agentql is a toolkit that connects AI agents to the web using a specialized query language. It enables structured web interaction and data extraction for smarter automations.
- [Agenty](https://composio.dev/toolkits/agenty) - Agenty is a web scraping and automation platform for extracting data and automating browser tasks—no coding needed. It streamlines data collection, monitoring, and repetitive online actions.

## Frequently Asked Questions

### Do I need my own developer credentials to use Xata with Composio?

Yes, Xata requires you to configure your own API key credentials. Once set up, Composio handles secure credential storage and API request handling for you.

### Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. [Learn more](https://docs.composio.dev/tool-router/overview).

### Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. [Learn more](https://trust.composio.dev).

### What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

---
[See all toolkits](https://composio.dev/toolkits) · [Composio docs](https://docs.composio.dev/llms.txt)