What is Simple Xano Mcp

simple-xano-mcp is a simplified Model Context Protocol (MCP) server designed for integration and management of Xano databases. It facilitates interactions between applications and Xano databases using the Xano Metadata API.

Use cases

Use cases for simple-xano-mcp include developing applications that need to interact with Xano databases, managing database schemas, and providing API endpoints for frontend applications to access backend data.

How to use

To use simple-xano-mcp, ensure you have Python 3.8 or higher and a valid Xano Metadata API token. Install the necessary dependencies using pip, and run the server with your Xano token using the provided command.

Key features

Key features of simple-xano-mcp include listing Xano instances, retrieving instance details, listing databases within an instance, listing tables in a database, and obtaining details about specific tables.

Where to use

simple-xano-mcp can be used in various fields that require database management and integration, particularly in applications that utilize Xano as their backend database solution.

Xano MCP Python SDK

A Python-based MCP (Model Context Protocol) server for Xano that allows AI assistants like Claude to interact directly with your Xano instance. This is a standalone version optimized for local use with Claude Desktop and other MCP-compatible LLMs.

🌟 Features

• Simple Authentication: Connect with your Xano API token
• Comprehensive API: Query and manipulate Xano instances, databases, tables, and records
• Local Deployment: Run as a local MCP server for Claude Desktop or other clients
• Detailed Logging: Troubleshoot issues with comprehensive logging
• Portable: Works on macOS, Windows, and Linux

🚀 Quick Start

1. Clone this repository:

   git clone https://github.com/yourusername/xano-mcp-python.git
   cd xano-mcp-python
   

2. Install dependencies:

   pip install -r requirements.txt
   

3. Configure Claude Desktop (if using):

   Edit your Claude Desktop config file:

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

   Add this configuration:

   {
     "mcpServers": {
       "xano": {
         "command": "python",
         "args": [
           "/path/to/xano-mcp-python/xano_mcp_sdk.py"
         ],
         "env": {
           "XANO_API_TOKEN": "your-xano-api-token"
         }
       }
     }
   }
   

4. Run the installation script:

   # On macOS/Linux
   ./install.sh
   
   # On Windows
   install.bat
   

5. Test the installation:

   ./test.py
   

💡 Usage Examples

Once installed, you can use it with Claude or any MCP-compatible assistant. Here are some examples:

• List your Xano instances:

  What Xano instances do I have?

• Check database tables:

  Show me all tables in my Xano instance “my-instance”

• Create a new table:

  Create a new table called “products” in my Xano instance “my-instance”

• Examine table structure:

  What’s the schema for the “users” table?

• Query records:

  Show me the first 5 records in the “users” table

🧰 Available Tools

Instance Management

• List instances
• Get instance details
• Check instance status

Database Operations

• List databases/workspaces
• Get workspace details
• Database schema management

Table Operations

• Create, update, delete tables
• Add, modify, and remove fields
• Index management

Record Management

• Create, read, update, delete records
• Bulk operations
• Complex queries

File Operations

• List and manage files
• Upload and download

API Tools

• API group management
• API endpoint creation and configuration

🔧 Advanced Configuration

Environment Variables

• XANO_API_TOKEN: Your Xano API token (required)
• XANO_LOG_LEVEL: Set log level (default: INFO)
• XANO_DEFAULT_INSTANCE: Default instance to use when not specified

Command Line Options

python xano_mcp_sdk.py --token YOUR_TOKEN --log-level DEBUG

Logging

Logs are written to:

• macOS: ~/Library/Logs/Claude/mcp*.log
• Windows: %APPDATA%\Claude\logs\mcp*.log

For direct console output, run:

python xano_mcp_sdk.py --console-logging

🚨 Troubleshooting

If you encounter issues:

1. Check logs for errors:

   # macOS
   tail -n 100 -f ~/Library/Logs/Claude/mcp*.log
   
   # Windows
   type "%APPDATA%\Claude\logs\mcp*.log"
   

2. Verify API token is correct and has appropriate permissions

3. Check network connectivity to Xano servers

4. Ensure Python environment is properly set up

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📄 License

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

🙏 Acknowledgements

• Xano for their excellent database platform
• Anthropic for the Model Context Protocol specification
• Contributors and testers who helped refine this SDK