roboulos simple xano mcp

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.

• 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

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

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

• List instances
• Get instance details
• Check instance status

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

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

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

• List and manage files
• Upload and download

• API group management
• API endpoint creation and configuration

• 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

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

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

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

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

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

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