MySQL / MariaDB

MySQL / MariaDB Tools

25 professional tools for mysqldump, replication, grants, InnoDB locks, JSON queries, and MySQL DBA administration.

MySQL

MySQL Backup Command Generator

Generate full and incremental MySQL/MariaDB backup shell commands

MySQL

MySQL Restore Command Generator

Generate mysql restore workflows from SQL dump files

MySQL

mysqldump Command Generator

Build mysqldump commands with options, tables, and compression

MySQL

MySQL Connection String Builder

Build MySQL/MariaDB URIs, JDBC, and Node.js connection strings

MySQL

MySQL User Creation Command

Generate CREATE USER statements for MySQL and MariaDB

MySQL

MySQL Grant Command Generator

Generate GRANT statements for databases, tables, and privileges

MySQL

MySQL Revoke Command Generator

Generate REVOKE statements to remove MySQL privileges

MySQL

MySQL Table Size Query

Generate queries to list table and index sizes in MySQL

MySQL

MySQL Database Size Query

Generate queries for database size monitoring in MySQL

MySQL

MySQL Processlist Analyzer

Parse SHOW PROCESSLIST output and summarize running queries

MySQL

MySQL Slow Query Analyzer

Analyze slow query log output and summarize expensive queries

MySQL

MySQL Index Suggestion Helper

Suggest indexes based on WHERE, JOIN, and ORDER BY columns

MySQL

MySQL Charset Checker

Generate queries to audit character sets across databases and tables

MySQL

MySQL Collation Checker

Generate queries to detect collation mismatches and issues

MySQL

MySQL Replication Status Parser

Parse SHOW SLAVE/REPLICA STATUS and summarize replication health

MySQL

MySQL Binlog Calculator

Estimate binary log disk usage and retention requirements

MySQL

MySQL Config Checker

Review my.cnf settings and InnoDB tuning recommendations

MySQL

MySQL Port Checker

Generate commands to verify MySQL port and connectivity

MySQL

MySQL SSL Connection Helper

Generate SSL connection strings and verify TLS for MySQL

MySQL

MySQL Query Formatter

Format and beautify MySQL/MariaDB SQL queries

MySQL

MySQL Date Query Helper

Generate date, interval, and timezone queries for MySQL

MySQL

MySQL JSON Query Helper

Generate JSON functions and path queries for MySQL 5.7+

MySQL

MySQL Lock Query Generator

Generate queries to find InnoDB locks and blocking transactions

MySQL

MySQL Upgrade Checklist

Step-by-step checklist for MySQL/MariaDB version upgrades

MySQL

MySQL DBA Report Generator

Generate a MySQL/MariaDB health and configuration audit report