Database Table Creator
Skill AktivCreates database table with full Kotlin synchronization (SQL migration → Table → Entity → Repository → Tests). Use when adding new database tables or entities.
To automate the creation of robust and compliant database tables and associated Kotlin code, ensuring consistency and quality in development workflows.
Funktionen
- 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
Anwendungsfälle
- 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
Nicht-Ziele
- 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
Praktiken
- Database Design
- Kotlin Best Practices
- Repository Pattern
- Test-Driven Development
Voraussetzungen
- 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-toolkitFührt das Vercel skills CLI (skills.sh) via npx aus — benötigt Node.js lokal und mindestens einen installierten skills-kompatiblen Agent (Claude Code, Cursor, Codex, …). Setzt voraus, dass das Repo dem agentskills.io-Format folgt.
Qualitätspunktzahl
Vertrauenssignale
Ähnliche Erweiterungen
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Dsql
100Build 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.
Database Patterns
98Database design patterns including schema design, migrations, soft deletes, and Exposed ORM. Use when creating tables, writing migrations, or implementing repositories.
Kotlin Mcp Server Generator
100Generate a complete Kotlin MCP server project with proper structure, dependencies, and implementation using the official io.modelcontextprotocol:kotlin-sdk library.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal 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.