# Schema Sync Structured

> 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.

- **Type:** Skill
- **Install:** `agentstack add skill-dsmmartin-skills-talk-agent-camp-2026-01-structured`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [DSmmartin](https://agentstack.voostack.com/s/dsmmartin)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** Apache-2.0
- **Upstream author:** [DSmmartin](https://github.com/DSmmartin)
- **Source:** https://github.com/DSmmartin/skills_talk_agent_camp_2026/tree/main/dev_tools/skill_examples/01_structured

## Install

```sh
agentstack add skill-dsmmartin-skills-talk-agent-camp-2026-01-structured
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Schema Sync — Structured

After a database schema migration, the following files and systems may contain stale field references.

## Files to inspect

- `agentic_system/schema/github_events.yaml` — machine-readable schema contract
- `agentic_system/agents_core/nl2sql/prompts/system.md` — NL2SQL agent system prompt
- `agentic_system/agents_core/rag/prompts/system.md` — RAG agent system prompt
- ChromaDB collections: `schema_docs`, `qa_examples` — vector RAG chunks

## What to look for

1. Read the live ClickHouse schema: `SELECT name, type FROM system.columns WHERE table = 'github_events' ORDER BY position`
2. Find references to old field names and SQL predicates in the files above.
3. Update each file to use the new field names, types, and predicate syntax.
4. For ChromaDB: find chunks with `stale: True` in their metadata and update their content.

## Validation

Run `python scripts/validate_schema.py` to check whether the YAML contract matches the live schema.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [DSmmartin](https://github.com/DSmmartin)
- **Source:** [DSmmartin/skills_talk_agent_camp_2026](https://github.com/DSmmartin/skills_talk_agent_camp_2026)
- **License:** Apache-2.0

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-dsmmartin-skills-talk-agent-camp-2026-01-structured
- Seller: https://agentstack.voostack.com/s/dsmmartin
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.