Database Patterns
技能 已验证 活跃Database design patterns including schema design, migrations, soft deletes, and Exposed ORM. Use when creating tables, writing migrations, or implementing repositories.
To enforce consistent and high-quality database design patterns, ensuring maintainability and correctness in application development.
功能
- Opinionated database design rules
- SQL migration templates
- Exposed ORM table object patterns
- Entity data class structure
- Repository pattern implementation guide
使用场景
- Creating new database tables with best practices
- Writing database migration scripts
- Implementing data repositories with ORM
- Applying soft delete strategies consistently
非目标
- Executing database operations
- Providing a runnable ORM framework
- Handling database connection management
安装
npx skills add spartan-stratos/spartan-ai-toolkit通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。
质量评分
已验证类似扩展
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.
DBHub Database Query Guide
100DBHub MCP 服务器查询数据库指南。每当您需要通过 DBHub 的 MCP 工具（search_objects、execute_sql）来探索数据库模式、检查表或运行 SQL 查询时，请使用此技能。在任何数据库查询任务、模式探索、数据检索或通过 MCP 执行 SQL 时激活，即使用户只说“检查数据库”或“为我查找一些数据”。此技能可确保您遵循正确的先探索后查询的工作流程，而不是猜测表结构。
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.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Database Table Creator
95Creates database table with full Kotlin synchronization (SQL migration → Table → Entity → Repository → Tests). Use when adding new database tables or entities.