schema-contracts

Name: schema-contracts
Availability: InStock
Author: ssmleo

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

Ready to run

npx skills add https://github.com/ssmleo/govfolio --skill schema-contracts

💬 Prompt for ChatGPT / Claude Chat▼

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.