SQL Server MCP PoC

Example Use Cases

• 1

  Interact programmatically with SQL Server databases using the Model Context Protocol.

• 2

  Perform database schema management and data manipulation through MCP tools.

• 3

  A modular backend to extend SQL Server capabilities via custom MCP tools.

Description

This proof of concept MCP server provides a modular and scalable integration for SQL Server operations such as creating tables, executing raw queries, retrieving table schemas, and inserting data. It leverages Docker for SQL Server setup, Prisma for database client generation, and Bun for running and building the server. The architecture separates business logic and MCP tool definitions to facilitate maintainability and extensibility.