Support Multiple Authentication Methods and Multi-Database Connections

未关闭

#79 创建于 2025年10月17日 0 条评论 6 个 reaction 已指派 0 人在 GitHub 查看

还没有人认领这个 Issue。

评估

难度: 5/5
预计耗时: 一周以上
新手友好度: 25/100

Issue 类型: 功能
描述清晰度: 需要澄清
活跃度: 停滞
技术栈: azure, sql
领域: authentication, databases

调研方向

该 issue 未指定任何文件、测试或入口点。首先定位 server 的身份验证配置和数据库连接设置，然后定义所列环境变量如何选择凭据，以及如何配置多个连接；当所请求的身份验证方法和同时进行的数据库连接能够协同工作时，即视为完成。

由索引模型根据 Issue 内容生成。

描述

Problem Statement

Currently, the MCP server only supports a single authentication method at a time (either Azure AD or SQL Authentication), and
can only connect to one database per server instance.

Proposed Enhancements

Support Multiple Authentication Methods
The server should automatically detect and use the appropriate authentication method based on environment variables:

Azure AD Interactive Browser: If AZURE_AUTH_METHOD=interactive is set
Azure AD Default Credential: If AZURE_AUTH_METHOD=default is set (for managed identities, service principals)
Azure AD Service Principal: If AZURE_TENANT_ID, AZURE_CLIENT_ID, AZURE_CLIENT_SECRET are set
SQL Authentication: If SQL_USER and SQL_PASSWORD are set
Windows Authentication: If WINDOWS_AUTH=true is set

Support Multiple Database Connections
Allow configuring multiple SQL Server instances/databases simultaneously, enabling users to:

Query across different databases
Work with multiple Azure SQL servers
Connect to both on-premises and cloud databases

Use Cases

Development vs Production: Use different auth methods for local dev (SQL auth) vs Azure (Managed Identity)
Multi-tenant applications: Connect to multiple customer databases
Data migration/comparison: Query data across different SQL servers

主要语言: HTML
星标: 331
派生: 208
PR 合并指标: 30 天内没有已合并 PR