mcp-sql
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCPSQL_HOST | No | Database server host. | |
| MCPSQL_PORT | No | Database server port. | |
| MCPSQL_DB_TYPE | No | Engine type (e.g., mssql). | |
| AZURE_CLIENT_ID | No | Azure client ID for service principal auth. | |
| AZURE_TENANT_ID | No | Azure tenant ID for service principal auth. | |
| MCPSQL_DATABASE | No | Database name. | |
| MCPSQL_MAX_ROWS | No | Row cap for queries (default 1000). | 1000 |
| MCPSQL_PASSWORD | No | SQL Server login password (for sql_password auth). | |
| MCPSQL_USERNAME | No | SQL Server login username (for sql_password auth). | |
| MCPSQL_AUTH_METHOD | No | Authentication method (sql_password, windows, azure_ad). | |
| MCPSQL_CONNECTIONS | No | JSON mapping of connection names to ODBC strings (for map backend). | |
| MCPSQL_ODBC_DRIVER | No | ODBC driver name (default 'ODBC Driver 18 for SQL Server'). | ODBC Driver 18 for SQL Server |
| AZURE_CLIENT_SECRET | No | Azure client secret for service principal auth. | |
| MCPSQL_KEYVAULT_URL | No | Azure Key Vault URL for resolving connections (for keyvault backend). | |
| MCPSQL_AZURE_AUTH_MODE | No | Azure AD token acquisition mode (default, service_principal, managed_identity). | |
| MCPSQL_CONNECTION_BACKEND | No | Connection backend: static, map, keyvault. | static |
| MCPSQL_CONNECTION_ALLOWLIST | No | Comma-separated list of allowed connection names. | |
| MCPSQL_CONNECTION_CACHE_TTL | No | Cache TTL for resolved connections in seconds. |
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/benamaraissam/mcp-sql'
If you have feedback or need assistance with the MCP directory API, please join our Discord server