Airtable MCP Server

Airtable MCP

An MCP (Model Context Protocol) server that provides tools for interacting with Airtable bases and schemas.

Overview

This project implements an xMCP application that allows AI assistants to interact with Airtable.

Features

🗃️ List all accessible Airtable bases
📋 Retrieve detailed schema information for any base
🔒 Secure authentication using Airtable API keys
🚀 Built with TypeScript and xMCP framework
🔧 HTTP server support for easy integration

Prerequisites

Node.js >= 20.0.0
Airtable API key
Access to Airtable bases

Installation

Clone the repository:

git clone <repository-url>
cd airtable-mcp

Install dependencies:

npm install

Set up environment variables: Create a .env file in the root directory with:

AIRTABLE_API_KEY=your_airtable_api_key_here
AIRTABLE_API_URL=https://api.airtable.com

Getting Started

Run the development server:

npm run dev

Build for production:

npm run build
npm start

Available Tools

`listBases`

Description: List all Airtable bases owned by the user
Parameters: None
Returns: JSON array of bases with their metadata

`getBaseSchema`

Description: Get the schema of a specific Airtable base
Parameters:
- baseId (string): The ID of the Airtable base
Returns: JSON object containing the base's table schemas

Scripts

npm run dev - Start development server with hot reload
npm run build - Build the project for production
npm start - Start the production HTTP server
npm run lint - Run TypeScript type checking

Project Structure

airtable-mcp/
├── src/
│   └── tools/
├── package.json
├── xmcp.config.ts           # xMCP configuration
└── tsconfig.json           # TypeScript configuration

This project uses the structured approach where tools are automatically discovered from the src/tools directory. Each tool is defined in its own file with the following structure:

import { type ToolMetadata, InferSchema } from "xmcp";
import { z } from "zod";

// Define the schema for tool parameters (optional)
export const schema = {
  baseId: z.string(),
};

// Define tool metadata
export const metadata: ToolMetadata = {
  name: "getBaseSchema",
  description: "List the schema of the base owned by the user",
  annotations: {
    readOnlyHint: true,
    destructiveHint: false,
    idempotentHint: true,
  },
};

// Tool implementation
export default async function getBaseSchema(args: InferSchema<typeof schema>) {
  // Implementation here
}

Dependencies

airtable: Official Airtable JavaScript client
xmcp: xMCP framework for building MCP servers
zod: Runtime type validation

Learn More

This server cannot be installed

security - not tested

license - not found

quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Enables AI assistants to interact with Airtable databases by listing accessible bases and retrieving detailed schema information. Supports secure authentication and provides tools for exploring Airtable base structures through natural language.

Related MCP Servers

MySQL MCP Server
designcomputer
A
security
A
license
A
quality
Allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Last updated -
841
MIT License
Metabase MCP Server
imlewc
-
security
F
license
-
quality
Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.
Last updated -
65
Airtable MCP
mufonix
-
security
A
license
-
quality
Enables AI-powered applications to access and manipulate Airtable data directly from your IDE, supporting operations like querying, creating, updating, and deleting records through natural language commands.
Last updated -
MIT License
Airtable MCP
rashidazarang
-
security
A
license
-
quality
Connects AI tools directly to Airtable, allowing users to query, create, update, and delete records using natural language.
Last updated -
38
35
MIT License

View all related MCP servers

Airtable MCP Server

Airtable MCP

Overview

Features

Prerequisites

Installation

Getting Started

Available Tools

`listBases`

`getBaseSchema`

Scripts

Project Structure

Dependencies

Learn More

Related MCP Servers

MySQL MCP Server

Metabase MCP Server

Airtable MCP

Airtable MCP

New MCP Servers

MCP directory API