mcp-sql

Environment

• MCPSQL_HOST

  Database server host.

• MCPSQL_PORT

  Database server port.

• MCPSQL_DB_TYPE

  Engine type (e.g., mssql).

• AZURE_CLIENT_ID

  Azure client ID for service principal auth.

• AZURE_TENANT_ID

  Azure tenant ID for service principal auth.

• MCPSQL_DATABASE

  Database name.

• MCPSQL_MAX_ROWS

  Row cap for queries (default 1000).

• MCPSQL_PASSWORDsecret

  SQL Server login password (for sql_password auth).

• MCPSQL_USERNAME

  SQL Server login username (for sql_password auth).

• MCPSQL_AUTH_METHOD

  Authentication method (sql_password, windows, azure_ad).

• MCPSQL_CONNECTIONS

  JSON mapping of connection names to ODBC strings (for map backend).

• MCPSQL_ODBC_DRIVER

  ODBC driver name (default 'ODBC Driver 18 for SQL Server').

• AZURE_CLIENT_SECRETsecret

  Azure client secret for service principal auth.

• MCPSQL_KEYVAULT_URLsecret

  Azure Key Vault URL for resolving connections (for keyvault backend).

• MCPSQL_AZURE_AUTH_MODE

  Azure AD token acquisition mode (default, service_principal, managed_identity).

• MCPSQL_CONNECTION_BACKEND

  Connection backend: static, map, keyvault.

• MCPSQL_CONNECTION_ALLOWLIST

  Comma-separated list of allowed connection names.

• MCPSQL_CONNECTION_CACHE_TTL

  Cache TTL for resolved connections in seconds.