Menu
Load when writing or debugging MySQL SQL, including backtick identifiers, casts, date arithmetic, CONCAT, REGEXP, LIMIT/OFFSET, and MySQL-specific query syntax.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Load when building, editing, or debugging Mako React apps — app files, npm dependencies, data bindings, the @mako/app-sdk hooks (useQuery / useDuckDB / useLocation / useSearchParams / navigate), URL state and shareable deep links, materialized Parquet/DuckDB bindings, and the live preview runtime.
Load for dbt branches, commits, pushes, pull requests, merges, repository sync, or branch cleanup.
Load when creating, editing, scheduling, running, or debugging dbt jobs and production deployments.
Load when building, editing, running, or debugging dbt models, dbt projects, schema.yml tests, sources, seeds, snapshots, incremental models, materializations, or dbt jobs in the Transforms section.
Load when creating, editing, configuring, validating, or debugging database sync flows, connector flows, pagination, incremental sync, destination mappings, and flow form fields.
Add a new MCP server preset (connector) to Mako's MCP client system — server URL, auth model (OAuth DCR, pre-registered app, or API key), scopes, icon, tests, and docs. Use when connecting a new external MCP server (like Slack or Close CRM) or changing how MCP connections authenticate.
| name | dialect-mysql |
| description | Load when writing or debugging MySQL SQL, including backtick identifiers, casts, date arithmetic, CONCAT, REGEXP, LIMIT/OFFSET, and MySQL-specific query syntax. |
| entities | ["mysql","sql","date_format","date_sub","regexp","concat"] |
Use this skill for MySQL connections.
| Feature | MySQL syntax | Notes |
|---|---|---|
| Identifiers | `column`, `database`.`table` | Use backticks for reserved or mixed-case names. |
| Type casts | CAST(x AS type) | No PostgreSQL ::type. |
| String concat | CONCAT(a, b) | ` |
| Pattern match | LIKE, REGEXP | REGEXP_LIKE exists in MySQL 8+. |
| Dates | DATE_SUB(CURDATE(), INTERVAL 30 DAY) | Use MySQL interval functions. |
| Formatting | DATE_FORMAT(created_at, '%Y-%m') | Good for monthly buckets. |
| Pagination | LIMIT 500, LIMIT 500 OFFSET 1000 | MySQL also supports LIMIT offset, count. |
SELECT
DATE_FORMAT(created_at, '%Y-%m') AS month,
status,
COUNT(*) AS order_count,
SUM(total_amount) AS revenue
FROM `orders`
WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
GROUP BY month, status
ORDER BY month, status
LIMIT 500;