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)