Implementing An Airbnb and Excel MCP Server

On this tutorial, we’ll construct an MCP server that integrates Airbnb and Excel, and join it with Cursor IDE. Utilizing pure language, you’ll have the ability to fetch Airbnb listings for a selected date vary and site, and mechanically retailer them in an Excel file.

To run the Airbnb MCP server and join it to Excel, we’ll want to put in a couple of instruments: Node.js, uv bundle supervisor, Git, and Cursor IDE, since Claude desktop doesn’t help SSE-based MCP servers.

Node JS

We want npx to run the Airbnb MCP server, which comes with Node.js.

• Obtain the most recent model of Node.js from nodejs.org
• Run the installer.
• Go away all settings as default and full the set up

UV bundle supervisor

To put in the uv bundle supervisor, use the next instructions based mostly in your working system:

For Mac/Linux:

curl -LsSf https://astral.sh/uv/set up.sh | sh

For home windows (Powershell):

powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/set up.ps1 | iex"

Git

Git is required to clone the Excel MCP server repository.

Obtain Git from https://git-scm.com/downloads and full the set up.

Open your terminal, navigate to your required listing, and run:

git clone https://github.com/haris-musa/excel-mcp-server.git
cd excel-mcp-server

If you happen to favor to not use Git, you may obtain the repository manually:Go to https://github.com/haris-musa/excel-mcp-server, click on the “Code” button, and select “Obtain ZIP”. As soon as downloaded, extract the folder to your working listing.

Cursor IDE

• Obtain Cursor IDE from https://cursor.com.
• It’s free to obtain and comes with a 14-day free trial.

Cursor is an AI-powered growth surroundings constructed on prime of VS Code, and it’ll assist us hook up with the MCP servers and generate code utilizing pure language prompts.

Python dependencies

As soon as you might be within the excel-mcp-server listing (the one you cloned utilizing git or downloaded), run the next command

1. Open Cursor IDE.
2. Go to the menu and navigate to: File > Preferences > Cursor Settings > MCP
3. Click on on “Add a brand new international MCP server.”
4. This may open the mcp.json configuration file. Paste the next code there:

{
    "mcpServers": {
      "airbnb": {
        "command": "npx",
        "args": [
          "-y",
          "@openbnb/mcp-server-airbnb",
          "--ignore-robots-txt"
        ]
      },
      "excel": {
        "url": "http://localhost:8000/sse"
      }
    }
}

The Excel MCP server is an SSE-based (Server-Despatched Occasions) server, which suggests it must be operating in your terminal for Cursor IDE to work together with it. If the server is stopped or the terminal is closed, the connection will now not work.

To begin the server:

• Navigate to the excel-mcp-server listing (if you happen to’re not already there).

• Run the next command:

As soon as operating, each the servers needs to be seen in Cursor settings:

Now you can use the chat panel in Cursor IDE to work together with the server utilizing pure language. Merely ask for Airbnb listings for a selected date vary and site, and request the info to be pasted into Excel in your evaluation.

For instance:

“Get me Airbnb listings in Bengaluru for the primary week of June and add them to an Excel sheet.”

Be aware:

All Excel information generated via the MCP server can be saved within the excel_files folder positioned contained in the excel-mcp-server listing.

The Excel MCP server additionally helps operating fundamental knowledge evaluation on the Excel file straight via chat prompts. Nevertheless, we received’t be protecting that half on this tutorial.

Troubleshooting

If the Airbnb server isn’t responding accurately or fails to fetch listings, the difficulty is probably going associated to the ignoreRobotsText setting.

To resolve this, merely embody the next argument in your pure language immediate:

Instance:

“Get Airbnb listings for Bengaluru from fifth Might to tenth Might for two adults. Use “ignoreRobotsText”: true.”

This permits the server to bypass web site restrictions that may in any other case block automated entry.

Don’t neglect to observe us on Twitter and be part of our 90k+ ML SubReddit. For Promotion and Partnerships, please discuss us.

🔥 [Register Now] miniCON Digital Convention on AGENTIC AI: FREE REGISTRATION + Certificates of Attendance + 4 Hour Quick Occasion (Might 21, 9 am- 1 pm PST) + Palms on Workshop

I’m a Civil Engineering Graduate (2022) from Jamia Millia Islamia, New Delhi, and I’ve a eager curiosity in Information Science, particularly Neural Networks and their software in numerous areas.