Enhanced MCP MSSQL Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mssql_list_databasesC | List all databases the user has access to |
| mssql_list_tablesC | List all tables in a database |
| mssql_describe_tableC | Get detailed information about a table structure |
| mssql_queryC | Execute a read-only SELECT query |
| mssql_sample_dataC | Get sample data from a table |
| mssql_get_relationshipsC | Get foreign key relationships for tables |
| mssql_health_checkB | Check database server health and connectivity with performance metrics |
| mssql_validate_queryA | Validate a SQL query for security and syntax without executing it |
| mssql_bulk_insertC | Insert multiple rows efficiently using bulk operations |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/michaelyuwh/mcp-mssql-connector'
If you have feedback or need assistance with the MCP directory API, please join our Discord server