⚙️ Configure: Set up individual environment variables (see configuration below)
🔗 Connect: Tools automatically use your configured connections
🔍 Explore: Use natural language to query and explore your databases conversationally
Comprehensive MCP server for interacting with a Microsoft SQL database
2026-10-28
स्टार
3
टूल
—
अपटाइम
—
📄 Extract: Get complete stored procedure SQL code for business logic analysis
🏗️ Modernize: Use comprehensive schema tools to plan application modernization. This comprehensive Model Context Protocol (MCP) server for Microsoft SQL Server database analysis and modernization provides extensive capabilities for exploring and transforming your database schema. For complete configuration details, file locations, and troubleshooting, see the Configuration Guide.
💬 Conversational Usage
With multiple connections configured, you can switch between databases naturally: This comprehensive server provides extensive tools for analyzing Classic ASP applications, exploring database schemas, and planning modernization to .NET/Angular architectures.
Built using the tedious library for pure JavaScript SQL Server connectivity with support for Windows Authentication (NTLM).
🆕 Latest Update: Enhanced stored procedure tools now provide complete SQL source code access for comprehensive business logic analysis and modernization planning.
❓ Why Windows Credentials in Environment Variables?
NTLM Pass-Through Authentication Requirement: When connecting to SQL Server using Windows Authentication (Integrated Security=SSPI), the MSSQL MCP server must provide explicit domain credentials because:
No Interactive Session: MCP servers run as background processes without access to the current user's Windows session
NTLM Protocol: Windows Authentication requires explicit username, password, and domain to establish the NTLM handshake
Security Context: The tedious library needs these credentials to impersonate the domain user for database access
Cross-Process Authentication: Unlike applications running in the user's context, MCP servers need explicit credential delegation
Environment variables are the secure, standard way to provide these credentials without hard-coding them in configuration files.
🛠️ Available Tools (29 Comprehensive Database Analysis Tools)
🔧 Core Database Tools (8 tools)
🔌 test_connection - Test database connectivity and get server information
📋 list_connections - List all available named database connections
📚 list_databases - List all available databases on the SQL Server instance
📊 list_tables - List all tables in a specific schema (default: dbo)
📝 describe_table - Get detailed schema information including columns, data types, and constraints
🎯 sample_data - Retrieve sample data from a table (default: 10 rows, max: 100)
💻 execute_query - Execute custom SELECT queries (disabled by default; set MSSQL_ENABLE_EXECUTE_QUERY=true to enable)
🔗 get_relationships - Get foreign key relationships between tables
🏗️ Schema Discovery Tools (7 tools)
📋 list_stored_procedures - List and analyze stored procedures with parameters and definitions
🔍 describe_stored_procedure - Get procedure parameters and definition
📋 list_views - Analyze views, their definitions, and dependencies
🔍 describe_view - Get view definition and dependencies
⚡ list_triggers - Identify triggers and their business logic
🔍 describe_trigger - Extract trigger logic and events
🔧 list_functions - List user-defined functions by type (scalar, table-valued, etc.)
⚡ Index & Performance Tools (5 tools)
📊 list_indexes - Comprehensive index usage statistics and recommendations
🎯 find_missing_indexes - Identify potentially missing indexes based on query patterns
📈 analyze_table_stats - Analyze table sizes, row counts, and space usage
🔄 Compatible: All existing configurations continue to work
💬 Conversational Usage
With multiple connections configured, you can switch between databases naturally in conversation:
User: "What database connections do I have available?"
Assistant: I'll list all your configured database connections...
[Shows: crm, erp, analytics, hr, etc.]
User: "Show me the customer tables in the CRM system"
Assistant: I'll explore the CRM database for customer-related tables...
[Uses connectionName: "crm"]
User: "Now check the analytics warehouse for sales data"
Assistant: Switching to the analytics database to look for sales data...
[Uses connectionName: "analytics"]
User: "Compare employee counts between HR system and ERP"
Assistant: I'll check both databases for employee information...
[Uses connectionName: "hr", then connectionName: "erp"]
🔒 Security Features
Read-Only Access: Only SELECT statements allowed
Query Validation: Automatic blocking of dangerous operations
Result Limiting: Automatic TOP clauses to prevent large data dumps
User: "What tables are in my database?"
Assistant: [Lists all tables with descriptions]
User: "Describe the customers table"
Assistant: [Shows column details, data types, constraints]
User: "Show me a sample of customer data"
Assistant: [Returns first 10 rows safely]
Multi-Database Scenarios
User: "List my available connections"
Assistant: [Shows all configured database connections]
User: "Switch to the analytics database and show me the sales tables"
Assistant: [Connects to analytics DB and lists sales-related tables]
User: "Query both CRM and ERP systems for customer overlap"
Assistant: [Queries both systems and compares results]
🏗️ Classic ASP Modernization Workflow
This MCP server provides specialized tools for analyzing Classic ASP applications and planning modernization:
// Extract detailed stored procedure logic
await mcp.call("describe_stored_procedure", {
procedureName: "CalculateOrderTotal",
schema: "MyApp",
includeDefinition: true,
});
// Get complete SQL source code for analysis
await mcp.call("get_stored_procedure_definition", {
procedureName: "ProcessOrder",
schema: "MyApp",
formatOutput: true,
});
// Bulk extract all stored procedures for modernization
await mcp.call("get_all_stored_procedure_definitions", {
schema: "MyApp",
maxResults: 50,
});
// Search for procedures using specific tables or business logic
await mcp.call("search_stored_procedures_by_content", {
searchText: "Customer",
schema: "MyApp",
includeDefinitions: true,
});
// Find computed columns with business rules
await mcp.call("find_computed_columns", {
schema: "MyApp",
});
// Analyze data validation rules
await mcp.call("analyze_check_constraints", {
schema: "MyApp",
});
Phase 3: Migration Planning
// Identify audit trails and tracking patterns
await mcp.call("detect_audit_columns", {
schema: "MyApp",
});
// Analyze data patterns for normalization
await mcp.call("analyze_data_distribution", {
tableName: "Orders",
schema: "MyApp",
});
// Plan index strategy for new application
await mcp.call("analyze_index_usage", {
schema: "MyApp",
});
💬 Advanced Usage Examples
Schema Discovery
User: "I need to understand the business logic in my legacy application database"
Assistant: I'll analyze your database for business logic patterns...
[Uses list_stored_procedures, analyze_check_constraints, find_computed_columns]
User: "What stored procedures handle order processing?"
Assistant: Let me search for order-related procedures...
[Uses search_stored_procedures_by_content with "order", then get_stored_procedure_definition for detailed analysis]
User: "Show me the complete SQL code for the CalculateOrderTotal procedure"
Assistant: I'll retrieve the full stored procedure definition...
[Uses get_stored_procedure_definition with formatOutput: true]
User: "Get all stored procedure code for the sales schema for modernization"
Assistant: I'll extract all stored procedure definitions from the sales schema...
[Uses get_all_stored_procedure_definitions with schema: "sales"]
Performance Analysis
User: "Find performance issues in my database"
Assistant: I'll analyze indexes and table performance...
[Uses find_missing_indexes, analyze_table_stats, analyze_index_usage]
User: "Which tables are growing too fast?"
Assistant: Let me check table sizes and growth patterns...
[Uses analyze_table_stats, analyze_database_size]
Multi-Database Analysis
User: "Compare customer data between our CRM and ERP systems"
Assistant: I'll analyze customer tables in both systems...
[Switches between connectionName: "crm" and connectionName: "erp"]
User: "Find data quality issues across all our databases"
Assistant: Let me check data patterns across your systems...
[Uses analyze_null_patterns, analyze_data_distribution across multiple connections]
🔧 Development
# Development mode
npm run dev
# Build for production
npm run build
# Run tests
npm test
📝 License
MIT License - see LICENSE file for details.
🤝 Contributing
Contributions welcome! Please read CONTRIBUTING.md for guidelines.
अभी टूल सूची नहीं है। रिमोट सर्वर को पहले हेल्थ चेक के बाद सूची मिलती है।
FAQ
सवाल
Mssql कैसे इंस्टॉल करें?
इस पेज पर Cursor, Claude Desktop, Claude Code या VS Code के लिए stdio कॉन्फ़िग कॉपी करें। यह पब्लिशर का इंस्टॉल इस्तेमाल करता है, PlugMCP प्रॉक्सी नहीं।
क्या Mssql के लिए API key चाहिए?
इस रिकॉर्ड में कोई ज़रूरी एनवायरनमेंट वेरिएबल दर्ज नहीं है।
Mssql कौन सा ट्रांसपोर्ट इस्तेमाल करता है?
Mssql stdio पर लोकल चलता है।
Mssql की पिछली जाँच कब हुई थी?
पिछली जाँच 2026-10-28 को हुई। Comprehensive MCP server for interacting with a Microsoft SQL database