Enforce Alibaba P3C MySQL standards for schema design and SQL quality.
npx skills add https://github.com/jie023/trae-setting --skill p3c-mysql-database
Please help me install this Agent Skill. Skill: p3c-mysql-database Source: https://github.com/jie023/trae-setting/tree/main/skills/p3c-mysql-database Command: npx skills add https://github.com/jie023/trae-setting --skill p3c-mysql-database
This skill provides standardized MySQL database guidelines aligned with P3C, covering table creation rules, SQL statement standards, indexing strategies, and ORM mapping requirements to improve consistency and quality.
Apply the p3c-mysql-database skill to audit a schema.sql or ORM mapping file against the P3C guidelines and generate a compliant schema template.
High-intent search queries and answers about installing and using this skill.
To enforce MySQL naming conventions and mandatory fields, apply P3C database standards requiring lowercase underscore names, mandatory fields like id, business_id, create_time, update_time, delete_state, and delete_time, plus comprehensive field comments for schema consistency.
P3C SQL best practices for MySQL indexing and data types mandate using decimals for numbers to avoid precision loss, avoiding reserved words, selecting proper data types, and applying recommended index strategies to optimize query performance.
Yes, you can audit an existing schema.sql file against Alibaba P3C MySQL database standards. This process checks table creation rules, ORM mapping requirements, and data lifecycle constraints to generate a fully compliant schema template.
P3C database design supports ORM mapping requirements for enterprise Java services by enforcing standardized table creation rules, unique foreign keys like business_id, and proper data types to ensure maintainability and easier code reviews during schema refactoring.
P3C requires specific lifecycle fields like delete_state and delete_time in MySQL tables to enforce soft deletion and track data lifecycle constraints. This ensures consistent audit trails and prevents permanent data loss during enterprise application operations.
merge-apiCreate the linked_accounts database table with ORM model generation.
lukegob10Automate schema discovery and relationship mapping in relational databases.
jeremylongshoreGenerate ORM models and database schemas across multiple frameworks.
aurumorincCreate MySQL queries using a standardized template and syntax guidelines.
