StreamCode Studio - Database and RadioDJ Helper Tools
A full set of diagnostic utilities designed to help users troubleshoot MySQL, MariaDB and RadioDJ systems safely and efficiently.

1. Database Port Checker
Checks whether your MySQL or MariaDB server is reachable. Shows port availability, connection status and useful error information.

2. Charset and Collation Checker
Scans your database for charset and collation inconsistencies. Highlights mismatches and generates safe recommended SQL fixes.

3. MySQL User Permissions Tester
Checks privileges such as SELECT, INSERT, UPDATE, DELETE, CREATE, DROP and ALTER.

4. MySQL Slow Query Tester
Runs SQL queries and measures execution time. Helps identify slow queries and missing indexes.

5. Query Plan Helper
Uses EXPLAIN to analyse query execution and suggest optimisations.

6. RadioDJ Table Validator
Checks a RadioDJ database structure against the expected schema and detects missing tables or mismatches.

7. RadioDJ Rotation Debugger
Detailed information on why a track will or will not play, including date ranges, play limits, separation rules and rotation list results.
Track Search Helper
Quickly search for tracks by Artist, Title or Album and preview results instantly.