MSSQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MSSQL_HOST | No | Database server hostname | |
| MSSQL_PORT | No | Database server port (default: 1433) | |
| MSSQL_USER | No | Database username | |
| MSSQL_ENCRYPT | No | Enable encryption (default: false) | |
| MSSQL_DATABASE | No | Database name (default: master) | |
| MSSQL_PASSWORD | No | Database password | |
| MSSQL_CONNECTION_STRING | No | Full connection string, e.g., Server=localhost;Database=master;User Id=sa;Password=yourpassword; | |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Trust server certificate (default: true) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_connectionsA | List all available named database connections configured in the server |
| test_connectionC | Test the database connection and return basic server information |
| list_databasesB | List all databases available on the SQL Server instance |
| list_tablesB | List all tables in the connected database |
| describe_tableB | Get detailed schema information for a specific table including columns, data types, and constraints |
| sample_dataB | Retrieve sample data from a table (top 10 rows by default) |
| execute_queryA | Execute a custom SQL SELECT query with automatic limit (top 20 rows) |
| get_relationshipsC | Get foreign key relationships between tables in the database |
| list_stored_proceduresC | List all stored procedures, functions, and their basic information |
| describe_stored_procedureC | Get detailed information about a specific stored procedure including parameters and definition |
| list_viewsC | List all views in the database with their basic information |
| describe_viewC | Get detailed information about a specific view including its definition and dependencies |
| list_triggersB | List all triggers in the database with their associated tables |
| describe_triggerA | Get detailed information about a specific trigger including its definition and events |
| list_functionsB | List all user-defined functions (scalar, table-valued, etc.) |
| list_indexesB | List all indexes on tables with usage statistics and detailed information |
| analyze_table_statsB | Get table row counts, size information, and last update statistics |
| find_missing_indexesC | Identify potentially missing indexes based on query execution patterns |
| analyze_index_usageC | Show detailed index usage statistics to identify unused or underutilized indexes |
| analyze_database_sizeC | Get comprehensive database size information including data and log file sizes |
| list_constraintsC | List all constraints (check, unique, foreign key, etc.) across tables in the database |
| analyze_check_constraintsB | Extract and analyze business rules from check constraints |
| list_user_defined_typesC | List all user-defined data types and their definitions |
| find_computed_columnsC | List computed columns and their formulas to understand derived business logic |
| list_default_constraintsC | List all default value constraints and their definitions |
| analyze_data_distributionC | Get data distribution patterns for columns to understand data quality and patterns |
| find_lookup_tablesC | Identify reference/lookup tables automatically based on table patterns |
| analyze_null_patternsC | Find columns with high null percentages and analyze null patterns |
| detect_audit_columnsB | Identify common audit trail patterns (created/modified dates, user tracking) |
| get_stored_procedure_definitionA | Get the complete SQL query/definition of a stored procedure - this is the actual source code |
| get_multiple_stored_procedure_definitionsC | Get complete SQL definitions for multiple stored procedures at once |
| get_all_stored_procedure_definitionsB | Get complete SQL definitions for all stored procedures in a schema |
| search_stored_procedures_by_contentB | Search for stored procedures containing specific text or patterns in their SQL definition |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 33 tools
Most tools have distinct purposes targeting specific database objects or analysis tasks, with clear boundaries. However, some overlap exists: get_stored_procedure_definition, get_multiple_stored_procedure_definitions, and get_all_stored_procedure_definitions could be confused as they all retrieve stored procedure definitions, differing only in scope. Similarly, describe_stored_procedure overlaps with these but focuses on metadata rather than full definitions.
Tool names follow a highly consistent verb_noun pattern throughout, using snake_case uniformly. Verbs like analyze_, describe_, find_, get_, list_, and sample_ are applied predictably across related tools, making the set easy to navigate and understand. There are no deviations in naming conventions.
With 33 tools, the count is borderline high for a database analysis server, potentially overwhelming for agents. While the tools cover many aspects of SQL Server analysis, some could be consolidated (e.g., multiple stored procedure definition tools) to reduce complexity. It feels heavy but not extreme, given the broad scope of database introspection.
The tool set provides comprehensive coverage for database analysis and introspection, including listing objects, describing schemas, analyzing performance and data patterns, and executing queries. There are no obvious gaps; it supports full lifecycle tasks from connection testing to detailed metadata exploration, ensuring agents can perform thorough database investigations without dead ends.