Skills
.Work. You
Rest

sql-schema-creator

Official

Define and manage SQL schemas for ORE Studio.

Software Engineering#automation#SQL#schema#PostgreSQL#temporal#trigger#domain-types
AuthorOreStudio
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a structured approach to creating, updating, and maintaining SQL schemas for ORE Studio, including temporal tables, triggers, and population scripts, enabling consistent database evolution.

Core Features & Use Cases

  • Temporal schema generation: Create and version tables with validity periods, versioning, and soft delete semantics.
  • Trigger and notify integration: Implement insert triggers, delete rules, and change notifications to support real-time UI and auditability.
  • Workflow orchestration: Produce drop, populate, and migration scripts aligned with repository conventions to streamline DB maintenance.

Quick Start

Use this skill when you need to scaffold a new domain-type SQL schema; refer to domain type creation to align the SQL with your codebase. Follow the standard file structure under projects/ores.sql/create to generate the necessary create, drop, and notify SQL files.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-schema-creator
Download link: https://github.com/OreStudio/OreStudio/archive/main.zip#sql-schema-creator

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.