pythia-explore
Installation
SKILL.md
Exploring the Schema
Announce at start: "Using pythia-explore — asking the database directly."
Phase: Learn
The principle: ask the database, never the dump
Repositories of exported .sql files go stale the day after export. A real
mid-size system, audited in 2026, compared its repo dump against the live
database:
| Object type | In the dump | In the database | Verdict |
|---|---|---|---|
| Procedures | 3,827 | 3,827 | matched |
| Tables | 952 | 952 | matched |
| Types | 0 | 115 | all missing |
| Packages | 0 | 9 | all missing |
| Indexes | 116 | 1,016 | ~89% missing |