A
securityA
licenseA
qualityAllows 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 -
898
MIT License
Provides tools for interacting with Airtable bases and schemas, enabling listing of accessible bases and retrieval of detailed schema information including table structures and metadata.
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
.envfile 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 reloadnpm run build- Build the project for productionnpm start- Start the production HTTP servernpm 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
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
- -securityFlicense-qualityEnables 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 -71
- -securityAlicense-qualityEnables 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.
- -securityAlicense-qualityConnects AI tools directly to Airtable, allowing users to query, create, update, and delete records using natural language.Last updated -5339MIT License