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.