🚀 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)

1. mssql_list_databases - List all accessible databases

2. mssql_list_tables - List tables in a specific database

3. mssql_describe_table - Get detailed table schema information

4. mssql_query - Execute queries with security validation and metrics

5. mssql_sample_data - Retrieve sample rows from tables

6. mssql_get_relationships - Discover foreign key relationships

New Advanced Tools

7. mssql_health_check - Server health monitoring with performance metrics

8. mssql_validate_query - Security validation without query execution

9. mssql_bulk_insert - Efficient bulk data insertion operations

🚀 Quick Start

🎯 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:

1. Clone or download this repository

2. Run npm install to install dependencies

3. Run npm run build to compile TypeScript

4. 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:

🔧 Available Tools

💡 Usage Examples

List databases:

Explore structure:

Query data:

Understand relationships:

🔒 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

• 📖 Detailed Usage Guide

• ⚙️ Configuration Options

• 📋 Requirements

🤝 Contributing

1. Fork the repository

2. Create a feature branch

3. Make your changes

4. Add tests if applicable

5. Submit a pull request

📄 License

MIT License - see LICENSE file for details

🆘 Support

If you encounter issues:

1. Check the Usage Guide for common solutions

2. Verify your MSSQL server configuration

3. Ensure proper database permissions

4. Open an issue with error details