🚀 Enhanced MCP MSSQL Server

A production-ready Model Context Protocol (MCP) server for Microsoft SQL Server that provides AI agents with secure, stateless database access capabilities.

✨ New Features & Enhancements

🔒 Advanced Security: SQL injection protection, query validation, and configurable security policies
📊 Health Monitoring: Real-time performance metrics and connection health checks
⚙️ Configuration Management: Environment-specific settings for development and production
📦 Bulk Operations: Efficient batch processing for large-scale data operations
🛡️ Enhanced Error Handling: Structured errors with actionable information for AI agents
🎯 Production Ready: Enterprise-grade monitoring and security capabilities

🛠️ Available Tools (9 Total)

Core Database Tools (Enhanced)

mssql_list_databases - List all accessible databases
mssql_list_tables - List tables in a specific database
mssql_describe_table - Get detailed table schema information
mssql_query - Execute queries with security validation and metrics
mssql_sample_data - Retrieve sample rows from tables
mssql_get_relationships - Discover foreign key relationships

New Advanced Tools

mssql_health_check - Server health monitoring with performance metrics
mssql_validate_query - Security validation without query execution
mssql_bulk_insert - Efficient bulk data insertion operations

🚀 Quick Start

# Install dependencies
npm install

# Build the project  
npm run build

# Configure your database (copy .env.example to .env)
cp .env.example .env

# Start the server
npm start

# Run tests (requires running MSSQL server)
npm test

🎯 What This Does

This MCP server allows AI agents to:

Connect to MSSQL databases securely
Discover database schemas (databases, tables, columns)
Query data safely with read-only access
Explore relationships and metadata
Sample data for analysis without full table scans

✨ Key Features

✅ Read-Only Safety: Only SELECT queries allowed
🔒 Secure Authentication: Encrypted connections by default
🔍 Schema Discovery: Automatic database structure exploration
📊 Smart Sampling: Get representative data without overload
🔗 Relationship Mapping: Understand foreign key connections
🛡️ SQL Injection Protection: Parameterized queries and validation

🛠️ Installation

Prerequisites:

Node.js 18+
Access to MSSQL Server (2008 R2+)
Database user with read permissions

Setup:

Clone or download this repository
Run npm install to install dependencies
Run npm run build to compile TypeScript
Configure your database connection (see Configuration section)

📝 Configuration

No Configuration Required!

This MCP server is now stateless - you provide connection details when calling each tool. The AI agent will ask for your database credentials when needed.

For Claude Desktop, add to your configuration:

{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": ["path/to/mcp-mssql-connector/dist/index.js"]
    }
  }
}

🔧 Available Tools

Tool	Description	Key Parameters
`mssql_connect`	Connect to MSSQL server	server, user, password
`mssql_list_databases`	List available databases	-
`mssql_list_tables`	List tables in database	database
`mssql_describe_table`	Get table structure	database, table
`mssql_query`	Execute SELECT query	database, query, limit
`mssql_sample_data`	Get sample rows	database, table, limit
`mssql_get_relationships`	Get foreign keys	database, table

💡 Usage Examples

List databases:

List all databases on server 'myserver.com' using username 'myuser' and password 'mypass'

Explore structure:

List all tables in the 'Northwind' database on myserver.com with my credentials

Query data:

Query "SELECT TOP 10 * FROM Customers WHERE Country = 'USA'" on Northwind database at myserver.com

Understand relationships:

Show foreign key relationships for the Orders table in Northwind database on myserver.com

🔒 Security

Read-Only: Only SELECT statements allowed
Input Validation: All parameters validated with Zod schemas
Connection Security: TLS encryption enabled by default
Query Limits: Automatic row limits prevent data dumps
Error Handling: Safe error messages without exposing internals

📚 Documentation

🤝 Contributing

Fork the repository
Create a feature branch
Make your changes
Add tests if applicable
Submit a pull request

📄 License

MIT License - see LICENSE file for details

🆘 Support

If you encounter issues:

Check the Usage Guide for common solutions
Verify your MSSQL server configuration
Ensure proper database permissions
Open an issue with error details