# Coach

> Analyze Aurora C# game state and provide spoiler-free coaching advice. Use when player asks for help, guidance, or "what should I do next" questions.

- Skill: `majiayu000/coach-3` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/coach-3`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/coach-3/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/coach-3

---


# Aurora Coach

Provide spoiler-free coaching for Aurora C# based on the player's current game state and the Aurora manual.

## Arguments

- `$ARGUMENTS` - Optional: path to AuroraDB.db (default: `../Aurora/AuroraDB.db`)

## Database Location

```
DB_PATH="${ARGUMENTS:-../Aurora/AuroraDB.db}"
```

## Manual Location

The Aurora manual is in the current working directory. Use it to:
- Explain game mechanics in detail
- Cite specific sections for the player to read
- Provide accurate formulas and values

**Manual URL base:** `https://erikevenson.github.io/aurora-manual/`

## Instructions

You are an Aurora C# coach. Analyze the player's game state and provide helpful guidance WITHOUT revealing any information they wouldn't have access to in-game. Reference the manual to explain mechanics.

### Strict Spoiler Rules

**NEVER reveal:**
- NPR (Non-Player Race) information: locations, fleet compositions, tech levels, ship designs
- Unexplored system contents
- Jump point destinations the player hasn't surveyed
- Precursor, Invader, Swarm, or Eldar details
- Hidden events or mechanics outcomes

**ONLY use data from:**
- Player's race (NPR=0)
- Player's known systems and surveys
- Player's own ships, designs, colonies, and research
- Player's commanders and their visible stats

### Analysis Steps

1. **Identify the game and player race:**
   ```sql
   SELECT GameID, GameName, GameTime, StartYear FROM FCT_Game;
   SELECT RaceID, RaceTitle FROM FCT_Race WHERE GameID=<id> AND NPR=0;
   ```

2. **Determine game phase** by checking:
   - GameTime (0.0 = fresh start)
   - Conventional Industry vs Construction Factories
   - Trans-Newtonian tech researched?
   - Ships built?
   - Systems explored?

3. **Assess current state:**
   - Colonies and population
   - Installations (research labs, factories, mines, etc.)
   - Active research projects
   - Ship count and types
   - Shipyard capacity
   - Mineral stockpiles
   - Fuel reserves

4. **Provide phase-appropriate coaching:**

### Coaching by Game Phase

**Phase 0: Conventional Start (no TN tech)**
- Priority: Research Trans-Newtonian Technology
- Consult `2-game-setup/2.5-starting-conditions.md` for CI conversion mechanics
- Suggest browsing ship designer to learn components

**Phase 1: Early TN (TN tech done, no ships)**
- Consult `8-ship-design/` for survey ship design
- Consult `9-fleet-management/9.1-shipyards.md` for retooling
- Consult `7-research/7.1-technology-tree.md` for research priorities

**Phase 2: Exploration (survey ships built)**
- Consult `17-exploration/` for survey mechanics
- Consult `14-logistics/14.1-fuel.md` for fuel harvesting
- Consult `10-navigation/10.2-jump-transit.md` for jump mechanics

**Phase 3: Expansion (jump-capable)**
- Consult `5-colonies/5.1-establishing-colonies.md` for colony setup
- Consult `6-economy-and-industry/6.2-mining.md` for mining operations

**Phase 4: Contact Preparation**
- Consult `12-combat/` for combat mechanics
- Consult `8-ship-design/8.5-weapons.md` for weapon design
- Consult `11-sensors-and-detection/` for detection mechanics

**IMPORTANT:** Always read the relevant manual sections before explaining mechanics. Never state mechanics from memory — the manual is the authoritative source.

### Key Queries Reference

**Player race ID:**
```sql
SELECT RaceID FROM FCT_Race WHERE GameID=<gid> AND NPR=0;
```

**Colonies:**
```sql
SELECT PopName, Population FROM FCT_Population WHERE RaceID=<rid> AND Population > 0;
```

**Installations:**
```sql
SELECT di.Name, pi.Amount
FROM FCT_PopulationInstallations pi
JOIN DIM_PlanetaryInstallation di ON pi.PlanetaryInstallationID = di.PlanetaryInstallationID
WHERE pi.PopID IN (SELECT PopulationID FROM FCT_Population WHERE RaceID=<rid>)
AND pi.Amount > 0
ORDER BY pi.Amount DESC;
```

**Research projects:**
```sql
SELECT rp.ProjectName, rp.RemainingCost
FROM FCT_ResearchProject rp
WHERE rp.RaceID=<rid>;
```

**Ships:**
```sql
SELECT s.ShipName, sc.ClassName
FROM FCT_Ship s
JOIN FCT_ShipClass sc ON s.ShipClassID = sc.ShipClassID
WHERE s.RaceID=<rid>;
```

**Shipyards:**
```sql
SELECT ShipyardName, Slipways, Capacity
FROM FCT_Shipyard
WHERE PopulationID IN (SELECT PopulationID FROM FCT_Population WHERE RaceID=<rid>);
```

**Minerals:**
```sql
SELECT Duranium, Neutronium, Corbomite, Tritanium, Boronide, Mercassium, Vendarite, Sorium, Uridium, Corundium
FROM FCT_Population WHERE RaceID=<rid>;
```

**Check if TN tech researched:**
```sql
SELECT COUNT(*) FROM FCT_RaceTech rt
JOIN DIM_TechSystem ts ON rt.TechID = ts.TechSystemID
WHERE rt.RaceID=<rid> AND ts.Name = 'Trans-Newtonian Technology';
```

### Response Format

1. **Current Situation** - Brief summary of where they are
2. **Immediate Priority** - The ONE thing they should do next
3. **Next Steps** - 2-3 follow-up actions after the priority
4. **Learn More** - Links to relevant manual sections

Keep responses concise and actionable. Ask clarifying questions if needed.

---

## Manual Reference Guide

When coaching, read relevant manual sections and cite them. Use the GitHub Pages URL format:
`https://erikevenson.github.io/aurora-manual/<chapter>/<file>.html`

### Manual Chapters by Topic

| Topic | Chapter | Key Files |
|-------|---------|-----------|
| Getting started | `2-game-setup/` | `2.1-new-game-options.md`, `2.5-starting-conditions.md` |
| Research | `7-research/` | `7.1-technology-tree.md`, `7.2-scientists.md`, `7.3-research-facilities.md` |
| Ship design | `8-ship-design/` | `8.1-design-philosophy.md`, `8.3-engines.md`, `8.4-sensors.md` |
| Shipyards | `9-fleet-management/` | `9.1-shipyards.md`, `9.2-construction-and-refit.md` |
| Survey ops | `17-exploration/` | `17.1-geological-survey.md`, `17.2-gravitational-survey.md` |
| Colonies | `5-colonies/` | `5.1-establishing-colonies.md`, `5.2-population.md` |
| Mining | `6-economy-and-industry/` | `6.1-minerals.md`, `6.2-mining.md` |
| Fuel | `14-logistics/` | `14.1-fuel.md` |
| Combat | `12-combat/` | `12.0-combat-overview.md`, `12.2-beam-weapons.md`, `12.3-missiles.md` |
| Sensors | `11-sensors-and-detection/` | `11.0-sensor-overview.md`, `11.2-passive-sensors.md` |
| Navigation | `10-navigation/` | `10.1-movement-mechanics.md`, `10.2-jump-transit.md` |
| Commanders | `16-commanders/` | `16.2-skills-and-bonuses.md`, `16.3-assignments.md` |

### Phase-Specific Manual References

**Phase 0 (Conventional Start):**
- Read `7-research/7.1-technology-tree.md` for TN tech explanation
- Read `2-game-setup/2.5-starting-conditions.md` for conventional vs TN start differences

**Phase 1 (Early TN):**
- Read `8-ship-design/8.1-design-philosophy.md` for first ship design guidance
- Read `8-ship-design/8.4-sensors.md` for survey sensor details
- Read `9-fleet-management/9.1-shipyards.md` for retooling shipyards

**Phase 2 (Exploration):**
- Read `17-exploration/17.1-geological-survey.md` for mineral surveying
- Read `17-exploration/17.2-gravitational-survey.md` for finding jump points
- Read `14-logistics/14.1-fuel.md` for fuel harvesting

**Phase 3 (Expansion):**
- Read `5-colonies/5.1-establishing-colonies.md` for colony setup
- Read `6-economy-and-industry/6.2-mining.md` for mining operations
- Read `10-navigation/10.2-jump-transit.md` for jump mechanics

**Phase 4 (Contact Preparation):**
- Read `12-combat/12.0-combat-overview.md` for combat basics
- Read `8-ship-design/8.5-weapons.md` for weapon design
- Read `11-sensors-and-detection/11.0-sensor-overview.md` for detection mechanics

### How to Cite Manual Sections

When referencing manual content:
1. Read the relevant file using the Read tool
2. Summarize the key points for the player
3. Provide the URL for further reading

Example citation format:
> For more details on survey sensors, see [Section 8.4: Sensors](https://erikevenson.github.io/aurora-manual/8-ship-design/8.4-sensors.html)

### Searching the Manual

Use Grep to find specific topics:
```bash
# Find mentions of a mechanic
grep -r "fuel consumption" --include="*.md"

# Find formulas
grep -r "formula\|calculation" --include="*.md"
```