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

**URL:** <https://aurora4x.com/t/tool-aurora-4x-dashboard-generator-db-reader-with-mineral-viewer-ship-designs-army-tracker/499>\
**Category:** General Discussion\
**Created:** [May 6, 2026, 8:24am UTC](https://aurora4x.com/t/tool-aurora-4x-dashboard-generator-db-reader-with-mineral-viewer-ship-designs-army-tracker/499 "2026-05-06T08:24:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomotomo](https://yyz1.discourse-cdn.com/flex011/user_avatar/aurora4x.com/tomotomo/32/2307_2.png) [@tomotomo](https://aurora4x.com/u/tomotomo)\
**Post date:** [May 6, 2026, 8:24am UTC](https://aurora4x.com/t/tool-aurora-4x-dashboard-generator-db-reader-with-mineral-viewer-ship-designs-army-tracker/499/1 "2026-05-06T08:24:28Z")

</div>

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
- ⛏ 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!

> **[GitHub - tomo9878/aurora4x\_helper](https://github.com/tomo9878/aurora4x_helper)**
>
> Contribute to tomo9878/aurora4x\_helper development by creating an account on GitHub.