sqlserver-semantic-mcp
by LukeStackLab
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SEMANTIC_MCP_CACHE_PATH | No | SQLite cache file location | ./cache/semantic_mcp.db |
| SEMANTIC_MCP_MSSQL_PORT | No | TCP port | 1433 |
| SEMANTIC_MCP_MSSQL_USER | No | SQL auth user (not required when SEMANTIC_MCP_MSSQL_WINDOWS_AUTH=true) | |
| SEMANTIC_MCP_POLICY_FILE | No | Path to policy JSON | |
| SEMANTIC_MCP_MSSQL_SERVER | No | SQL Server host (supports (localdb)\Instance and *.database.windows.net) | |
| SEMANTIC_MCP_STARTUP_MODE | No | cache_first or full | cache_first |
| SEMANTIC_MCP_TOOL_PROFILE | No | Comma-separated tool groups | all |
| SEMANTIC_MCP_CACHE_ENABLED | No | Disable to skip startup warmup | true |
| SEMANTIC_MCP_MSSQL_ENCRYPT | No | Force TLS (auto-enabled for Azure SQL) | false |
| SEMANTIC_MCP_QUERY_TIMEOUT | No | Query timeout in seconds | 30 |
| SEMANTIC_MCP_DEFAULT_DETAIL | No | Default detail tier for agent-facing tools | brief |
| SEMANTIC_MCP_MSSQL_DATABASE | No | Target database name | |
| SEMANTIC_MCP_MSSQL_PASSWORD | No | SQL auth password | |
| SEMANTIC_MCP_POLICY_PROFILE | No | Override which profile is active | |
| SEMANTIC_MCP_INTENT_ANALYZER | No | SQL intent analyzer backend (regex or ast) | regex |
| SEMANTIC_MCP_METRICS_ENABLED | No | Enable per-tool response size metrics | true |
| SEMANTIC_MCP_MAX_ROWS_AFFECTED | No | Override DML affected-row cap | 100 |
| SEMANTIC_MCP_MAX_ROWS_RETURNED | No | Override SELECT row cap | 1000 |
| SEMANTIC_MCP_MSSQL_WINDOWS_AUTH | No | Use Windows Authentication (true/false) | false |
| SEMANTIC_MCP_BACKGROUND_BATCH_SIZE | No | Tables processed per background batch | 5 |
| SEMANTIC_MCP_DEFAULT_RESPONSE_MODE | No | Default query execution response shape | summary |
| SEMANTIC_MCP_BACKGROUND_INTERVAL_MS | No | Delay between batches | 500 |
| SEMANTIC_MCP_DIRECT_EXECUTE_ENABLED | No | Allow workflow fast-path direct execution when policy approves | true |
| SEMANTIC_MCP_WORKFLOW_TOOLS_ENABLED | No | Enable workflow-layer shortcut tools | true |
| SEMANTIC_MCP_STRICT_ROWS_AFFECTED_CAP | No | Roll back writes that exceed affected-row cap by default | true |
| SEMANTIC_MCP_DEFAULT_TOKEN_BUDGET_HINT | No | Default sampling budget for query payloads | low |
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
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/LukeStackLab/sqlserver-semantic-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server