I built a CLI tool that scans your Metabase instance to find which SQL questions reference a column or table you're about to drop/rename.
metabase-impact --metabase-url http://localhost:3000 --api-key "mb_xxx" --drop-column orders.user_id
It outputs affected questions with direct links so you can fix or archive them before deploying.
Built this after breaking dashboards one too many times. Uses sqlglot for SQL parsing (handles aliases and complex queries). Only works on native SQL questions, not MBQL/GUI queries.