azure_scan_sql_databases
Scans Azure SQL, PostgreSQL, MySQL databases and Redis caches for security misconfigurations including encryption, firewall, authentication, and public endpoint exposure, reporting critical to medium findings.
Instructions
ENHANCED v1.14.0 Comprehensive database security scanner supporting SQL Server, PostgreSQL, MySQL, and Azure Cache for Redis. Checks: TDE/SSL encryption status, firewall rules (detects 0.0.0.0-255.255.255.255 allow-all), Azure AD authentication vs SQL/password auth, auditing enabled, public endpoint exposure, threat detection, Redis access keys, Redis SSL enforcement. Returns CRITICAL/HIGH/MEDIUM findings with CWE references and attack vectors.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| subscriptionId | Yes | Azure subscription ID | |
| resourceGroup | No | Optional: Filter by specific resource group | |
| includePostgreSQL | No | Include Azure Database for PostgreSQL security analysis. Default: true | |
| includeMySQL | No | Include Azure Database for MySQL security analysis. Default: true | |
| includeRedis | No | Include Azure Cache for Redis security analysis. Default: true | |
| format | No | Output format: 'markdown' (default, human-readable) or 'json' (machine-readable) |