MS SQL Server MCP Protocol Implementation - provides tools for executing SQL queries, discovering database schema, and managing SQL Server databases through the Model Context Protocol
Server has 13 tools with schemas and descriptions present, but quality is inconsistent. Tool names lack clear action verbs (mcp_execute_query vs execute_sql_query). Descriptions are present but generic (avg ~80 chars, below 194-char baseline). Parameter descriptions exist but lack constraint details (ranges, formats, enums). Output schemas are not documented, critical for LLM planning. Error handling is minimal; no recovery guidance. Security concern: SQL injection prevention mentioned but not visible in code sample. Pagination support is good (cursor-based, chunking), but composition is poor, 13 tools do overlapping work (discover, discover_tables, discover_database are redundant). STDIO transport caps protocol score at 50.
Get comprehensive guide for cursor-based pagination
Discover database schema and structure
Get comprehensive database schema information including tables, views, procedures, and functions
Discover all tables in the database with their row counts and sizes
Execute a SQL query against the database with optional pagination support
Get detailed information about a scalar or table-valued function
Retrieve previously executed query results by UUID
Tool naming lacks clear action verbs. 'mcp_discover', 'mcp_discover_tables', 'mcp_discover_database' are vague and redundant. Should be 'list_tables', 'describe_schema', 'get_table_details' to signal intent.
Output schemas are not documented. LLMs cannot plan downstream calls or extract required fields (e.g., does mcp_table_details return column_names, data_types, constraints?). Critical for tool chaining.
Parameter descriptions lack constraint details. 'pageSize' has min/max in schema but description does not explain the range or why. 'cursorField' lacks guidance on which fields are valid for cursor-based pagination.
Inferred effective spec: <=2025-11-25.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 50 | <=2025-11-25 | v2 |
Get detailed information about indexes on a table
Execute a SQL query with cursor-based pagination support
Get detailed information about a stored procedure including parameters and definition
Stream large query results in chunks
Get detailed information about a specific table including columns, indexes, and constraints
Get detailed information about a database view including columns and definition
Error handling is minimal. No recovery guidance. Code shows 'prohibitedOperations' array is empty, so DROP/DELETE/UPDATE checks do not work. Errors should guide LLM: 'Query failed: syntax error at line 3. Check table names and column references.'
Tool composition is poor. Three discovery tools (mcp_discover, mcp_discover_tables, mcp_discover_database) overlap significantly. LLM cannot distinguish when to call which. Consolidate into one 'describe_schema' tool with optional filters.