How are tree structures handled?

It implements the Ancestor Path Method (Path Enumeration) for tree structures, which allows for efficient hierarchical querying.

What databases are supported by this skill?

The skill provides universal SQL standards primarily optimized for MySQL but applicable to most relational databases like PostgreSQL and MariaDB.

Does it include support for Java frameworks?

Yes, it specifically provides implementation patterns for MyBatis-Plus, including MetaObjectHandler for automated audit field injection.

What are the recommended primary key types?

The skill recommends using BIGINT for primary keys to support Snowflake IDs or auto-incrementing values for better index performance compared to UUIDs.

Database Operations Standard

Name: Database Operations Standard
Author: xu-cell

byxu-cell

•

数据库管理

Standardizes database schema design and SQL development through rigorous templates, naming conventions, and indexing best practices.

This skill serves as a comprehensive guide for engineering-grade database management within the AI development workflow. It provides developers with standardized SQL templates that incorporate essential audit fields, logical deletion flags, and optimized indexing strategies. By following these patterns, teams can ensure data consistency across projects, simplify integration with frameworks like MyBatis-Plus, and avoid common pitfalls such as improper data types or missing constraints. Whether you are initializing a new project or refining a complex data model like tree structures, this skill provides the architectural foundation needed for scalable and maintainable relational databases.

主要功能

01Automated audit field filling patterns for MyBatis-Plus

0211 GitHub stars

03Logical deletion standards and configuration guides

04Naming conventions for tables, columns, and indexes

05Standardized SQL table templates with pre-defined audit fields

06Advanced modeling patterns for tree structures and many-to-many relations

使用场景

01Initializing new database schemas with consistent auditing and naming standards

02Designing high-performance indexes for complex relational queries

03Implementing logical deletion and soft-delete workflows in Java-based backends

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-cell/ai-engineering-init database-ops

For use in Claude.ai and ChatGPT

Download Skill