restaurant-mcp
Provides tools to query a SQLite database for restaurant data including orders, inventory, tables, and sales.
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.
restaurant-mcp
MCP server for Spice Garden, a demo restaurant, with an optional OpenRouter-powered chat client. The assistant queries a live SQLite database for orders, inventory, tables, and sales data.
Prerequisites
Node.js 20.6+ (required for
--env-file)An OpenRouter API key (for the chat client only)
Related MCP server: mcp-sqlite-chat
Quick start
npm install
cp .env.example .env # Windows: copy .env.example .env
# Edit .env — add your OPENROUTER_API_KEY and pick a tool-capable model
npm run seed
npm run chatExample questions:
How many orders today?Which is our most popular dish?What's running low in inventory?How many tables are occupied?
Type exit to quit.
Scripts
Command | Description |
| Create and populate |
| Start the interactive OpenRouter assistant |
| Run the MCP server directly (stdio) |
Environment variables
Copy .env.example to .env:
Variable | Required | Description |
| For chat | Your OpenRouter API key |
| For chat | Model ID — must support tool calling |
| No | Set to |
Choosing a model
The chat client sends tools with every request, so the model must support function/tool calling. Browse compatible models at:
https://openrouter.ai/models?supported_parameters=tools
Free-tier examples that work:
meta-llama/llama-3.3-70b-instruct:freeqwen/qwen3-coder:freeopenai/gpt-oss-20b:free
MCP server tools
Tool | Description |
| Order count, revenue, and pending orders for a date |
| Current stock levels for all items |
| Items below their reorder threshold |
| Best-selling menu items by quantity |
| Table occupancy and capacity |
Use with Cursor (or any MCP client)
Add to your MCP config:
{
"mcpServers": {
"restaurant": {
"command": "node",
"args": ["/absolute/path/to/restaurant-mcp/server.js"]
}
}
}Run npm run seed first. The server exits with a clear message if the database is missing or empty.
Project structure
restaurant-mcp/
├── server.js # MCP server (stdio)
├── client.js # OpenRouter chat client
├── db/
│ ├── seed.js # Database schema + sample data
│ └── restaurant.db # Generated (gitignored)
├── lib/
│ ├── db.js # Database bootstrap check
│ └── paths.js # Shared paths and version
└── .env # Your secrets (gitignored)License
ISC
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
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Hosted MCP server for live public-data APIs and Skills for AI agents.
MCP server for AI dialogue using various LLM models via AceDataCloud
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceDemo MCP server that exposes order and customer data as read-only tools for AI assistants, simulating a business API or internal data source.-
- FlicenseNot gradedqualityDmaintenanceEnables querying and managing a SQLite database using natural language, with an MCP server and Groq LLM.-
- AlicenseNot gradedqualityDmaintenanceMCP server that exposes tools to query an e-commerce database (customers, sales, products) using natural language, orchestrated by a LangChain agent with Groq's LLM.MIT
- FlicenseNot gradedqualityDmaintenanceA secure MCP server that exposes a SQLite database to AI agents with Role-Based Access Control, supporting authentication, customer/order/user management, and audit logging.-