mssql-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| READONLY | No | Set to 'true' to restrict to read-only tools | |
| SQL_PORT | No | Custom port (default: 1433) | |
| SQL_DOMAIN | No | Domain for Windows/NTLM auth (optional) | |
| SERVER_NAME | No | SQL Server hostname or IP | |
| SCRIPTS_PATH | No | Path to named SQL scripts directory | |
| SQL_PASSWORD | No | Password for SQL or Windows auth | |
| SQL_USERNAME | No | Username for SQL or Windows auth | |
| AUDIT_LOGGING | No | Set to 'false' to disable audit logging (default: true) | |
| DATABASE_NAME | No | Target database name | |
| SQL_AUTH_MODE | No | Authentication mode: sql, windows, or aad (default: aad) | |
| AUDIT_LOG_PATH | No | Path for audit log file (default: logs/audit.jsonl) | |
| MAX_ROWS_DEFAULT | No | Auto-limit for SELECT queries (default: 1000) | |
| CONNECTION_TIMEOUT | No | Connection timeout in seconds (default: 30) | |
| AUDIT_REDACT_SENSITIVE | No | Set to 'false' to disable redaction (default: true) | |
| ENVIRONMENTS_CONFIG_PATH | No | Path to JSON file defining multiple environments | |
| TRUST_SERVER_CERTIFICATE | No | Set to 'true' for self-signed certificates | |
| PROFILE_SAMPLE_RETURN_LIMIT | No | Max number of sample rows returned (default: 10) | |
| PROFILE_SAMPLE_SIZE_DEFAULT | No | Default sample size for profile_table (default: 50) | |
| SEARCH_SCHEMA_DEFAULT_LIMIT | No | Default row limit for search_schema pagination (default: 50) | |
| REQUIRE_MUTATION_CONFIRMATION | No | Set to 'false' to skip preview/confirm (default: true) |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
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
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/ConnorBritain/mssql-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server