[Tool] Aurora 4x Dashboard Generator — DB reader with mineral viewer, ship designs & army tracker

General Discussion
1

Hi all,

I’ve been working on a small Python tool that reads directly from AuroraDB.db and generates HTML dashboards and game logs. Sharing it here in case anyone finds it useful.

What it does

aurora_reader.py — Main dashboard generator
Double-click the .bat file (or run via CLI) and it outputs:

  • aurora_dashboard.html — A tabbed HTML dashboard with:
    • EMPIRE tab: Wealth, Research Cap, active ships, fleets, colonies, mineral stockpile (with +/− change indicators vs. last run), shipyard tasks, ship list
    • SYSTEMS tab: Discovered systems with gravity/geo survey status, JP passage status, and top-3 minerals per system (geo-surveyed bodies only — no spoilers!)
    • ARMY tab: Ground force formations with expandable unit details (base type, class, count, armour/weapon ratings, capabilities)
    • DESIGNS tab: Your custom ship classes (player-designed only) with engines, weapons, sensors, and special equipment tagged by color. Obsolete classes hidden by default.
  • aurora_gamelog.txt — Full cumulative log (for reading back and enjoying)
  • aurora_gamelog_diff.txt — New events since last run only (handy for pasting into an AI to generate AARs)

aurora_minerals.py — Mineral resource viewer
Separate tool that outputs aurora_minerals.html:

  • All geo-surveyed bodies listed with mineral amounts and accessibility
  • Click any column header to sort
  • :pick: icon marks bodies eligible for orbital mining based on your current tech (Maximum Orbital Mining Diameter)
  • Filter by star system
  • Input number of automated mines → click Calculate to replace accessibility values with estimated annual yield
  • Reset button to restore original values

Requirements

  • Python 3.x (standard library only — no pip installs needed)
  • Place scripts in the same folder as AuroraDB.db, or pass the path as an argument
  • Run aurora_reader.bat to generate both the dashboard and mineral viewer in one click

A few design notes:

  • Mineral change indicators (+ / −) are calculated by comparing against a snapshot saved on the previous run, so the delta reflects however much time has passed between sessions.
  • The SYSTEMS tab only shows mineral totals for geo-surveyed bodies, and hides JP counts until gravity survey is complete — to avoid spoiling unexplored systems.
  • The DESIGNS tab filters out auto-generated civilian ships and only shows classes you designed yourself.

The tool is still a work in progress. Feedback welcome!

5 Likes