Testing & Benchmarking
24 resources — subcategories Testing & Benchmarking

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

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
A toolbox from PingCAP for running TPC workloads against TiDB, MySQL-compatible databases, and PostgreSQL-compatible databases.

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
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
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
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
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
A command-line SQL optimizer and rewriter for MySQL-syntax SQL, built on heuristic rules and detailed EXPLAIN interpretation.

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

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.
test_db (Employees Sample Database)
A sample MySQL database with an integrated test suite, used to test applications and database servers.
