skills.rest
simple-platform
simple-platformOFFICIAL
Explore all skills by this author →
GitHub

data-modeling

Define data models with tables, fields, constraints, and relationships in SCL.

1|1|Updated Jan 4, 2026
Search Tags:#database design#data modeling#relationships#schema definition#enterprise applications#scl
One-click install
npx skills add https://github.com/simple-platform/simple-tools --skill data-modeling-simple-platform
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-modeling
Source: https://github.com/simple-platform/simple-tools/tree/main/tools/simple-cli/internal/scaffold/templates/agent/skills/data-modeling
Command: npx skills add https://github.com/simple-platform/simple-tools --skill data-modeling-simple-platform

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive guide to defining robust and scalable data models using the Simple Configuration Language (SCL), eliminating the need for manual SQL table creation and enforcing best practices.

Core Features & Use Cases

  • Schema Definition: Learn to define tables, fields, types, and constraints in SCL.
  • Relationship Management: Understand how to establish in-app and cross-app relationships between tables.
  • Index Optimization: Implement efficient indexing strategies for improved query performance.
  • Use Case: A developer needs to define a new product table with various fields like name, price, and inventory count, along with a relationship to a category table.

Quick Start

Define a new product table with a name and price field, and establish a belongs_to relationship with the category table.

Frequently Asked Questions about data-modeling

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

FAQPage Schema
How do I define database tables and schema using Simple Configuration Language?▼

To define database tables and schema using Simple Configuration Language, you specify table definitions, field types, and constraints. This enforces best practices for enterprise applications and eliminates manual SQL table creation.

What is the best way to establish cross-app relationships in a data model?▼

Establishing cross-app relationships in a data model involves linking tables across different applications using SCL. You can define in-app and cross-app connections to manage data dependencies and structure scalable enterprise architectures.

Can I define indexing strategies for query optimization in SCL?▼

Yes, you can define indexing strategies in SCL. Implementing efficient indexes during schema definition improves query performance and data retrieval speed for large enterprise applications.

How do I add field constraints and types when designing a database schema?▼

When designing a database schema, you add field constraints and types by declaring them in the SCL table definition. This ensures data integrity by validating inputs against specified rules before storage.

Does this approach to data modeling require manual SQL scripting?▼

No, this data modeling approach does not require manual SQL scripting. Using Simple Configuration Language automatically generates robust schemas, removing the need to write raw SQL while enforcing structural best practices.

Related Skills

Explore More Software Engineering Skills→
corezoidcorezoid
58

simulator-init

Initialize and configure the Simulator.Company environment with OAuth authentication and .env storage.

Official
Intermediate
AincFhAincFh

d1-migration

Generate Cloudflare D1 migration scripts for schema changes.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced
silaslopes100silaslopes100

reversa-data-master

Generate data dictionaries and ERD diagrams from DDL, migrations, and ORM models.

Community
Advanced