mcp-server-mssql

mcp-server-mssql

1
databases

This project is an MCP server that facilitates interaction between AI agents and Microsoft SQL Server databases. It offers a robust set of features implemented in Node.js and TypeScript for database management.

MCP Server for Microsoft SQL Server (Node.js/TypeScript)

This project provides a Model Context Protocol (MCP) server that enables AI agents to interact with Microsoft SQL Server databases. It is implemented using Node.js and TypeScript.

Features

  • Connects to a single MSSQL database via environment variables.
  • Provides tools to list tables, retrieve table schemas, and perform CRUD operations.

Prerequisites

  • Node.js (v18 or later)
  • npm
  • Access to a Microsoft SQL Server instance
  • MSSQL ODBC drivers

Usage

  • Build the TypeScript code.
  • Run the server for development or production.
  • Connect using an MCP Client like Roo.