Relational Mapper Skill

What problem does it solve?

This Skill automates the complex process of detecting relationships between multiple data tables and generating synthetic data that adheres to these relationships and maintains referential integrity.

Core Features & Use Cases

• Relationship Detection: Automatically identifies primary keys, foreign keys, and various relationship types (1:1, 1:N, N:M).
• Referential Integrity: Ensures generated data respects foreign key constraints, preventing orphaned records.
• Use Case: Generate a realistic e-commerce database with customers, orders, and order items, ensuring each order is linked to a valid customer and each order item to a valid order.

Quick Start

Use the relational mapper skill to analyze the schema and generate 1000 customer records, 5000 orders, and 15000 order items, maintaining referential integrity.