mssql_health_check
Monitor Microsoft SQL Server health and connectivity while collecting performance metrics to identify database issues and ensure operational stability.
Instructions
Check database server health and connectivity with performance metrics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| encrypt | No | Use encrypted connection (default: true) | |
| includeMetrics | No | Include performance metrics (default: true) | |
| password | Yes | Password for authentication | |
| port | No | Port number (default: 1433) | |
| server | Yes | MSSQL Server hostname or IP address | |
| trustServerCertificate | No | Trust server certificate (default: true) | |
| user | Yes | Username for authentication |
Input Schema (JSON Schema)
{
"properties": {
"encrypt": {
"default": true,
"description": "Use encrypted connection (default: true)",
"type": "boolean"
},
"includeMetrics": {
"default": true,
"description": "Include performance metrics (default: true)",
"type": "boolean"
},
"password": {
"description": "Password for authentication",
"type": "string"
},
"port": {
"default": 1433,
"description": "Port number (default: 1433)",
"type": "number"
},
"server": {
"description": "MSSQL Server hostname or IP address",
"type": "string"
},
"trustServerCertificate": {
"default": true,
"description": "Trust server certificate (default: true)",
"type": "boolean"
},
"user": {
"description": "Username for authentication",
"type": "string"
}
},
"required": [
"server",
"user",
"password"
],
"type": "object"
}