Complete Airtable Database Management with AI Agents and Redis Storage

Go to Workflow
0 views
Built by Denis Denis
Created on June 08, 2026

Description

What this workflow does
Complete Airtable database management system using MCP (Model Context Protocol) for AI agents. Create bases, tables with complex field types, manage records, and maintain state with Redis storage.

Setup steps
Add your Airtable Personal Access Token to credentials
Configure Redis connection for ID storage
Get your workspace ID from Airtable (starts with wsp...)
Connect to MCP Server Trigger
Configure your AI agent with the provided instructions

Key features
Create new Airtable bases and custom tables
Support for all field types (date, number, select, etc.)
Full CRUD operations on records
Rename tables and fields
Store base/workspace IDs to avoid repeated requests
Generic operations work with ANY Airtable structure

Included operations
create_base, create_custom_table, add_field
get_table_ids, get_existing_records
update_record, rename_table, rename_fields
delete_record
get/set base_id and workspace_id (Redis storage)

Notes
Check sticky notes in workflow for ID locations and field type requirements.

Nodes Used (4)

AI Agent
@n8n/n8n-nodes-langchain.agent
MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat