MSSQL MCP Server

# ==================================== # MSSQL MCP Server Configuration # ==================================== # Copy this file to .env and update with your settings # 複製此檔案為 .env 並更新您的設定 # ==================================== # Database Connection Settings # 資料庫連接設定 # ==================================== MSSQL_SERVER=localhost MSSQL_PORT=1433 MSSQL_USER=sa MSSQL_PASSWORD=your_password_here MSSQL_DATABASE=master MSSQL_ENCRYPT=true MSSQL_TRUST_SERVER_CERTIFICATE=false # ==================================== # Permission Settings # 權限設定 # ==================================== # These settings control which SQL operations are allowed # 這些設定控制允許的 SQL 操作 # Allow INSERT operations (default: false) # 允許 INSERT 操作（預設：false） MSSQL_ALLOW_INSERT=false # Allow UPDATE operations (default: false) # 允許 UPDATE 操作（預設：false） MSSQL_ALLOW_UPDATE=false # Allow DELETE operations (default: false) # 允許 DELETE 操作（預設：false） MSSQL_ALLOW_DELETE=false # ==================================== # DANGER MODE - USE WITH EXTREME CAUTION! # 危險模式 - 請極度謹慎使用！ # ==================================== # When enabled, allows ALL SQL operations including: # - DROP, TRUNCATE, ALTER, CREATE # - GRANT, REVOKE, DENY # - EXECUTE stored procedures # - BACKUP, RESTORE # # 啟用時，允許所有 SQL 操作，包括： # - DROP、TRUNCATE、ALTER、CREATE # - GRANT、REVOKE、DENY # - 執行預存程序 # - 備份、還原 # # WARNING: This can permanently destroy data! # 警告：這可能會永久性地破壞資料！ MSSQL_DANGER_MODE=false # ==================================== # Query Limits # 查詢限制 # ==================================== # Maximum number of rows to return in a single query # 單一查詢返回的最大筆數 MSSQL_MAX_ROWS=100 # Query timeout in milliseconds (default: 30000 = 30 seconds) # 查詢超時時間（毫秒）（預設：30000 = 30 秒） MSSQL_QUERY_TIMEOUT=30000 # ==================================== # Logging Settings # 日誌設定 # ==================================== # Log level: error, warn, info, debug # 日誌等級：error、warn、info、debug LOG_LEVEL=info # Enable query logging (logs all executed queries to stderr) # 啟用查詢日誌（將所有執行的查詢記錄到 stderr） LOG_QUERIES=false # ==================================== # Security Settings # 安全設定 # ==================================== # Enable SSL/TLS for database connection # 啟用資料庫連接的 SSL/TLS MSSQL_ENCRYPT=true # Trust server certificate without validation (development only) # 信任伺服器憑證而不進行驗證（僅限開發環境） MSSQL_TRUST_SERVER_CERTIFICATE=false # ==================================== # Example Configurations # 範例配置 # ==================================== # === Read-only mode (safest) === # === 唯讀模式（最安全）=== # MSSQL_ALLOW_INSERT=false # MSSQL_ALLOW_UPDATE=false # MSSQL_ALLOW_DELETE=false # MSSQL_DANGER_MODE=false # === Basic write operations === # === 基本寫入操作 === # MSSQL_ALLOW_INSERT=true # MSSQL_ALLOW_UPDATE=true # MSSQL_ALLOW_DELETE=false # MSSQL_DANGER_MODE=false # === Full DML operations (no DDL) === # === 完整 DML 操作（無 DDL）=== # MSSQL_ALLOW_INSERT=true # MSSQL_ALLOW_UPDATE=true # MSSQL_ALLOW_DELETE=true # MSSQL_DANGER_MODE=false # === Development mode (all operations) === # === 開發模式（所有操作）=== # MSSQL_ALLOW_INSERT=true # MSSQL_ALLOW_UPDATE=true # MSSQL_ALLOW_DELETE=true # MSSQL_DANGER_MODE=true # ==================================== # Notes # 注意事項 # ==================================== # 1. Never use DANGER_MODE in production # 永遠不要在生產環境中使用 DANGER_MODE # # 2. Always use the principle of least privilege # 始終使用最小權限原則 # # 3. Consider using read-only database users when possible # 盡可能使用唯讀資料庫使用者 # # 4. Regularly review and audit permission settings # 定期檢查和審核權限設定