Write and debug MySQL SQL with dialect-aware syntax.
npx skills add https://github.com/mako-ai/mako --skill dialect-mysql
Please help me install this Agent Skill. Skill: dialect-mysql Source: https://github.com/mako-ai/mako/tree/main/api/src/agent-skills/dialect-mysql Command: npx skills add https://github.com/mako-ai/mako --skill dialect-mysql
This skill helps developers write and debug MySQL SQL with proper backtick usage, MySQL-specific functions, and date formatting, reducing errors and time spent on syntax issues.
column and database.table correctly to avoid reserved word conflicts.Convert a standard SQL snippet to MySQL syntax and verify MySQL-specific constructs.
High-intent search queries and answers about installing and using this skill.
DATE_FORMAT in MySQL formats date values using specific format specifiers like %Y for year and %m for month. This skill applies DATE_FORMAT to ensure precise monthly or interval-based queries while preserving your original query semantics.
Backtick identifiers are required in MySQL when column or table names conflict with reserved words. This skill enforces proper backtick usage for `column` and `database`.`table` references to prevent syntax errors and reserved word conflicts.
MySQL uses the CONCAT function for string concatenation rather than the standard || operator. This skill converts standard SQL concatenation to MySQL-specific CONCAT syntax, ensuring your queries execute without errors.
MySQL pagination uses LIMIT and OFFSET, including the alternative LIMIT offset, count form for specifying row ranges. This skill enforces proper LIMIT forms to optimize pagination and performance in your data-access tasks.
DATE_SUB in MySQL subtracts a time interval from a date value for interval-based filtering. This skill applies DATE_SUB syntax correctly to ensure accurate date arithmetic while maintaining your intended query logic.
theslashdojoDefine type-safe database schemas in TypeScript for Drizzle ORM.
DanielPodolskyAnalyze database schema design, SQL queries, and ORM usage for correctness.
recca0120Create and migrate SQLite and MySQL schemas with Drizzle ORM.
DbxstudioGenerate, optimize, and debug SQL queries across multiple database dialects.