Skip to content

v1.5.0: schema doctor (CLI and dashboard Health panel)

Latest

Choose a tag to compare

@albertoarena albertoarena released this 30 Jul 13:25

The schema doctor: a deterministic, structure-only review of your database schema, in the terminal, in CI, and in the dashboard. No AI, no network call, no row data.

Added

  • php artisan truss:doctor (aliased truss:check) reviews your structure for problems visible from structure alone: a table with no primary key, an unindexed foreign key, duplicate or redundant indexes, a foreign key type mismatch, money stored as a float, and more. Thirteen rules across integrity, index, and type categories, presets (recommended, strict, none), per-rule and per-category configuration, ignore patterns, a grouped console table and JSON output, and exit codes so a migration that introduces a problem fails the build. Configured under truss.doctor.
  • Doctor in the dashboard ("Health" panel): the same findings in the browser, grouped by table, with tables flagged on the diagram (by worst severity) and the offending column marked inline. The toggle is an animated heart, the panel maximizes for reading, and heuristic findings are marked. Rides the existing schema endpoint; toggled with truss.doctor.dashboard, and truss.doctor.flag_tables controls the always-on diagram flags.

See the schema doctor guide for presets, confidence, engine awareness, the dashboard panel, and the full list of rule codes.

Full Changelog: v1.4.2...v1.5.0