MCP MSSQL Server
About
MCP (Model Context Protocol) server for Microsoft SQL Server integration built with NestJS
Explore
- 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
npm install
MSSQL_USERNAME=your_username
MSSQL_PASSWORD=your_password
MSSQL_WIN_AUTH=true
MSSQL_DOMAIN=your_domain
MSSQL_USERNAME=domain\username
MSSQL_PASSWORD=your_password
1. Start the MCP server: npm run start:dev
2. Configure Claude Code to connect to: http://localhost:3000/mssql/mcp
3. Use the exposed SQL tools through Claude Code's MCP interface
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
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
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
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
