メニュー
Fix an agentic NL2SQL system after a database schema change. Inspect the schema contract, agent prompts, and vector database chunks for stale field references and update them.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Fast status check for backlog tasks using `scripts/backlog_board.py` and `backlog/board.md`. Use when you need a compact view of task id, epic, status, and short description across sessions.
Create or update `backlog/<TASK-ID>.md` task files for this repo using the established traceability format. Use when asked to add backlog task documents, standardize task scope and status, or derive task files from `PRODUCT_BACKLOG.md`.
The database schema changed and the agent is returning wrong answers. Fix it.
Four-layer schema sync procedure for the Ghost Contributors NL2SQL system after a database migration. Covers YAML contract, ChromaDB RAG chunks, NL2SQL prompt, and RAG prompt with a step-by-step repair sequence.
Complete schema drift repair for the Ghost Contributors NL2SQL system. Patches all four layers (YAML contract, ChromaDB RAG chunks, NL2SQL prompt, RAG prompt) using validated tooling. Includes dry-run preview, step-by-step fallback, validation, and rollback.
| name | schema-sync-structured |
| description | Fix an agentic NL2SQL system after a database schema change. Inspect the schema contract, agent prompts, and vector database chunks for stale field references and update them. |
After a database schema migration, the following files and systems may contain stale field references.
agentic_system/schema/github_events.yaml — machine-readable schema contractagentic_system/agents_core/nl2sql/prompts/system.md — NL2SQL agent system promptagentic_system/agents_core/rag/prompts/system.md — RAG agent system promptschema_docs, qa_examples — vector RAG chunksSELECT name, type FROM system.columns WHERE table = 'github_events' ORDER BY positionstale: True in their metadata and update their content.Run python scripts/validate_schema.py to check whether the YAML contract matches the live schema.