🏨 Hotel Booking MCP Server

An MCP (Model Context Protocol) server that connects AI assistants like Claude to a Microsoft SQL Server hotel booking database. It exposes hotel data as tools that Claude can call naturally in conversation.

---

📋 Features

Tool	Description
get_all_customers	Fetch all registered customers
get_all_rooms	Fetch all rooms with full details
get_available_rooms	Fetch only rooms with Available status
get_all_bookings	Fetch all bookings with customer & room info
get_active_bookings	Fetch only Confirmed and Pending bookings

---

🛠️ Tech Stack

• Python 3.12+
• MCP Python SDK v2.0.0 (mcp)
• pyodbc — Microsoft SQL Server driver
• uv — Fast Python package & project manager
• SQL Server with ODBC Driver 17

---

⚙️ Prerequisites

1. Python 3.12+ installed
2. uv installed — Install uv
3. ODBC Driver 17 for SQL Server installed — Download here
4. SQL Server running locally with the HotelBookingSystem database

---

🗄️ Database Setup

The server connects to a local SQL Server database using Windows Authentication (Trusted Connection).

Connection string used:

Driver={ODBC Driver 17 for SQL Server}
Server=localhost
Database=HotelBookingSystem
Trusted_Connection=yes

Required tables:

• Customers — CustomerID, FirstName, LastName, Email, PhoneNumber, City, Country
• Rooms — RoomID, RoomNumber, RoomType, Floor, Capacity, PricePerNight, Amenities, Status
• Bookings — BookingID, CustomerID, RoomID, CheckInDate, CheckOutDate, TotalPrice, BookingStatus, PaymentStatus

---

🚀 Getting Started

1. Clone the repository

git clone <your-repo-url>
cd HotelBookingMCP

2. Create virtual environment and install dependencies

uv sync

3. Run the MCP server (stdio mode)

uv run python main.py

4. Test with the MCP Inspector

uv run mcp dev main.py

Then open the URL shown in the terminal (e.g. http://localhost:6274) in your browser.

---

🤖 Connecting to Claude Desktop

Option A — Automatic install (recommended)

uv run mcp install main.py

Option B — Manual config

Edit %APPDATA%\Claude\claude_desktop_config.json and add:

{
  "mcpServers": {
    "Hotel Booking MCP Server": {
      "command": "C:\\Users\\<YOUR_USERNAME>\\.local\\bin\\uv.EXE",
      "args": [
        "run",
        "--project",
        "D:\\Path\\To\\HotelBookingMCP",
        "python",
        "D:\\Path\\To\\HotelBookingMCP\\main.py"
      ]
    }
  }
}

⚠️ Replace <YOUR_USERNAME> and the paths with your actual values.

After updating the config, fully restart Claude Desktop for the changes to take effect.

---

🔧 Connecting to Claude Code (CLI)

claude mcp add hotel-booking-mcp -- uv run python main.py

---

📁 Project Structure

HotelBookingMCP/
├── main.py              # MCP server with all tools
├── pyproject.toml       # Project metadata & dependencies
├── .python-version      # Python version pin
├── .gitignore
└── README.md

---

📝 Example Claude Prompts

Once connected, you can ask Claude things like:

• "Show me all available rooms"
• "List all active bookings"
• "Which customers are from Yangon?"
• "What rooms are available and what are their prices?"

---

🪪 License

MIT