Operations desk

Check tables/columns against naming standards. The result stays on this page.

Recommend column types by data and engine. The result stays on this page.

Schema Documentation Generator. Generate data dictionary from DDL. The result stays on this page.

Foreign Key Relationship Explorer. Visualize foreign key dependencies. The result stays on this page.

Bytes per row by column types and engine. The result stays on this page.

Audit Table Generator. Generate history tables and triggers. The result stays on this page.

Star Schema Designer. Design fact and dimension tables. The result stays on this page.

Slowly Changing Dimension Generator. Generate SCD Type 1/2 logic. The result stays on this page.

Oracle Execution Plan Analyzer. Interpret DBMS_XPLAN output. The result stays on this page.

Choose column order for multi-column indexes. The result stays on this page.

Covering Index Builder. Build covering/INCLUDE indexes. The result stays on this page.

Estimate index size from rows and key columns. The result stays on this page.

Detect non-sargable predicates in queries. The result stays on this page.

Rank queries from pg_stat_statements output. The result stays on this page.

Oracle AWR Report Analyzer. Summarize AWR reports into top issues. The result stays on this page.

Interactive lock compatibility by engine. The result stays on this page.

Simulate dirty/non-repeatable/phantom reads. The result stays on this page.

Tune max_wal_size and checkpoint settings. The result stays on this page.

Generate ProxySQL hostgroups and query rules. The result stays on this page.

Barman Config Generator. Generate Barman server config. The result stays on this page.

Plan backup encryption and key storage. The result stays on this page.

Design primary/replica/multi-site layouts. The result stays on this page.

Generate MariaDB/Percona Galera configs. The result stays on this page.

MySQL InnoDB Cluster Planner. Plan Group Replication and Router. The result stays on this page.