此内容尚未提供您的语言版本,正在以英文显示。

Database Table Creator

技能活跃

Creates 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.

功能

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

使用场景

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

非目标

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

工作流

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

实践

Database Design
Kotlin Best Practices
Repository Pattern
Test-Driven Development

先决条件

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.

安装

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

通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。

质量评分

95 /100

13 days ago 分析

信任信号

最近提交15 days ago

GitHub 所有者 spartan-stratos

星标68

许可证MIT

状态

查看源代码

类似扩展

Migrate Create

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

技能

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.

技能

awslabs

Database Patterns

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

技能

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.

技能

github

Migrate Validate

100

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

技能

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.

技能

github