Airtable MCP Server

# Changelog All notable changes to this project will be documented in this file. ## [Unreleased] ### Added - Created `.cursor/mcp.json` configuration file for Cursor IDE integration - Set up Airtable MCP server configuration with placeholder for API key - Built web application to list all Airtable bases - Express server (`server.js`) with secure API endpoint - Modern, responsive HTML frontend (`public/index.html`) - Features: search, filter by permission level, statistics dashboard - Server-side API key handling for security - Added `npm run web` script to start the web server - Added table viewing feature: click on any base card to view all tables in that base - Modal popup with base information and table list - Table cards show: name, ID, description, field count, and view count - Click table cards to copy table ID to clipboard - New API endpoint: `/api/bases/:baseId/tables` - Added records viewing feature: click on any table card to view all records in that table - View selector modal: choose between Record Review, List View, or Grid View - Record Review: Full-screen two-panel layout (no modal popup) - List View: Table/spreadsheet format with all fields as columns - Grid View: Card-based layout showing records as cards - Left sidebar: searchable list of records with preview - Right panel: detailed view of selected record with all field values - Search functionality to filter records by ID or field content in all views - Click record items to view details (Record Review) or copy ID (List/Grid) - Copy record ID button - Back button to return to tables view - Switch View button to change between views - New API endpoint: `/api/bases/:baseId/tables/:tableId/records` - Added Vercel deployment configuration - Created `vercel.json` configuration file - Created `api/index.js` serverless function entry point - Updated `server.js` to be compatible with both local and Vercel deployment - Added `VERCEL_DEPLOYMENT.md` deployment guide - Project can now be deployed to Vercel with proper environment variables - Initialized Git repository - Created initial commit with all project files - Removed hardcoded API keys for security - Added `GIT_SETUP.md` with repository setup instructions - Ready for GitHub deployment ### Verified - API key tested and validated successfully - Confirmed access to 25 Airtable bases with appropriate permissions - MCP server configuration is ready for use in Cursor IDE - Web server running successfully on http://localhost:3000 ### Setup Instructions - Users need to replace `YOUR_AIRTABLE_API_KEY_HERE` in `.cursor/mcp.json` with their actual Airtable Personal Access Token - To get an API key: Visit https://airtable.com/create/tokens/new - Required scopes: `schema.bases:read`, `data.records:read` (and optionally `schema.bases:write`, `data.records:write`) - After configuration, restart Cursor IDE to activate the MCP server - To run the web application: `npm run web` and visit http://localhost:3000