Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mcp_table_analysis | Comprehensive SQL Server table analysis including structure, columns, keys, indexes, and constraints |
| mcp_sp_structure | Analyze SQL Server stored procedure structure including parameters, dependencies, and source code |
| mcp_preview_data | Get a preview of data from a SQL Server table with optional filters |
| mcp_get_column_stats | Get comprehensive statistics for a specific column in a table |
| mcp_execute_procedure | Execute a SQL Server stored procedure with parameters and return results |
| mcp_execute_query | Execute a raw SQL query and return the results |
| mcp_quick_data_analysis | Quick statistical analysis of a table including row count, column distributions, and top values |
| mcp_search_comprehensive | Search across database objects by name and definition with configurable criteria |
| mcp_get_dependencies | Get dependencies for a database object (tables, views, stored procedures, etc.) |
| mcp_get_sample_values | Get sample values from a specific column in a table |
| mcp_get_security_status | Get current security configuration and status for database operations |