Spotting missing indexes for MariaDB & MySQL

missing_indexes.sql

SELECT 
  t.TABLE_SCHEMA, 
  t.TABLE_NAME, 
  c.COLUMN_NAME, 
  IFNULL(
    kcu.CONSTRAINT_NAME, 'Not indexed'
  ) AS `Index` 
FROM 
  information_schema.TABLES t 
  INNER JOIN information_schema.`COLUMNS` c ON c.TABLE_SCHEMA = t.TABLE_SCHEMA 
  AND c.TABLE_NAME = t.TABLE_NAME 
  AND c.COLUMN_NAME LIKE '%Id' 
  LEFT JOIN information_schema.`KEY_COLUMN_USAGE` kcu ON kcu.TABLE_SCHEMA = t.TABLE_SCHEMA 
  AND kcu.TABLE_NAME = t.TABLE_NAME 
  AND kcu.COLUMN_NAME = c.COLUMN_NAME 
  AND kcu.ORDINAL_POSITION = 1 
WHERE 
  kcu.TABLE_SCHEMA IS NULL 
  AND t.TABLE_SCHEMA NOT IN (
    'information_schema', 'performance_schema', 
    'mysql'
  );