# Xano MCP Server

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:
```bash
git clone https://github.com/lowcodelocky2/xano-mcp.git
cd xano-mcp
```

2. Install dependencies:
```bash
npm install
```

3. Configure your Xano credentials:
   - 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)

4. Build the project:
```bash
npm run build
```

## Usage with Claude Desktop

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

Update your config with: 
```json
{
  "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:
   - Name: `whatever you want to call it`
   - Type: `command`
   - 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:
   ```typescript
   // Delete Table Tool
   /*
   server.tool(
   ```
   and ends with:
   ```typescript
   );
   */
   ```

3. To uncomment this section:
   - Delete the opening `/*` on the line after "Delete Table Tool"
   - 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

```typescript
// 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.