Hotel Booking MCP Server
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
π¨ 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 |
| Fetch all registered customers |
| Fetch all rooms with full details |
| Fetch only rooms with |
| Fetch all bookings with customer & room info |
| Fetch only |
Related MCP server: SQL Server MCP
π οΈ 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
Python 3.12+ installed
uv installed β Install uv
ODBC Driver 17 for SQL Server installed β Download here
SQL Server running locally with the
HotelBookingSystemdatabase
ποΈ 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=yesRequired tables:
Customersβ CustomerID, FirstName, LastName, Email, PhoneNumber, City, CountryRoomsβ RoomID, RoomNumber, RoomType, Floor, Capacity, PricePerNight, Amenities, StatusBookingsβ BookingID, CustomerID, RoomID, CheckInDate, CheckOutDate, TotalPrice, BookingStatus, PaymentStatus
π Getting Started
1. Clone the repository
git clone <your-repo-url>
cd HotelBookingMCP2. Create virtual environment and install dependencies
uv sync3. Run the MCP server (stdio mode)
uv run python main.py4. Test with the MCP Inspector
uv run mcp dev main.pyThen 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.pyOption 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
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
This server cannot be deployed
Maintenance
Related MCP Connectors
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
MCP server exposing klokin time-tracking operations (employees, time entries, stores) to AI clients.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP server for Microsoft SQL Server integration that enables users to query, monitor, and analyze databases directly through Claude. It supports schema exploration, performance analysis, and optional write operations via natural language commands.10 npm1MIT
- AlicenseBqualityDmaintenanceAn MCP server that connects AI assistants to Microsoft SQL Server databases, enabling schema exploration and read-only queries safely.496MIT
- AlicenseBqualityDmaintenanceA powerful MCP server for Microsoft SQL Server that connects AI assistants directly to your SQL Server databases with enterprise-grade security controls.383MIT
- AlicenseNot gradedqualityBmaintenanceAn MCP server that enables AI assistants to query and manage Microsoft SQL Server databases using natural language.142 npm5MIT