Introducing the Xano MCP Server

The Xano MCP Server opens up a powerful new way to interact with your backend — by letting you manage your Xano data through natural conversation with your favorite AI client. Whether you're using Claude, Cursor, or Windsurf, the MCP Server lets you programmatically control your Xano workspace without clicking through the UI. Here's how to get started and what you can do with it today.

Creating Database Tables with Claude

Instead of manually adding tables one by one inside Xano, you can describe your application to Claude and let it build your schema for you. Once Claude is connected to the Xano MCP Server, you can ask it to list your available workspaces, then instruct it to create specific tables in the workspace of your choice.

For example, you can prompt Claude with something like: "I'm building a social media app similar to Instagram — create the basic tables I need." Claude will generate a full database schema, including tables for users, posts, likes, follows, and comments, and create them directly in your Xano workspace in real time. This conversational approach lets you refine the schema through dialogue rather than starting from scratch.

Generating Realistic Sample Data

Once your tables are in place, you can ask Claude to populate them with sample data. While Xano includes a built-in "generate records" feature, using AI to create sample data gives you much more contextually accurate results — records that actually make sense together across related tables. Claude will create sample users, posts, follows, likes, and comments that reflect realistic relationships between your data, giving you a much more useful starting point for development and testing.

Connecting the Xano MCP Server

To set up the MCP Server, navigate to your instance settings in Xano and select Metadata API and MCP Server. From there, you'll find connection options for either SSE or streaming, depending on what your client supports. You'll also need to generate an access token — head to Manage Access Tokens, create a new token with the appropriate permissions and expiry, and copy it immediately since Xano only displays it once.

For Claude specifically, go to Settings > Developer > Edit Config to open your Claude desktop config file. Add your Xano MCP Server connection URL and authorization token using the sample format provided in the Xano documentation. The setup process is similar across most MCP-compatible clients.

Analyzing Request History Through Conversation

One of the most compelling features available right now is the ability to query your API request history using natural language. You can ask Claude things like "How many requests were sent to my API 1 endpoint in the last hour?" or "How many requests hit API 2 in the last 24 hours?" — and Claude will analyze the data and return clear, actionable answers, including request IDs and pattern insights.

This conversational awareness of what's happening across your workspace is a meaningful step forward for backend monitoring and debugging without leaving your AI client.

Xano will continue adding new tools to the MCP Server in future releases, so expect these capabilities to grow significantly over time.