ibank-sql-pack

Generate deterministic SQL seed inserts for iBank tables from approved drafts.

Updated Jun 5, 2026
One-click install
npx skills add https://github.com/KangJiSseok/ACODIAN --skill ibank-sql-pack
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: ibank-sql-pack
Source: https://github.com/KangJiSseok/ACODIAN/tree/main/.codex/skills/ibank-sql-pack
Command: npx skills add https://github.com/KangJiSseok/ACODIAN --skill ibank-sql-pack

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Produce sql seed output for iBank dummy users, teams, staffing, worklogs, and optional status history. Use when the user wants final SQL files from already-decided drafts or generated content.

Core Features & Use Cases

  • Deteministic, insert-ready SQL generation for multiple related tables in a single run.
  • Enforces stable IDs, reuses a shared BCrypt hash, and preserves approved drafts.
  • Maintains dependency order across tb_user, tb_team, tb_team_admin, tb_user_team, tb_worklog, tb_worklog_dependency, and tb_worklog_status_history when needed.

Quick Start

Run this skill to generate final SQL inserts for iBank seed data from approved drafts.

Frequently Asked Questions about ibank-sql-pack

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

FAQPage Schema
How do I generate deterministic SQL seed data for iBank dummy users and worklogs?

Generate deterministic SQL seed data for iBank by producing ready-to-run insert statements for dummy users, teams, staffing, and worklogs from approved drafts, enforcing stable IDs and reusing a shared BCrypt hash across records.

How does SQL seed data generation maintain table dependencies across tb_user and tb_worklog?

SQL seed data generation maintains table dependencies by respecting insert order across tb_user, tb_team, tb_team_admin, tb_user_team, tb_worklog, tb_worklog_dependency, and tb_worklog_status_history to preserve relational integrity.

Can I generate SQL seed inserts for related database tables in a single run?

You can generate SQL seed inserts for multiple related database tables in a single run, producing deterministic, insert-ready SQL files that preserve existing approved drafts while maintaining dependency order.

Do I need approved drafts before generating SQL seed data for iBank tables?

You need approved drafts or generated content to generate final SQL seed data for iBank tables, because the process preserves existing drafts and outputs ready-to-run insert files derived from those already-decided records.

What is the best way to populate tb_user and tb_team with dummy seed data?

The best way to populate tb_user and tb_team with dummy seed data is to generate final SQL insert files that enforce stable IDs, reuse a shared BCrypt hash, and maintain insert order for related tables.

Why does my SQL seed data generation not preserve existing drafts for tb_worklog?

SQL seed data generation preserves existing drafts for tb_worklog by deriving final insert statements from already-decided content; if drafts are overwritten, ensure the input workflow provides approved generated content before execution.