Provides tools for interacting with Airtable to manage employee records, including search, advanced search, create, update, delete, dashboard statistics, and duplicate validation.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Airtable MCP Server show me all active employees in the Sales department"
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.
A production-ready MCP Server built using Node.js, Model Context Protocol (MCP), and Airtable.
This project demonstrates how AI clients can securely interact with Airtable using MCP tools.
Search Employee
Advanced Employee Search
Create Employee
Update Employee
Delete Employee
Employee Dashboard
Duplicate Employee ID Validation
Duplicate Email Validation
Related MCP server: MCP Employee API Server
Node.js
MCP SDK (v1.30.0)
Airtable
Zod
Dotenv
airtable-mcp-server/
services/
tools/
docs/
screenshots/
server.js
package.json
README.md
.env.exampleTool | Description |
Search Employee | Search employee by name |
Advanced Employee Search | Search using Department, Status, Designation, Employee ID |
Create Employee | Create a new employee |
Update Employee | Update employee details |
Delete Employee | Delete an employee |
Dashboard | Employee statistics |
npm installCreate a .env file using .env.example
AIRTABLE_TOKEN=your_personal_access_token
AIRTABLE_BASE_ID=your_base_id
AIRTABLE_TABLE_NAME=Employee informationnpm startChatGPT / Claude / MCP Inspector
│
▼
MCP Server
│
▼
Employee Tools
│
▼
Airtable Service
│
▼
AirtableBulk Employee Import
Bulk Employee Update
AI Powered Employee Assistant
Employee Reports
Employee Analytics
Integration with Airtable Official MCP
Pavansai Gudla
This server cannot be deployed
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
Streamline your Attio workflows using natural language to search, create, update, and organize com…
