SKILL

okhp3-database-cartographer

OverKill Hill P³ database cartographer. Reverse-engineers and documents the live structure of Postgres, MySQL/MariaDB, MS SQL Server, SQLite, Oracle, and Microsoft Access databases via SQLAlchemy reflection or the right engine driver, producing a normalized schema inventory, a severity-classified (P1/P2/P3) diff against a locked design spec, and a Mermaid ER diagram handed to okhp3-mermaid-*/mermaid-diagrams for rendering. Use when asked to reverse-engineer, interrogate, document, or audit an existing database; verify a live build against a schema spec or data dictionary; generate an ER diagram from a real database connection; or check for schema drift. Also activate on "what does this database actually look like," "document this database," "audit against the spec," or "reflect this database's structure." Read-only by design -- not a data-quality profiler, not a migration generator, never writes to the target database.

原文 · 译文尚未补齐

适用对象:数据库。自动收录 · 待核查。

原作者说明节选

从固定版本的 SKILL.md 提取,保留原文语言。以下内容属于作者说明,本站尚未验证安装、兼容或运行结果。

查看英文原文

原文涵盖的主题

  • okhp3-database-cartographer
  • Scope
  • Architecture: two jobs, two tools, one handoff
  • Step 1 -- Interrogate
  • Step 2 -- Diff against the locked spec
  • Step 3 -- Diagram
  • Security and safety
  • Output

OverKill Hill P³ · overkillhill.com · github.com/OKHP3 Interrogates a live database of largely unknown or partially-documented structure and turns it into two things: a schema inventory with severity-classified findings against whatever spec you point it at, and a Mermaid ER diagram. It does the surveying and the cartography does not happen in the same tool -- interrogation and diagramming are deliberately decoupled (see "Architecture" below), because the best tool for connecting to a database and the best tool for drawing a diagram are never the same tool. | In scope | Out of scope | |---|---| | Reflecting live structure from Postgres, MySQL/MariaDB, MSSQL, SQLite, Oracle | Data quality / row-level profiling | | Reflecting MS Access (.accdb/.mdb), flagged as the fragile path | Migration script generation | | Diffing live structure against a locked spec, P1/P2/P3 findings | Firestore/NoSQL (deferred to a future version) | | Generating a Mermaid ER diagram from the reflected schema | Writing to or modifying the target database | If the task is "does this database's structure match what we documented" or "what does this database actually look like," this is the right skill. If the ta

这里只展示节选,请以完整原文和当前要求为准。

来源仓库
OKHP3/skillz
源文件
universal/okhp3-database-cartographer/SKILL.md
固定版本
7b187777d42ab7bc7bab1e5f2c940cd3139ecebf
阅读完整原作者说明 ↗

来源与内容状态

本条为自动发现的元数据,尚未完成人工文档核查;适用性与运行结果待核查。

原作者:OKHP3/skillz · 原作者仓库元数据。文档核查:未核查。最近来源检查:2026-11-10T10:00:55.836Z。

分类由名称、说明与路径规则生成,分类不代表已核实适配。

许可与权利归属

MIT。第三方内容及版权归原作者,使用条件以原文为准。

许可原文 ↗

本站没有因同步、复制或用户自报成功而将资源标为运行验证通过。

限制与注意事项

  • 元数据收录不代表本站已经安装、适配、实测或进行安全审查。