Helper Tools

Tests MySQL/MariaDB connectivity, verifies database credentials, checks port accessibility, and detects firewall or hosting restrictions that may block external connections.

Checks which SQL permissions a MySQL user has (SELECT, INSERT, UPDATE, DELETE, etc) and highlights missing or risky privileges that may prevent RadioDJ tools or scripts from functioning correctly.

Scans database tables and columns for mixed or incorrect character sets and collations, highlighting issues that can break metadata, searches, or request systems, and suggests corrective actions.

Verifies database structure by checking required tables, missing or incorrect columns, data types, and flags potential corruption or schema inconsistencies.

Analyses MySQL EXPLAIN output to show how queries are executed and suggests index improvements to speed up searches and reduce full table scans.

Identifies slow-running SQL queries and provides execution timing and profiling data to help optimise database performance and reduce load.