MCP SQL Server

# ================================= # MCP MSSQL Server Environment Configuration # ================================= # 🔧 Required Settings - Just modify these! # DB_TYPE = mssql # Currently only mssql is supported DB_SERVER=localhost DB_PORT=1433 DB_DATABASE=your_database_name DB_USER=your_username DB_PASSWORD=your_password # 🔒 Security Settings (for local development) DB_ENCRYPT=false DB_TRUST_SERVER_CERTIFICATE=true # ⚡ Performance Settings (recommended to use defaults) DB_CONNECTION_TIMEOUT=30000 DB_REQUEST_TIMEOUT=30000 DB_POOL_MIN=2 DB_POOL_MAX=10 DB_POOL_IDLE_TIMEOUT=30000 # 📋 Logging Settings (optional) NODE_ENV=development LOG_LEVEL=info # ================================= # 💡 Configuration Guide # ================================= # 1. Copy this file to .env: # copy env.example .env # # 2. Modify the database information above with actual values # # 3. If SQL Server is on local machine: # - DB_SERVER=localhost # - DB_PORT=1433 (default) # - DB_USER=sa (admin account) # # 4. Test connection: # npm run test:db # # 5. For security, don't upload .env file to Git! # ================================= # 🚨 Common Configuration Examples # ================================= # SQL Server Express (default installation) # DB_SERVER=localhost\SQLEXPRESS # DB_DATABASE=master # DB_USER=sa # DB_PASSWORD=YourPassword123 # Azure SQL Database # DB_SERVER=yourserver.database.windows.net # DB_DATABASE=yourdatabase # DB_USER=yourusername # DB_PASSWORD=yourpassword # DB_ENCRYPT=true # DB_TRUST_SERVER_CERTIFICATE=false