Unless those tables have foreign keys to core discourse tables, which can prevent deletion of data in those tables.
But that problem is not something which can be reliably detected by an other tool. The plugin making those relations should either not create foreign keys, or Discourse needs to provide a way for plugins to register a way to “disarm” them when they disappear from the installation.