AgentStack
Sign in Publish
MCP servers Skills Toolkits Why AgentStack Sell Docs
Sign in
SKILL verified Apache-2.0 Self-run

Schema Sync Structured

skill-dsmmartin-skills-talk-agent-camp-2026-01-structured · by DSmmartin

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.

↗ Repository
— No reviews yet
0 installs
14 views
0.0% view→install

Install

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

✓ scanned · ✓ verified — works with Claude Code, Cursor, and more.

Security review

✓ Passed

No issues found. Passed automated security review. · v0.1.0 How review works →

  • ✓ Prompt-injection patterns
  • ✓ Secret / credential exfiltration
  • ✓ Dangerous shell & filesystem operations
  • ✓ Untrusted network calls
  • ✓ Known-malicious package signatures

What it can access

  • ✓ Network access No
  • ✓ Filesystem access No
  • ✓ Shell / process execution No
  • ✓ Environment & secrets No
  • ✓ Dynamic code execution No

From automated source analysis of v0.1.0. “Used” means the capability is present in the source — more access means more to trust, not that it’s unsafe.

Are you the author of Schema Sync Structured? Claim this listing to set pricing, connect Stripe payouts, and keep 70% of every sale.
Sign up to claim

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.

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

Reviews

No reviews yet — be the first.

Write a review

Versions

  • v0.1.0 Imported from the upstream source.

More in Databases