java-mysql-database

Enforce Alibaba MySQL schema, indexing, and ORM standards for Java applications.

44|15|Updated Jan 31, 2026

Search Tags:#java #mysql #schema-design #orm-mapping #sql-syntax #database-standards

Ready to run

npx skills add https://github.com/yanhaoluo0/AlibabaDevelopmentManualSkills --skill java-mysql-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: java-mysql-database
Source: https://github.com/yanhaoluo0/AlibabaDevelopmentManualSkills/tree/main/.cursor/skills/java-mysql-database
Command: npx skills add https://github.com/yanhaoluo0/AlibabaDevelopmentManualSkills --skill java-mysql-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Alibaba Java MySQL database standards help teams avoid schema drift by providing rules for table/column naming, data types, auditing fields, indexing, SQL syntax, and ORM mappings in Java projects.

Core Features & Use Cases

Schema conventions: enforce lowercase table/column names, unsigned numeric types, and mandatory audit fields (create_time, update_time).
Indexing & SQL guidance: advise on unique and composite indexes, avoid unnecessary full-table scans, and promote safe query patterns.
ORM mappings: ensure explicit result mappings, avoid select * usage, and align database fields with Java objects.

Quick Start

Design your next MySQL schema for a Java project by applying the lowercase naming, unsigned types, and standard auditing fields as described.

Frequently Asked Questions about java-mysql-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

What are the Alibaba MySQL standards for Java schema design?▼

Alibaba MySQL standards enforce lowercase table and column names, unsigned numeric data types, mandatory audit fields like create_time and update_time, and naming conventions for keys to prevent schema drift in Java applications.

How do I enforce ORM mapping best practices in a Java application?▼

To enforce ORM mapping best practices, ensure explicit result mappings, avoid using select * queries, and align database fields directly with Java objects to maintain safe query patterns and prevent schema drift.

How do you plan indexes for MySQL tables using Alibaba database standards?▼

Planning indexes involves advising on unique and composite indexes, avoiding unnecessary full-table scans, and promoting safe query patterns to optimize database performance and adhere to database standards.

Can I apply Alibaba database standards to an existing Java project?▼

Yes, you can apply these database standards to existing Java projects by enforcing schema conventions, indexing rules, and ORM mappings during schema design, index planning, SQL writing, and ORM mapping phases.

Why do I need mandatory audit fields like create_time and update_time in MySQL?▼

Mandatory audit fields like create_time and update_time are required by Alibaba database standards to ensure consistent data tracking, prevent schema drift, and maintain standardized auditing across Java applications.