Testing & Benchmarking

24 resources — subcategories Testing & Benchmarking

BenchBase

BenchBase

A multi-DBMS SQL benchmarking framework from Carnegie Mellon University, formerly OLTPBench, with MySQL and MariaDB build profiles.

db-branch

db-branch

Self-hosted, copy-on-write database branching for MySQL and PostgreSQL on ZFS clones — give every pull request, migration test, or AI agent its own disposable copy of a large database in seconds.

DBCanvas

A visual canvas for designing a database topology and deploying it as real, disposable Docker nodes — with DNS, TLS, LDAP, replication, monitoring, and backups wired in — for testing, demos, training, and troubleshooting.

dbdeployer

Deploys single, replicated, or Galera MySQL/MariaDB/Percona Server sandboxes locally in seconds, for development and testing — no root access or Docker required.

dbsafe

A read-only command-line tool that performs pre-execution safety analysis on MySQL DDL and DML statements, classifying each as Safe, Caution, or Dangerous before you run it in production.

go-sqlmock

A mock library implementing Go's `sql/driver`, used to simulate database behavior in tests without a real MySQL connection.

go-tpc

go-tpc

A toolbox from PingCAP for running TPC workloads against TiDB, MySQL-compatible databases, and PostgreSQL-compatible databases.

GoSQLX

GoSQLX

A pure-Go SQL parser, formatter, linter, and SQL-injection security scanner with a dedicated MySQL and MariaDB dialect, available as a CLI, Go SDK, VS Code extension, and MCP server.

Greenmask

Greenmask

A utility for logical database dumps, anonymization, and synthetic data generation, production-ready for PostgreSQL with MySQL support in beta.

HammerDB

An open-source database load-testing tool that runs industry-standard TPC-C and TPC-H style benchmarks against MySQL and MariaDB, with a GUI, CLI, and CI-friendly automation.

MariaDB4j

A Java launcher that runs MariaDB from JAR dependencies, without installing it, for tests and development.

mysql_random_data_load

mysql_random_data_load

A command-line tool from Percona Lab that reads a MySQL table's structure and fills it with random rows — for reproducing bugs, seeding test environments, and generating data to benchmark against.

Reladiff

A high-performance tool and library for diffing large datasets across databases, including MySQL, by computing hashes inside the database.

restoredrill

A CLI that proves your PostgreSQL or MySQL backups actually restore: it restores the latest backup into a throwaway Docker container, runs the checks you define, and writes a timestamped JSON evidence report for SOC 2, ISO 27001, or AWS FTR audits.

Scythe

Scythe

A SQL-first code generator that compiles annotated .sql files into type-safe database access code for MySQL, MariaDB, and other engines without needing a live database connection, with built-in formatting, linting, security auditing, and schema-drift detection.

SlowQL

SlowQL

An offline, Rust-built static analyzer for SQL files and application code, with MySQL-aware rules for SQL injection, missing indexes, unbounded queries, and compliance issues, run from the CLI or CI with no database connection.

SOAR

SOAR

A command-line SQL optimizer and rewriter for MySQL-syntax SQL, built on heuristic rules and detailed EXPLAIN interpretation.

SQLancer

SQLancer

An automated testing tool that finds logic and performance bugs in database engines, with dedicated support for MySQL, MariaDB, and TiDB.

SQLFluff

SQLFluff

A modular, open-source SQL linter and auto-formatter with a dedicated MySQL and MariaDB dialect, built to catch style and syntax issues in SQL (including templated SQL used with dbt/Jinja) before it ships.

sysbench

A scriptable, multi-threaded benchmark tool based on LuaJIT — the de facto standard for OLTP-style load testing and CPU/memory/file-IO benchmarking of MySQL servers.

sysbench-tpcc

A set of Lua scripts for sysbench that drives a TPC-C-like OLTP workload against MySQL, used to load-test and compare server configurations under realistic contention.

TAF-Perl

A deterministic, extensible database benchmarking framework in Perl, maintained under the MariaDB Foundation, with repeatable test lifecycles, sysbench and HammerDB clients, and a results backend for baselines and regression detection.

MariaDB Foundation

test_db (Employees Sample Database)

A sample MySQL database with an integrated test suite, used to test applications and database servers.

Testcontainers (MySQL module)

Testcontainers (MySQL module)

An open-source library for spinning up throwaway MySQL and MariaDB instances in Docker containers for integration tests, with official modules for Java, Go, Node.js, and Python.