xano mcp

A Model Context Protocol (MCP) server for interacting with Xano's metadata API. This server provides tools that can be used by AI assistants (like Claude) through Cursor or other MCP-compatible clients.

Features

• Manage Tables: Create, list, and delete tables in your Xano database
• Schema Operations: View and modify table schemas with comprehensive schema editing capabilities
• Database Management: Complete toolset for interacting with your Xano database structure
• Swagger Spec: Extract your API group api details in either JSON or Markdown (reduced token) format

Note this is an early-stage with feedback / requests welcomed.

Prerequisites

• Node.js (v16 or higher)
• npm or another Node.js package manager
• A Xano account with API access
• Cursor, Claude Desktop, Cline or another MCP client.

Installation

1. Clone the repository:

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

2. Install dependencies:

   npm install

3. Configure your Xano credentials:

4. Edit index.ts and set your Xano credentials:

   • XANO_API_KEY: Your Xano API key
   • XANO_WORKSPACE: Your Xano workspace ID
   • XANO_API_BASE: Your Xano instance API URL (e.g., https://your-instance.xano.io/api:meta)

5. Build the project:

   npm run build

Usage with Claude Desktop

Follow this guide - https://modelcontextprotocol.io/quickstart/user

Update your config with:

{
  "mcpServers": {
    "xano": {
      "command": "node",
      "args": [
        "/path/to/xano-mcp"
      ]
    }
  }
} 

Replace /path/to/xano-mcp with the absolute path to your project directory.

This does not work with the claude web app, only via the desktop app - https://claude.ai/download

Usage with Cursor

1. Open Cursor
2. Click "Add MCP Server"
3. Configure the server:
4. Name: whatever you want to call it
5. Type: command
6. Command: node /path/to/xano-mcp/build/index.js

Replace /path/to/xano-mcp with the absolute path to your project directory.

Example mac
node /Users/your-user/Documents/folder-name/xano-mcp/build/index.js

If you're in your're inside your directory you can run the comman 'pwd' into your terminal to get the absolute path.

Xano MCP Tools Overview

This integration provides a comprehensive set of tools for managing your Xano workspace through the Model Context Protocol (MCP). Here's what you can do:

Database Management

Tables

• List all tables in your workspace
• View detailed table schemas
• Create new tables with custom schemas
• Delete existing tables
• Modify table schemas (add/remove/rename columns)

Schema Operations

• Add new columns with various data types
• Remove columns
• Rename columns
• Update entire table schemas
• Support for complex data types and relationships

API Management

API Groups

• Create new API groups
• List all API groups
• Browse APIs within groups
• Enable/disable Swagger documentation
• Manage API group metadata (tags, branches, etc.)

Individual APIs

• Add new APIs to groups
• Configure HTTP methods (GET, POST, PUT, DELETE, PATCH, HEAD)
• Set up API documentation
• Add metadata (tags, descriptions)

Documentation

• Generate API Group specifications in both markdown (reduced tokens) and JSO (full) formats
• View Swagger documentation
• Access detailed schema information

This toolset enables complete management of your Xano workspace, allowing you to build and maintain your backend infrastructure programmatically through the MCP interface.

Re-enabling the Delete Table Tool

To re-enable the delete-table functionality in this codebase, follow these step-by-step instructions:

1. Open the file src/index.ts in your code editor

2. Locate the commented-out section that starts with:

   // Delete Table Tool
   /*
   server.tool(

   and ends with:

   );
   */

3. To uncomment this section:

4. Delete the opening /* on the line after "Delete Table Tool"
5. Delete the closing */ before "Edit Table Schema Tool"

That's it! The delete-table tool will now be active again. (After running a new build)

Example of What the Code Should Look Like After

// Delete Table Tool
server.tool(
  "delete-table",
  "Delete a table from the Xano workspace",
  {
    table_id: z.string().describe("ID of the table to delete")
  },
  async ({ table_id }) => {
    // ... rest of the implementation
  }
);

Verification

After making these changes: 1. Save the file 2. Run a new build `npm run build' 3. Restart your MCP client (Claude / Cursor) 4. The delete-table tool should now be available in your toolset

Safety Note

The delete-table tool permanently removes tables from your Xano workspace. Make sure you have appropriate backups before using this functionality.