MSSQL MCP Server

# MSSQL MCP Server Configuration Example # Copy this file to .env and update with your values # Required: Database name MSSQL_DATABASE=your_database_name # Server connection (default: localhost) MSSQL_SERVER=your_server_hostname # MSSQL_HOST=your_server_hostname # Alternative to MSSQL_SERVER # Port (default: 1433) # MSSQL_PORT=1433 # Authentication method # For Windows Authentication (default: no) # MSSQL_TRUSTED_CONNECTION=yes # For SQL Authentication (required if TRUSTED_CONNECTION is no) # MSSQL_USER=your_username # MSSQL_PASSWORD=your_password # ODBC Driver (default: ODBC Driver 17 for SQL Server) # MSSQL_DRIVER=ODBC Driver 17 for SQL Server # Security settings # MSSQL_TRUST_SERVER_CERTIFICATE=yes # Set to 'no' for production # MSSQL_ENCRYPT=yes # Connection settings # MSSQL_CONNECTION_TIMEOUT=30 # seconds # MSSQL_MULTI_SUBNET_FAILOVER=no # Example configurations: # 1. Azure SQL Database # MSSQL_SERVER=myserver.database.windows.net # MSSQL_DATABASE=mydatabase # MSSQL_USER=myuser@myserver # MSSQL_PASSWORD=mypassword # MSSQL_ENCRYPT=yes # MSSQL_TRUST_SERVER_CERTIFICATE=no # 2. Local SQL Server with Windows Auth # MSSQL_SERVER=localhost # MSSQL_DATABASE=mydatabase # MSSQL_TRUSTED_CONNECTION=yes # 3. SQL Server with SQL Auth # MSSQL_SERVER=sqlserver.company.local # MSSQL_DATABASE=mydatabase # MSSQL_USER=sa # MSSQL_PASSWORD=mypassword