sql-mcp
by ohankay
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SQL_MCP_AUTH | No | Authentication mode: 'sql' or 'windows'. Defaults to 'sql' when a user is set, otherwise 'windows'. | sql if SQL_MCP_USER is set, otherwise windows |
| SQL_MCP_NAME | No | Name of the environment-based profile. | default |
| SQL_MCP_PORT | No | Separate port for the SQL Server. | |
| SQL_MCP_USER | No | SQL login username (used for SQL authentication). | |
| SQL_MCP_EXTRA | No | Raw connection string additions, e.g. 'MultiSubnetFailover=yes;ApplicationIntent=ReadOnly'. | |
| SQL_MCP_CONFIG | No | Path to a multi-profile JSON configuration file (e.g. connections.json) for defining multiple named connections. | |
| SQL_MCP_DRIVER | No | Driver selection: 'auto', 'pyodbc', or 'mssql-python'. | auto |
| SQL_MCP_SERVER | No | SQL Server address; host, host\INSTANCE, or host,port. Required for single-profile environment configuration. | |
| SQL_MCP_ENCRYPT | No | Encryption mode: 'yes', 'no', or 'strict'. | yes |
| SQL_MCP_APP_NAME | No | Application name shown in sys.dm_exec_sessions.program_name. | sql-mcp |
| SQL_MCP_DATABASE | No | Initial database to connect to. | master |
| SQL_MCP_MAX_ROWS | No | Maximum rows returned per result set. | 1000 |
| SQL_MCP_PASSWORD | No | SQL login password (used for SQL authentication). | |
| SQL_MCP_READONLY | No | When true, blocks write commands (INSERT/UPDATE/DELETE/DDL, EXEC, BACKUP, KILL, job changes, etc.). | false |
| SQL_MCP_ODBC_DRIVER | No | Explicit ODBC driver name, e.g. 'ODBC Driver 17 for SQL Server'. | newest available |
| SQL_MCP_LOGIN_TIMEOUT | No | Login timeout in seconds. | 15 |
| SQL_MCP_QUERY_TIMEOUT | No | Query timeout in seconds (0 = unlimited); can be overridden per tool call with timeout_seconds. | 300 |
| SQL_MCP_TRUST_SERVER_CERTIFICATE | No | Trust the server certificate (useful for internal self-signed certificates). | true |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
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 | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues