Enforce MySQL DDL conventions for schema design and peer reviews.
npx skills add https://github.com/ql-link/LinkRag --skill mysql-ddl-conventions
Please help me install this Agent Skill. Skill: mysql-ddl-conventions Source: https://github.com/ql-link/LinkRag/tree/main/.ai/skills/mysql-ddl-conventions Command: npx skills add https://github.com/ql-link/LinkRag --skill mysql-ddl-conventions
This skill provides a comprehensive, consistent set of MySQL table naming, indexing, and data-type conventions to streamline database design, review, and maintenance across projects.
Consult the MySQL DDL conventions to draft your next table using snake_case naming, proper primary key, indexed fields, and a compliant DDL template.
High-intent search queries and answers about installing and using this skill.
Standard MySQL naming conventions enforce snake_case for tables and columns, use singular table names, and require specific index prefixes like idx_ and uk_ to maintain consistent schema design across teams.
You can use a standardized MySQL DDL template that includes InnoDB engine settings, utf8mb4 charset, proper primary keys, timestamp columns with defaults, and robust COMMENT annotations for table metadata.
The best way to name MySQL indexes is by using standardized prefixes such as idx_ for standard indexes and uk_ for unique constraints, minimizing total index count while preserving query performance.
You audit an existing MySQL schema by reviewing field types, primary keys, status enums, numeric counters, and timestamp columns against standardized DDL conventions during peer reviews.
Yes, these MySQL DDL conventions support longtext usage for large content storage, alongside standardized primary keys, timestamp defaults, and utf8mb4 charset settings for comprehensive schema compliance.
You need to apply DDL conventions when creating new tables, adding constraints, naming indexes, or documenting database design standards for peer reviews to ensure consistent schema maintenance.
huangztExecute SQL queries and inspect MySQL database schemas with Python scripts.
williamwang25Manage CloudBase MySQL instances and SQL permissions via MCP tools.
MinhmiceDesigns and migrates database schemas, policies and queries for SQL-based systems.
cenjieDesign normalized PostgreSQL and MySQL schemas with relationships and constraints.
