How to integrate Xata MCP with Atomic Agent

Connect Atomic Agent to Xata MCP. List all records from the customers table, insert a new order with status pending, and more using natural language, with authentication handled for you.

Xata logoXata
Api KeyOauth2

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

8 Tools

Introduction

Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,500+ apps through Composio, including Xata.

This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a Xata account. See the Atomic Agent documentation for installation instructions.

Also integrate Xata with

How Atomic Agent connects to Xata

Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication.

Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account.

Connect Xata to Atomic Agent

  1. Sign up or sign in to the Composio dashboard. Copy your API key.
  2. In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart.
  3. Ask Atomic Agent to do something in Xata. It searches Composio for the right tool.
  4. On first use, open the sign-in link returned in the chat. Connect your Xata account, then return to Atomic Agent to continue.

Headless setup

Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file.

bash
COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY

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

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

Use Xata from Atomic Agent

With your account connected, ask Atomic Agent to work with Xata in natural language. You can connect more apps through the same Composio integration as you need them.

Visit the Atomic Agent website or inspect the Atomic Agent source code.

Troubleshooting

Why is my API key rejected?

Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying.

Why are Composio tools unavailable after saving a key?

Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk.

Does Composio have a free plan?

The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See Composio pricing for the current limits that apply to your connection.

TOOLS

Supported Tools

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

Get Organization Details

Tool to retrieve detailed information about a specific organization by its ID.

Get project resource limits

Tool to retrieve the default resource limits for projects in a specified organization.

List Extensions

Tool to get available PostgreSQL extensions for a specific image.

List Available Images

Tool to retrieve a list of all available postgres images for a specified organization and region.

List Instance Types

Tool to retrieve a list of all instance types for the specified organization and region.

List Organization API Keys

Tool to retrieve a list of API keys for a specific Xata organization.

List Available Regions

Tool to retrieve a list of all regions where new branches can be deployed for the specified organization.

Update Organization

Tool to update information for an existing organization, such as its name.

FAQ

Frequently asked questions

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

Yes, you can. Atomic Agent 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 Xata tools.

Yes, absolutely. You can configure which Xata 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 Xata data and credentials are handled as safely as possible.

Start with Xata.It takes 30 seconds.

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

Start building