# dbdiff.yml — DBDiff configuration
#
# This single file configures both the diff command and the migration runner.
# Copy it to dbdiff.yml in your project root and fill in your values.
#
# Auto-detected filenames (in priority order):
# .dbdiff ↠legacy plain-text YAML (no extension, no syntax highlighting)
# dbdiff.yml ↠recommended going forwards
# .dbdiff.yml
# dbdiff.yaml
#
# Command-line flags always override values in this file.
# ─────────────────────────────────────────────────────────────────────────────
# ── Diff command ──────────────────────────────────────────────────────────────
# Used by: ./dbdiff server1.db:server2.db
# server1 / server2 can be the same host — just specify two database names.
server1:
user: user
password: password
port: 3306 # MySQL: 3306 | PostgreSQL: 5432
host: 127.0.0.1
server2:
user: user
password: password
port: 3306
host: 127.0.0.1
driver: mysql # mysql | pgsql | sqlite
type: schema # schema | data | all
include: up # up | down | both
nocomments: false
format: native # native | flyway | liquibase-xml | liquibase-yaml | laravel
# ── Filtering ─────────────────────────────────────────────────────────────────
# All list values support glob patterns: * (any chars), ? (single char).
# Include list — only diff these tables. Omit to diff all tables.
# tables:
# - users
# - orders
# - wp_*
# Exclude list — skip these tables entirely.
# tablesToIgnore:
# - _dbdiff_migrations
# - cache_*
# Exclude from data diff only — schema is still compared.
# tablesDataToIgnore:
# - audit_log
# - event_stream
# Per-table column exclusion (keys support globs).
# fieldsToIgnore:
# users:
# - updated_at
# - last_login
# wp_*:
# - ID
# Per-table row filtering — skip rows matching a column-value regex.
# rowsToIgnore:
# wp_options:
# - { column: option_name, pattern: "_transient_.*" }
# - { column: option_name, pattern: "_site_transient_.*" }
# sessions:
# - { column: status, pattern: "expired|archived" }
# Per-table scope override: schema, data, or all (default).
# tableScope:
# audit_log: schema
# config: data
# ── PHP memory limit ──────────────────────────────────────────────────────────
# The CLI entry point (dbdiff / dbdiff.php / PHAR) sets a default of 1G, which
# is sufficient for most databases. Raise it here if you're diffing very large
# schemas or data sets, or lower it in resource-constrained environments.
# Accepts any PHP shorthand: 512M, 1G, 2G, -1 (unlimited), etc.
# Override on the fly with --memory-limit=