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 be capable of fetch Airbnb listings for a particular date vary and placement, and routinely 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 package deal 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 package deal supervisor

To put in the uv package deal supervisor, use the next instructions primarily based 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

Should you want 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 atmosphere constructed on high 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 can 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 working in your terminal for Cursor IDE to work together with it. If the server is stopped or the terminal is closed, the connection will not work.

To begin the server:

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

• Run the next command:

As soon as working, each the servers ought 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 particular date vary and placement, and request the info to be pasted into Excel on your evaluation.

For instance:

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

Observe:

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

The Excel MCP server additionally helps working primary knowledge evaluation on the Excel file straight via chat prompts. Nonetheless, we gained’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 enables 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 Brief 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 utility in varied areas.