SQL-AI-samples icon indicating copy to clipboard operation
SQL-AI-samples copied to clipboard
verified publisher icon Azure-Samples

MSSQL MCP Server in Nodejs

Open AkshayMata opened this issue 8 months ago • 0 comments

This PR introduces the initial implementation of a Node JS application that acts as an MCP server for Microsoft SQL Server and Azure SQL Database.

Key Features:

  • MCP Server Implementation in nodejs
  • Sets up the MCP server with standard I/O transport and automatic tool discovery.
  • Implements interactive connections + authorization with token caching.
  • Implements tools for core SQL operations: CreateIndex, CreateTable, DescribeTable, DropTable, InsertData, ListTables, QueryTable, ReadData, and UpdateData.

AkshayMata avatar May 05 '25 16:05 AkshayMata