skills.rest
ssmleo
ssmleoCOMMUNITY
Explore all skills by this author →
GitHub

schema-contracts

Regenerate contracts and SQL CHECKs from committed JSON Schemas.

Updated Jul 4, 2026
Search Tags:#code generation#data validation#json schema#contract enforcement#system consistency
One-click install
npx skills add https://github.com/ssmleo/govfolio --skill schema-contracts
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-contracts
Source: https://github.com/ssmleo/govfolio/tree/main/agents/skills/schema-contracts
Command: npx skills add https://github.com/ssmleo/govfolio --skill schema-contracts

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill ensures that JSON Schema definitions are kept in sync across various systems, reducing the risk of data inconsistencies and errors.

Core Features & Use Cases

  • Schema Enforcement: Ensures that JSON Schemas are up-to-date and consistent across different systems.
  • Code Generation: Generates contracts and SQL CHECKs based on the committed JSON Schema.
  • Use Case: When making changes to a data type definition, this Skill automatically updates the corresponding JSON Schema, contracts, and SQL CHECKs, keeping all systems in sync.

Quick Start

Run the schema-contracts skill to regenerate contracts and SQL CHECKs when updating a JSON Schema.

Frequently Asked Questions about schema-contracts

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I keep JSON Schema definitions consistent across multiple systems?▼

JSON Schema consistency is maintained by automatically regenerating contracts and SQL CHECKs from committed schema definitions. This prevents data validation errors by synchronizing updates whenever data type definitions change across systems.

How do I generate SQL CHECKs from JSON Schema for data validation?▼

You can generate SQL CHECKs from JSON Schema by running a schema enforcement process that reads your schema definitions and outputs corresponding database constraints. This enforces data validation directly at the database level.

What is the best way to automate contract enforcement when updating data types?▼

The best way to automate contract enforcement is to regenerate downstream contracts and SQL CHECKs immediately after updating a JSON Schema definition. This keeps system consistency without manual intervention when data types change.

Do I need schema validation capabilities to enforce JSON Schema contracts?▼

Yes, schema validation and code generation capabilities are required to enforce JSON Schema contracts. These prerequisites enable the system to read definitions and automatically output corresponding contracts and SQL CHECKs.

Why do my data validation rules fail when updating JSON Schema across services?▼

Data validation rules fail when JSON Schema updates are not synced across services. Manually updating contracts and SQL CHECKs leads to system inconsistencies, which can be solved by automating contract regeneration whenever the schema changes.

Related Skills

Explore More Software Engineering Skills→
joyz0joyz0

type-safety-design

Validate TypeScript runtime data with TypeBox and Zod schemas.

Community
Advanced
AltimateAIAltimateAI

migrating-sql-to-dbt

Convert SQL stored procedures, views, and raw SQL files into dbt models.

Official
Intermediate
heaptracetechnologyheaptracetechnology
13

contract-test

Automate API contract testing with schema validation and OpenAPI checks.

Community
Advanced
20YN0420YN04

vnpy-export

Translate Vibe-Trading backtest strategies into executable vnpy CtaTemplate Python classes.

Community
Advanced