Hello there!
There's been a lot of talk about AI agent and MCP servers lately. I decided to cut through the buzz and figure out what if it can do something useful for my work with Airtable.
I decided to spend a weekend researching this and honestly got frustrated with how not user friendly it all was. Make introduced MCP servers - but it was not very useful. Zapier was pretty good, but did not have ability to create tables and fields.
There were 2 code projects for Airtable MCP servers (project 1, project 2). I can code but most of my clients or my channel viewers at first mention of installing coding environment locally will just check out.
After some more digging I found a way how to set up remote MCP server that can be connected to a chat client (with Claude.ai being the most user friendly now) . This simple proof of concept that you can actually play with right now is here: https://airtable-mcp.business-automated.com/
This is obviously just a proof of concept to let people test things out. Airtable will probably come out with their own official MCP server at some point since everyone else is doing it. e.g Notion. For now, this gives you a way to actually try it and see what's possible.. and it is pretty good! I got quite far in creating tables and addng fields as well as creating demo records
I made a video showing how it works too - check it out below.
Anyone else been playing around with MCP servers for Airtable? What kind of stuff are you trying to do with it?
Looking forward to offical MCP server from Airtable Team!