What is Xano Mcp

Xano MCP is a Model Context Protocol server designed to integrate Xano databases with Smithery, enabling Claude AI to interact with Xano databases through a standardized interface.

Use cases

Use cases for Xano MCP include managing database operations through AI, automating data workflows, enhancing data accessibility for AI applications, and facilitating seamless interactions between Claude AI and Xano databases.

How to use

To use Xano MCP, clone the repository, install the required dependencies, and run the server locally using Python. Ensure you have the necessary prerequisites such as Python 3.10 or higher, Smithery CLI, and an Xano API token.

Key features

Key features include complete Xano API integration, support for stdio and WebSocket transport methods, comprehensive database operations, file management capabilities, request history tracking, and import/export functionality.

Where to use

Xano MCP can be used in various fields where integration between AI applications and databases is required, particularly in data-driven applications, automation, and AI-driven insights.

Xano MCP Server for Smithery

A Model Context Protocol (MCP) server for integrating Xano databases with Smithery, enabling Claude AI to interact with Xano databases.

Overview

This MCP server provides a bridge between Claude AI (via Smithery) and Xano databases, allowing Claude to perform operations on Xano data through a standardized interface. The server implements the Model Context Protocol, making it compatible with Smithery’s serverless deployment model.

Features

• Complete Xano API integration
• Support for both stdio and WebSocket transport methods
• Comprehensive database operations (tables, schemas, records)
• File management capabilities
• Request history tracking
• Import/export functionality

Available Tools

The server provides the following categories of tools:

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 Index Operations

• List, create, and delete various index types (btree, unique, search, spatial, vector)

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 Operations

• Browse and search request history

Workspace Import/Export

• Export and import workspaces and schemas

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

# 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

Security Considerations

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

Configuration

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

Docker Support

You can 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

License

This project is licensed under the MIT License - see the LICENSE file for details.