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

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

Features

• Connects directly to a single MSSQL database instance configured via environment variables.

• Provides tools for:

  • Listing tables (list_tables).

  • Retrieving table schemas (get_table_schema).

  • Performing CRUD operations (read_table_rows, create_table_records, update_table_records, delete_table_records).

Prerequisites

• Node.js (v18 or later recommended)

• npm (usually comes with Node.js)

• Access to a Microsoft SQL Server instance.

• Necessary MSSQL ODBC drivers installed on the machine running the server.

Installation

1. Clone the repository:

   git clone <repository-url>
   cd mcp-server-mssql

2. Install dependencies:

   npm install

Configuration

1. Environment Variables: Configuration is handled entirely through environment variables.

   • Copy .env.example to .env.

   • Fill in the required MSSQL connection details:

     • MSSQL_HOST

     • MSSQL_PORT (defaults to 1433 if not set)

     • MSSQL_USER

     • MSSQL_PASSWORD

     • MSSQL_DATABASE

   • Optionally configure other MSSQL options (MSSQL_DRIVER, MSSQL_ENCRYPT, MSSQL_TRUST_SERVER_CERTIFICATE) and logging (LOG_LEVEL) as described in .env.example.

Usage

1. Build the TypeScript code:

   npm run build

2. Run the server:

   npm start

   Alternatively, for development:

   npm run dev

3. Connect via MCP Client: Configure your MCP client (e.g., Roo) to connect to this server using stdio.

Tools

(Detailed descriptions of the tools can be found in the server's ListTools response)

• list_tables

• get_table_schema

• read_table_rows

• create_table_records

• update_table_records

• delete_table_records

Development

(Add details about running tests, linting, etc. later)

License

[MIT] - (Or your chosen license)