Xano MCP server

The Xano MCP Server for Smithery enables Claude AI to interact with Xano databases by implementing the Model Context Protocol. This server acts as a bridge allowing Claude to perform operations on Xano data through a standardized interface, making it fully compatible with Smithery's serverless deployment model.

Installation

Prerequisites

• Python 3.10 or higher
• Smithery CLI (for deployment)
• Xano API token

Local Installation

# Clone the repository
git clone https://github.com/roboulos/xano-mcp.git
cd xano-mcp

# Install dependencies
pip install -r requirements.txt

Usage

Running Locally

You can run the MCP server using different transport methods:

# Run with stdio transport (default)
python -m src.xano_mcp --token YOUR_XANO_API_TOKEN

# Run with WebSocket transport
python -m src.xano_mcp --token YOUR_XANO_API_TOKEN --transport websocket --port 8765

# Enable debug mode
python -m src.xano_mcp --token YOUR_XANO_API_TOKEN --debug

Using with Smithery

1. Deploy the MCP server to Smithery:

smithery deploy

2. Configure the server with your Xano API token in the Smithery dashboard

3. Use the server in your Smithery workflows

Configuration Options

The server can be configured using command-line arguments or environment variables:

Option	Environment Variable	Description
--token	XANO_API_TOKEN	Your Xano API token (required)
--transport	MCP_TRANSPORT	Transport method: stdio or websocket (default: stdio)
--port	MCP_PORT	Port for WebSocket server (default: 8765)
--debug	MCP_DEBUG	Enable debug mode for verbose logging

Docker Support

You can also run the server using Docker:

# Build the Docker image
docker build -t xano-mcp .

# Run with stdio transport
docker run -e XANO_API_TOKEN=YOUR_TOKEN xano-mcp

# Run with WebSocket transport
docker run -e XANO_API_TOKEN=YOUR_TOKEN -p 8765:8765 xano-mcp --transport websocket --port 8765

Available Tools

The MCP server provides several categories of tools for interacting with Xano:

Instance and Database Operations

• List Xano instances
• Get instance details
• List databases/workspaces
• Get workspace details

Table Operations

• List tables
• Get table details
• Create, update, and delete tables

Table Schema Operations

• Get and update table schemas
• Add, rename, and delete fields

Table Content Operations

• Browse and search table content
• CRUD operations on records (create, read, update, delete)
• Bulk operations for efficiency

File Operations

• List, upload, and delete files
• Get file details

Request History and Workspace Operations

• Browse and search request history
• Export and import workspaces and schemas

Security Considerations

When using the Xano MCP server, keep the following in mind:

• Store your Xano API token securely
• Use environment variables for sensitive information when possible
• Consider using access controls on your Xano database
• Remember that the MCP server has full access to your Xano database, so deploy it securely

How to install this MCP server

For Claude Code

To add this MCP server to Claude Code, run this command in your terminal:

claude mcp add-json "xano" '{"command":"python","args":["-m","src.xano_mcp","--token","YOUR_XANO_API_TOKEN"]}'

See the official Claude Code MCP documentation for more details.

For Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > Tools & Integrations and click "New MCP Server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

{
    "mcpServers": {
        "xano": {
            "command": "python",
            "args": [
                "-m",
                "src.xano_mcp",
                "--token",
                "YOUR_XANO_API_TOKEN"
            ]
        }
    }
}

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.

For Claude Desktop

To add this MCP server to Claude Desktop:

1. Find your configuration file:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json
• Linux: ~/.config/Claude/claude_desktop_config.json

2. Add this to your configuration file:

{
    "mcpServers": {
        "xano": {
            "command": "python",
            "args": [
                "-m",
                "src.xano_mcp",
                "--token",
                "YOUR_XANO_API_TOKEN"
            ]
        }
    }
}

3. Restart Claude Desktop for the changes to take effect