SJSINGLE_AI SQL Server MCP

Environment

• MSSQL_PORT

  SQL Server port (default 1433).

• MSSQL_USERrequired

  SQL Server username.

• MSSQL_SERVERrequired

  SQL Server hostname or IP address.

• MCP_HTTP_HOST

  HTTP host for streamable-http transport (default 127.0.0.1).

• MCP_HTTP_PORT

  HTTP port for streamable-http transport (default 8765).

• MCP_TRANSPORT

  Transport mode: stdio or streamable-http (default stdio).

• MSSQL_DATABASErequired

  Default database name (SJSINGLE_AI).

• MSSQL_MAX_ROWS

  Maximum number of rows returned by queries (default 10).

• MSSQL_PASSWORDrequiredsecret

  SQL Server password.

• LANGCHAIN_MODEL

  LangChain model name (default gpt-4o-mini).

• MSSQL_DATABASES

  Comma-separated list of databases for multi-database catalog; defaults to MSSQL_DATABASE.

• MSSQL_ALLOW_WRITE

  Set to 'true' to enable write operations (destructive SQL still blocked).

• AZURE_OPENAI_API_KEYsecret

  Azure OpenAI API key (required for LangChain).

• AZURE_OPENAI_ENDPOINT

  Azure OpenAI endpoint URL (required for LangChain tool).

• LANGCHAIN_INCLUDE_SQL

  Whether to include generated SQL in LangChain response (default false).

• LANGCHAIN_TEMPERATURE

  LangChain temperature (default 0).

• AZURE_OPENAI_DEPLOYMENT

  Azure OpenAI deployment name (required for LangChain).

• AZURE_OPENAI_API_VERSION

  Azure OpenAI API version (default 2024-10-21).

• LANGCHAIN_SCHEMA_TABLE_LIMIT

  Number of tables considered for schema discovery in LangChain (default 30).