MySQL & MariaDB Rules | BeforeMerge

Pricing Blog Contributors Install Guide

Explore
MySQL & MariaDB

MySQL & MariaDB

v1.0.0

Lint MySQL and MariaDB schemas, queries, and migrations for performance, security, and best practices.

4 rules

2 categories

Performance(3)

Use Online DDL for ALTER TABLE

ALTER TABLE in MySQL can lock the entire table. Use ALGORITHM=INPLACE or tools like gh-ost for safe migrations.

Online DDLMySQLMigration Safety

Architecture(1)

Use utf8mb4 Instead of utf8

MySQL's utf8 charset only supports 3-byte characters. Use utf8mb4 for full Unicode support.

MySQLSchema DesignMariaDB

Automate MySQL & MariaDB checks on every PR

BeforeMerge scans your pull requests against all 4 MySQL & MariaDB rules automatically. Get actionable feedback before code ships.

Join Waitlist Browse All Rules

AI-native code review knowledge base. Structured rules that catch what linters miss.

Product

Features
Explore
Pricing
Docs
GitHub

Company

About
Blog
Contributors
Contributing

Legal

Privacy Policy
Terms of Service
MIT License

© 2026 BeforeMerge. Built by

Index All Foreign Key Columns

Unlike PostgreSQL, MySQL/InnoDB requires indexes on foreign key columns. Missing indexes cause slow JOINs.

MySQLMariaDBDB Linting

HIGH

Avoid SELECT * in Production Queries

SELECT * fetches all columns, wasting bandwidth and preventing covering index optimization.

MySQLQuery Optimization

Features Explore

Rules Skills Knowledge Prompts

Pricing Blog Contributors Install Guide

MySQL & MariaDB Linting

Review skill for MySQL and MariaDB databases covering schema design, query optimization, migration safety, and security hardening.

Tools Covered

SQLFluff — SQL linting and formatting (MySQL dialect)
Squawk — Migration safety analysis
pt-query-digest — Query performance analysis (Percona Toolkit)
mysqlcheck — Table integrity verification
gh-ost / pt-online-schema-change — Safe online DDL
SchemaHero — Declarative schema management

Applicable Platforms

MySQL 8.x
MariaDB 10.x / 11.x
Amazon RDS for MySQL / Aurora MySQL
Google Cloud SQL for MySQL
Azure Database for MySQL
PlanetScale
TiDB