MCP MSSQL Server

An MCP (Model Context Protocol) server for Microsoft SQL Server integration built with NestJS. This server enables Claude Code and other MCP clients to interact with SQL Server databases through standardized tools.

Features

- MCP Protocol Support: Full implementation of Model Context Protocol for SQL Server operations
- Windows Authentication: Supports both Windows (NTLM) and SQL Server authentication
- Comprehensive SQL Tools: Execute queries, explore schema, manage tables, and run stored procedures
- Health Monitoring: Built-in health checks for database connectivity
- Connection Pooling: Efficient database connection management

MCP Tools

The server exposes these SQL operations as MCP tools:

- execute-query: Execute SQL queries with parameter support
- get-schema: Retrieve database schema information
- list-tables: List all tables in the database
- describe-table: Get detailed table structure with constraints
- get-table-data: Retrieve paginated table data with filtering
- execute-procedure: Execute stored procedures with parameters

Installation

npm install

Configuration

Create a .env file with your database configuration:

```bash