What can you do with this server?

The Xano MCP Server provides a Model Context Protocol (MCP) interface to manage Xano database operations securely and efficiently. Key capabilities: * Workspace Management: List all available workspaces * Table Management: * Create new tables in workspaces with names and optional descriptions * Add, update, and retrieve table content/records with pagination support * List all tables in a workspace with detailed information * Technical Features: * Secure authentication with Xano API * Type-safe API interactions using TypeScript * Environment-based configuration using .env files * Comprehensive error handling with detailed messages * MCP-compliant interface for consistent tool usage

Which integrations are available for this server?

Uses environment variables for configuration management, allowing secure storage of API keys and other sensitive data needed for Xano API interactions. Provides repository management for the MCP server codebase, with instructions for cloning and contributing to the project. Manages dependencies and provides scripts for building, developing, and running the MCP server. Implements type-safe API interactions with Xano, enabling better error handling and data validation when working with the Xano database operations.

How do I use Xano MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Xano MCP Server list all tables in workspace 123" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Xano MCP Server

A Model Context Protocol (MCP) server implementation for interacting with the Xano API. This server provides tools and resources for managing Xano database operations through the MCP interface.

Features

Secure authentication with Xano API
Type-safe API interactions using TypeScript
Environment-based configuration
MCP-compliant interface
Workspace management tools
Table content operations (create, read, update)
Improved error handling with detailed messages

Related MCP server: Xano MCP Server

Installation

# Clone the repository
git clone [your-repo-url]
cd xano_mcp

# Install dependencies
npm install

Configuration

Copy the example environment file:

cp .env.example .env

Update the .env file with your Xano credentials:

XANO_API_KEY=your_api_key_here
XANO_API_URL=your_xano_api_url
NODE_ENV=development
API_TIMEOUT=10000

Development

# Build the project
npm run build

# Run in development mode
npm run dev

# Start the server
npm start

Project Structure

xano_mcp/
├── src/
│   ├── api/
│   │   └── xano/
│   │       ├── client/       # API client implementation
│   │       ├── models/       # Data models and types
│   │       ├── services/     # API service implementations
│   │       └── utils/        # Utility functions
│   ├── mcp/
│   │   ├── server/          # MCP server implementation
│   │   ├── tools/           # MCP tool implementations
│   │   └── types/           # Tool-specific types
│   ├── config.ts            # Configuration management
│   └── index.ts             # Main entry point
├── .env                     # Environment variables (not in git)
├── .env.example            # Example environment variables
└── tsconfig.json           # TypeScript configuration

Available MCP Tools

Workspace Tools

get_workspaces: List all available workspaces

Table Tools

create_table: Create a new table in a workspace
get_table_content: Get content from a table with pagination support
add_table_content: Add new content to a table
update_table_content: Update existing content in a table
get_all_tables: List all tables in a workspace with detailed information

Usage Examples

Working with Workspaces

// List available workspaces
const result = await mcp.use_tool("get_workspaces", {});
console.log('Workspaces:', result);

Managing Tables

// Create a new table
const createResult = await mcp.use_tool("create_table", {
  workspaceId: 123,
  name: "MyTable"
});

// Add content to a table
const addResult = await mcp.use_tool("add_table_content", {
  workspaceId: 123,
  tableId: 456,
  content: {
    created_at: "2024-01-22T17:07:00.000Z"
  }
});

// Get table content with pagination
const getResult = await mcp.use_tool("get_table_content", {
  workspaceId: 123,
  tableId: 456,
  pagination: {
    page: 1,
    items: 50
  }
});

// Update table content
const updateResult = await mcp.use_tool("update_table_content", {
  workspaceId: 123,
  tableId: 456,
  contentId: "789",
  content: {
    created_at: "2024-01-22T17:07:00.000Z"
  }
});

// List all tables in a workspace
const tables = await mcp.use_tool("get_all_tables", {
  workspaceId: 123
});
console.log('Tables:', tables);
// Returns an array of tables with their details:
// [
//   {
//     id: number,
//     name: string,
//     description: string,
//     created_at: string,
//     updated_at: string,
//     guid: string,
//     auth: boolean,
//     tag: string[],
//     workspaceId: number
//   },
//   ...
// ]

Environment Variables

Variable	Description	Required	Default
XANO_API_KEY	Your Xano API authentication key	Yes	-
XANO_API_URL	Xano API endpoint URL	Yes	-
NODE_ENV	Environment (development/production)	No	development
API_TIMEOUT	API request timeout in milliseconds	No	10000