Northwind FastAPI MCP Example
Uses FastAPI to create an MCP server that exposes the Northwind database through both a REST API and an MCP endpoint, allowing queries for product data and other Northwind dataset information.
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.
π Northwind FastAPI MCP Example
This project demonstrates how to use fastapi-mcp to create a Model Context Protocol (MCP) server that allows Large Language Models (LLMs) to connect and interact with a REST API.
π Overview
The Northwind API is a simple example that shows how to expose data from the classic Northwind database through both a traditional REST API and an MCP endpoint, making it accessible for LLMs to query and understand.
Related MCP server: SQL Server MCP
π Getting Started
Prerequisites
Python 3.10+ π
Virtual environment tool π§
Installation
Clone the repository and install dependencies:
git clone https://github.com/RobertoRuben/mcp-northwind-fastapi-example.git cd mcp-northwind-fastapi-example python -m venv venv venv\Scripts\activate # On Windows pip install -r requirements.txtRun the application:
uvicorn src.main:app --reloadAccess the API documentation at
http://localhost:8000/api/v1/docsπ
π Available Endpoints
REST API Endpoints
GET /api/v1/products: List all products π¦
MCP Endpoint
http://localhost:8000/mcp: Model Context Protocol endpoint for LLM connections π€
π Connecting an LLM to the API
This example demonstrates how fastapi-mcp creates a bridge between your REST API and Large Language Models:
Traditional REST endpoints serve structured data at
/api/v1/products*πThe MCP endpoint at
/mcpallows LLMs to discover and interact with your API programmatically π§LLMs can understand your data schema and execute appropriate API calls automatically. β¨
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
Related MCP Connectors
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yoβ¦
An MCP server that provides an API to LLMs to manage their JumpCloud resources.
API-first CRM for LLMs - contacts, companies, deals and activities over a native MCP server.
Related MCP Servers
- FlicenseNot gradedqualityCmaintenanceA Model Context Protocol server that allows Large Language Models like Claude to execute SQL queries, explore database schemas, and maintain persistent connections to SQL Server databases.-
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.8601 npm8MIT
- AlicenseNot gradedqualityDmaintenanceAn MCP (Model Context Protocol) server that exposes natural language to SQL functionality, allowing any MCP-compatible client to convert plain English questions into SQL queries for database interaction using AI.3MIT
- AlicenseAqualityCmaintenanceA Model Context Protocol server that enables LLMs like Claude to interact with Microsoft SQL Server databases through natural language, supporting queries, data manipulation, and table management.82,101 npmMIT