database-table-creator

Scaffold Kotlin/Exposed database tables with migrations, repositories, and tests.

96|9|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/c0x12c/ai-toolkit --skill database-table-creator
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-table-creator
Source: https://github.com/c0x12c/ai-toolkit/tree/main/.codex/skills/database-table-creator
Command: npx skills add https://github.com/c0x12c/ai-toolkit --skill database-table-creator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the end-to-end creation of a database table scaffold in Kotlin/Exposed, including SQL migrations, table definitions, entity mapping, repository implementation, tests, and a DI factory bean.

Core Features & Use Cases

  • End-to-end code scaffolding for SQL migrations, table objects, entities, repositories, tests, and factory beans.
  • Soft-delete aware design with deletedAt, read/write transaction separation, and test coverage scaffolding.
  • Use Case: When introducing a new domain table, generate all necessary artifacts to maintain a consistent architectural pattern.

Quick Start

Create a complete Kotlin Exposed-based table, including SQL migration, table, entity, repository, tests, and a DI factory for a new domain table.

Frequently Asked Questions about database-table-creator

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

FAQPage Schema
How do I scaffold a complete Kotlin Exposed database layer for a new domain table?

Scaffolding a Kotlin Exposed database layer is automated end-to-end by generating SQL migrations, table objects, entities, repositories, tests, and DI factory beans to ensure consistent architectural patterns across all artifacts.

What is the best way to enforce UUID primary keys and soft deletes in Kotlin Exposed repositories?

Enforcing UUID primary keys and soft deletes with deletedAt in Kotlin Exposed repositories is achieved by applying strict scaffolding rules that generate table definitions and repository implementations adhering to these specific data model constraints.

Does Kotlin Exposed scaffolding separate read and write transactions for repository methods?

Yes, Kotlin Exposed scaffolding separates read and write transactions within repository methods, generating distinct transactional blocks that maintain consistent data access patterns and architectural integrity across domain models.

How do I generate comprehensive test coverage for Kotlin Exposed table migrations and repositories?

Generating comprehensive test coverage for Kotlin Exposed repositories involves scaffolding test suites alongside table objects and migrations, ensuring that all data access layers and soft-delete logic are fully validated during creation.

Can I use this scaffolding to generate SQL migrations and text-based columns for Kotlin domain models?

Yes, this scaffolding generates SQL migrations and defines text-based columns for Kotlin domain models, automating the creation of table objects and entity mappings while satisfying strict rules for column types and migration consistency.

When should I not use automated scaffolding for Kotlin database tables and repositories?

Automated scaffolding for Kotlin database tables should be avoided when introducing highly custom repository logic or non-standard primary keys, as the generator strictly enforces UUID primary keys, soft deletes, and predefined design patterns.