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 |
|---|---|
| mssql_list_databases | List all databases the user has access to |
| mssql_list_tables | List all tables in a database |
| mssql_describe_table | Get detailed information about a table structure |
| mssql_query | Execute a read-only SELECT query |
| mssql_sample_data | Get sample data from a table |
| mssql_get_relationships | Get foreign key relationships for tables |
| mssql_health_check | Check database server health and connectivity with performance metrics |
| mssql_validate_query | Validate a SQL query for security and syntax without executing it |
| mssql_bulk_insert | Insert multiple rows efficiently using bulk operations |