Skip to content
h2check
ChecksToolsChecklists
Checks

Databases and migrations

21 procedures covering migration up and down, row counts and checksums after migration, missing indexes, slow query detection, connection pool exhaustion. Out of scope here: database administration, query optimisation at scale, replication setup.

Migrations

  • How to check data integrity after migration12 min
  • How to check database schema version8 min
  • How to compare database schemas10 min
  • How to test database migration12 min
  • How to verify row counts after migration8 min

Data Integrity

  • How to check database integrity10 min
  • How to check duplicate rows in sql7 min
  • How to check foreign key9 min
  • How to test unique constraint8 min
  • How to verify a database backup10 min

Transactions and Connections

  • How to check database locks12 min
  • How to check transaction isolation level12 min
  • How to check transaction rollback8 min
  • How to test connection pool exhaustion12 min

Indexes and Queries

  • How to check if a query uses an index12 min
  • How to check if a table has an index5 min
  • How to check missing indexes12 min
  • How to find slow queries12 min

Schema and Formats

  • How to check database collation9 min
  • How to check table schema6 min
  • How to check timezone stored in database10 min

Checklists

  • Database migration checklist15 checks

Questions people ask about this area

  • how to check a migration is reversible
  • how to check timezone in sql
  • how to check for data corruption
  • show transaction isolation level

h2check.org is published by Maks Verny. Every procedure lists the date its commands were last run.

Checks · Tools · Checklists

Methodology · About · Contact

Checker inputs and results are not stored. What that means in practice is on the methodology page.