Database Table Creator

Skill Active

Creates database table with full Kotlin synchronization (SQL migration → Table → Entity → Repository → Tests). Use when adding new database tables or entities.

Purpose

To automate the creation of robust and compliant database tables and associated Kotlin code, ensuring consistency and quality in development workflows.

Features

Generates SQL migrations with specific constraints
Creates Kotlin Table objects and Entity data classes
Scaffolds Repository interfaces and implementations
Includes comprehensive repository tests
Enforces strict coding and database design rules

Use Cases

Adding new database tables to a project
Implementing new entities with full CRUD operations
Ensuring adherence to Kotlin and PostgreSQL best practices
Automating repetitive database code generation tasks

Non-Goals

Performing complex database schema refactoring
Generating ORM entities for frameworks other than the specified Kotlin pattern
Handling application-level business logic beyond repository operations

Workflow

Create SQL Migration
Run Migration using Gradle
Create Kotlin Table Object
Create Entity Data Class
Define Repository Interface
Implement Repository
Register Factory Bean
Write Repository Tests
Run Tests

Practices

Database Design
Kotlin Best Practices
Repository Pattern
Test-Driven Development

Prerequisites

PostgreSQL database
Kotlin development environment
Gradle build tool

Maintenance

warning:Dependency ManagementThe project uses Gradle and appears to have dependencies, but there are no explicit measures like lockfiles or dependabot configuration evident for managing or updating these dependencies.

Execution

warning:Pinned dependenciesWhile Gradle is used, there's no explicit mention or evidence of dependency pinning via lockfiles for the project's dependencies.

Installation

npx skills add spartan-stratos/spartan-ai-toolkit

Runs the Vercel skills CLI (skills.sh) via npx — needs Node.js locally and at least one installed skills-compatible agent (Claude Code, Cursor, Codex, …). Assumes the repo follows the agentskills.io format.

Quality Score

95 /100

Analyzed 6 days ago

Trust Signals

Last commit9 days ago

GitHub owner spartan-stratos

Stars68

LicenseMIT

Status

View Source

Similar Extensions

Migrate Create

Create a new sequentially numbered database migration with up/down SQL files

Skill

ruvnet

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill

awslabs

Database Patterns

Database design patterns including schema design, migrations, soft deletes, and Exposed ORM. Use when creating tables, writing migrations, or implementing repositories.

Skill

spartan-stratos

Kotlin Mcp Server Generator

100

Generate a complete Kotlin MCP server project with proper structure, dependencies, and implementation using the official io.modelcontextprotocol:kotlin-sdk library.

Skill

github

Migrate Validate

100

Validate pending migrations for foreign key consistency, rollback safety, and best practices

Skill

ruvnet

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill

github