I wrote a small application which helps me (and maybe you) playing Aurora 4x C# by automating some repeating checks I always did manually.
It opens the Aurora DB read only and checks for:
- Damaged ships
- Ships with low crew morale
- Unused construction factories
- Unused ordnance factories
- Ships which are marked as obsolete
- Unused terraformers
- Ships with armour damage
- Own wrecks
- Shipyards which are tooled for obsolete ships
- Ships without MSP
- Admin commands without commanders
- CMC mines from which I buy minerals but have no mass driver destination set
- Populations with low manufacturing efficiency modifier
- Fully trained ships in training fleets
- Own life pods
- Populations without a governor set
- Ships with open fire FCs
Here some example screenshots:


It also has a view on the own ships and own populations database tables (read only of course):

There is also a possibility to save ship designs in a separate database:

And to save some notes in the separate database:

Every time the Aurora database is saved the data is automatically reload and it also paints some graphs for resources, fuel, maintenance supplies, population and wealth (graphs are painted as soon as three saved games are read).
Everything is saved in the separate database. Example for resources:

Time axis for those graphs are in game seconds since the game start and the graphs are created for the total amount of resources/fuel/MSPs and not per population.
And last the application tries to visualize the tech tree:

Conventional starting tech is in light green, trans newtonian starting tech ins coloured in dark green.
If you like to try the application, the binaries are available here:
https://gitlab.com/Scnaeg/auroramarvin/-/jobs/artifacts/v2.1.0.1/download?job=buildChecksum:
SHA512 (artifacts.zip) = 16077e17a98a766d3b8794f3cfac341b6e58d57fe45d6ea106bf65d10314cbc3a8539427e1872de4768de6654b97f2ed4bbb46b370a6f073618396efb996b19fTo install AuroraMarvin please unzip the application into a dedicated folder (and not in your existing Aurora 4x folder) and run the AuroraMarvin. exe.
To upgrade AuroraMarvin please unzip the new version into a dedicated folder and copy AuroraMarvin.db from the old installation into the new one. Once the database is copied run AuroraMarvin.exe.
If you like to compile the application by yourself (or submit a patch

) the source code is available here:
https://gitlab.com/Scnaeg/auroramarvinThe application has been approved by Steve as it opens the Aurora DB in read only mode.