mariadb-sql
MariaDB-specific SQL dialect knowledge — correctness pitfalls (NULL/GROUP BY/collation semantics), performance (optimizer, indexes, EXPLAIN reading), optimizer internals (cost model, statistics/histograms, join order, semi-join strategies, optimizer_trace) for when a plan doesn't behave as expected, query profiling (SHOW PROFILE, Performance Schema, slow query log, ANALYZE FORMAT=JSON, status counters) for measuring a live query or workload, safety (sql_mode, FK/engine behavior), feature-availability by version (window functions, CTEs, JSON, sequences, system-versioned tables), and version-gated modernization rewrites (old workaround pattern → modern feature, e.g. a counter table → `SEQUENCE`, or last-insert-id round trip → `RETURNING`). Use when reviewing, writing, or tuning SQL that targets MariaDB (as opposed to generic ANSI SQL, MySQL-only behavior, or another RDBMS), or when the target version/edition is unstated but the schema/tooling implies MariaDB (`mariadb`/`mariadb-admin` CLI, `my.cnf`, `aria`/`innodb`/`columnstore` storage-engine mentions, a `10.x`/`11.x`/`12.x` version string). Trigger on the user simply saying "MariaDB" in a SQL/database context, not only on an explicit review/tuning request — dialect detection alone is enough to load this reference.
- License 许可
- Apache-2.0
- 最近更新
- 2026-09-13
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- mariadb-sql
- description
- MariaDB-specific SQL dialect knowledge — correctness pitfalls (NULL/GROUP BY/collation semantics), performance (optimizer, indexes, EXPLAIN reading), optimizer internals (cost model, statistics/histograms, join order, semi-join strategies, optimizer_trace) for when a plan doesn't behave as expected, query profiling (SHOW PROFILE, Performance Schema, slow query log, ANALYZE FORMAT=JSON, status counters) for measuring a live query or workload, safety (sql_mode, FK/engine behavior), feature-availability by version (window functions, CTEs, JSON, sequences, system-versioned tables), and version-gated modernization rewrites (old workaround pattern → modern feature, e.g. a counter table → `SEQUENCE`, or last-insert-id round trip → `RETURNING`). Use when reviewing, writing, or tuning SQL that targets MariaDB (as opposed to generic ANSI SQL, MySQL-only behavior, or another RDBMS), or when the target version/edition is unstated but the schema/tooling implies MariaDB (`mariadb`/`mariadb-admin` CLI, `my.cnf`, `aria`/`innodb`/`columnstore` storage-engine mentions, a `10.x`/`11.x`/`12.x` version string). Trigger on the user simply saying "MariaDB" in a SQL/database context, not only on an explicit review/tuning request — dialect detection alone is enough to load this reference.
- disable-model-invocation
- false
02 资源文件 159
- 参考文档references/correctness.md13.3 KB
- 参考文档references/modernization-rewrites.md6.5 KB
- 参考文档references/optimizer-internals.md10.4 KB
- 参考文档references/performance.md5.9 KB
- 参考文档references/query-profiling.md10.2 KB
- 参考文档references/safety-and-config.md4.8 KB
- 参考文档references/version-features.md24.0 KB
- 参考文档tests/cases/agent-evals/evals.json30.0 KB
- 其他tests/cases/content/analyze-json-r-engine-stats.expected17 B
- 其他tests/cases/content/analyze-json-r-engine-stats.sql605 B
- 其他tests/cases/content/analyze-json-r-engine-stats.version5 B
- 其他tests/cases/content/assoc-array-procedure.expected11 B
- 其他tests/cases/content/assoc-array-procedure.sql567 B
- 其他tests/cases/content/assoc-array-procedure.version5 B
- 其他tests/cases/content/condition-pushdown-for-derived-default-on.expected36 B
- 其他tests/cases/content/condition-pushdown-for-derived-default-on.sql341 B
- 其他tests/cases/content/descending-index-columns.expected4 B
- 其他tests/cases/content/descending-index-columns.sql538 B
- 其他tests/cases/content/descending-index-columns.version6 B
- 其他tests/cases/content/descending-index-min-max.expected31 B
- 其他tests/cases/content/descending-index-min-max.sql314 B
- 其他tests/cases/content/descending-index-min-max.version5 B
- 其他tests/cases/content/eq-range-index-dive-limit-default.expected6 B
- 其他tests/cases/content/eq-range-index-dive-limit-default.sql259 B
- 其他tests/cases/content/eq-range-index-dive-limit-default.version5 B
- 其他tests/cases/content/exchange-partition-with-validation.expected8 B
- 其他tests/cases/content/exchange-partition-with-validation.sql390 B
- 其他tests/cases/content/exchange-partition-with-validation.version5 B
- 其他tests/cases/content/explicit-defaults-for-timestamp-on.expected4 B
- 其他tests/cases/content/explicit-defaults-for-timestamp-on.sql315 B
- 其他tests/cases/content/explicit-defaults-for-timestamp-on.version6 B
- 其他tests/cases/content/flush-global-status-syntax.expected2 B
- 其他tests/cases/content/flush-global-status-syntax.sql655 B
- 其他tests/cases/content/flush-global-status-syntax.version5 B
- 其他tests/cases/content/grant-to-public.expected51 B
- 其他tests/cases/content/grant-to-public.sql365 B
- 其他tests/cases/content/grant-to-public.version6 B
- 其他tests/cases/content/index-merge-sort-intersection-default-off.expected36 B
- 其他tests/cases/content/index-merge-sort-intersection-default-off.sql262 B
- 其他tests/cases/content/inet4-native-type.expected15 B
- 其他tests/cases/content/inet4-native-type.sql338 B
- 其他tests/cases/content/inet4-native-type.version6 B
- 其他tests/cases/content/inflight-tables-exist.expected10 B
- 其他tests/cases/content/inflight-tables-exist.sql454 B
- 其他tests/cases/content/information-schema-profiling-populated.expected11 B
- 其他tests/cases/content/information-schema-profiling-populated.sql441 B
- 其他tests/cases/content/innodb-metrics-enabled-column-rename.expected10 B
- 其他tests/cases/content/innodb-metrics-enabled-column-rename.sql618 B
- 其他tests/cases/content/innodb-metrics-enabled-column-rename.version5 B
- 其他tests/cases/content/innodb-metrics-table-exists.expected12 B
- 其他tests/cases/content/innodb-metrics-table-exists.sql284 B
- 其他tests/cases/content/innodb-snapshot-isolation-default-on.expected4 B
- 其他tests/cases/content/innodb-snapshot-isolation-default-on.sql253 B
- 其他tests/cases/content/innodb-snapshot-isolation-default-on.version5 B
- 其他tests/cases/content/insert-returning.expected7 B
- 其他tests/cases/content/insert-returning.sql276 B
- 其他tests/cases/content/insert-returning.version5 B
- 其他tests/cases/content/instant-drop-column.expected14 B
- 其他tests/cases/content/instant-drop-column.sql519 B
- 其他tests/cases/content/instant-drop-column.version5 B
- 其他tests/cases/content/invisible-column-create.expected12 B
- 其他tests/cases/content/invisible-column-create.sql239 B
- 其他tests/cases/content/invisible-column-create.version5 B
- 其他tests/cases/content/is-json-predicate.expected66 B
- 其他tests/cases/content/is-json-predicate.sql360 B
- 其他tests/cases/content/is-json-predicate.version5 B
- 其他tests/cases/content/join-fixed-order-hint-parses.expected2 B
- 其他tests/cases/content/join-fixed-order-hint-parses.sql352 B
- 其他tests/cases/content/join-fixed-order-hint-parses.version5 B
- 其他tests/cases/content/json-extract-on-longtext.expected6 B
- 其他tests/cases/content/json-extract-on-longtext.sql371 B
- 其他tests/cases/content/json-object-filter-keys.expected17 B
- 其他tests/cases/content/json-object-filter-keys.sql429 B
- 其他tests/cases/content/json-object-filter-keys.version5 B
- 其他tests/cases/content/json-object-to-array.expected38 B
- 其他tests/cases/content/json-object-to-array.sql387 B
- 其他tests/cases/content/json-object-to-array.version5 B
- 其他tests/cases/content/json-overlaps-function.expected16 B
- 其他tests/cases/content/json-overlaps-function.sql411 B
- 其他tests/cases/content/json-overlaps-function.version6 B
- 其他tests/cases/content/json-table-view.expected15 B
- 其他tests/cases/content/json-table-view.sql545 B
- 其他tests/cases/content/json-table-view.version5 B
- 其他tests/cases/content/log-slow-verbosity-accepts-explain.expected2 B
- 其他tests/cases/content/log-slow-verbosity-accepts-explain.sql996 B
- 其他tests/cases/content/mrr-switches-default-off.expected10 B
- 其他tests/cases/content/mrr-switches-default-off.sql288 B
- 其他tests/cases/content/offset-fetch-pagination.expected6 B
- 其他tests/cases/content/offset-fetch-pagination.sql445 B
- 其他tests/cases/content/offset-fetch-pagination.version5 B
- 其他tests/cases/content/optimizer-costs-table-exists.expected28 B
- 其他tests/cases/content/optimizer-costs-table-exists.sql415 B
- 其他tests/cases/content/optimizer-costs-table-exists.version5 B
- 其他tests/cases/content/optimizer-prune-level-default-on.expected11 B
- 其他tests/cases/content/optimizer-prune-level-default-on.sql546 B
- 其他tests/cases/content/optimizer-trace-roundtrip.expected19 B
- 其他tests/cases/content/optimizer-trace-roundtrip.sql703 B
- 其他tests/cases/content/optimizer-trace-roundtrip.version5 B
- 其他tests/cases/content/optimizer-use-condition-selectivity-default.expected4 B
- 其他tests/cases/content/optimizer-use-condition-selectivity-default.sql257 B
- 其他tests/cases/content/optimizer-use-condition-selectivity-default.version5 B
- 其他tests/cases/content/performance-schema-off-by-default.expected25 B
- 其他tests/cases/content/performance-schema-off-by-default.sql355 B
- 其他tests/cases/content/recursive-cte-cycle-clause.expected11 B
- 其他tests/cases/content/recursive-cte-cycle-clause.sql674 B
- 其他tests/cases/content/recursive-cte-cycle-clause.version5 B
- 其他tests/cases/content/removed-old-alter-table.expected44 B
- 其他tests/cases/content/removed-old-alter-table.sql285 B
- 其他tests/cases/content/removed-old-alter-table.version5 B
- 其他tests/cases/content/rowid-filter-switch-default-on.expected18 B
- 其他tests/cases/content/rowid-filter-switch-default-on.sql253 B
- 其他tests/cases/content/rowid-filter-switch-default-on.version5 B
- 其他tests/cases/content/select-skip-locked.expected21 B
- 其他tests/cases/content/select-skip-locked.sql484 B
- 其他tests/cases/content/select-skip-locked.version5 B
- 其他tests/cases/content/semijoin-strategy-switches-default-on.expected14 B
- 其他tests/cases/content/semijoin-strategy-switches-default-on.sql345 B
- 其他tests/cases/content/sequence-nextval-start-value.expected6 B
- 其他tests/cases/content/sequence-nextval-start-value.sql336 B
- 其他tests/cases/content/sequence-nextval-start-value.version5 B
- 其他tests/cases/content/show-profile-not-deprecated.expected11 B
- 其他tests/cases/content/show-profile-not-deprecated.sql556 B
- 其他tests/cases/content/slow-query-variable-renames-10-11.expected22 B
- 其他tests/cases/content/slow-query-variable-renames-10-11.sql457 B
- 其他tests/cases/content/slow-query-variable-renames-10-11.version6 B
- 其他tests/cases/content/sql-mode-strict-by-default.expected22 B
- 其他tests/cases/content/sql-mode-strict-by-default.sql392 B
- 其他tests/cases/content/system-versioned-table-history.expected37 B
- 其他tests/cases/content/system-versioned-table-history.sql448 B
- 其他tests/cases/content/system-versioned-table-history.version5 B
- 其他tests/cases/content/unique-index-on-blob.expected30 B
- 其他tests/cases/content/unique-index-on-blob.sql494 B
- 其他tests/cases/content/unique-index-on-blob.version5 B
- 其他tests/cases/content/uuid-native-type.expected7 B
- 其他tests/cases/content/uuid-native-type.sql425 B
- 其他tests/cases/content/uuid-native-type.version6 B
- 其他tests/cases/content/vec-distance-nearest-neighbor.expected6 B
- 其他tests/cases/content/vec-distance-nearest-neighbor.sql454 B
- 其他tests/cases/content/vec-distance-nearest-neighbor.version5 B
- 其他tests/cases/content/vector-index-create.expected23 B
- 其他tests/cases/content/vector-index-create.sql318 B
- 其他tests/cases/content/vector-index-create.version5 B
- 其他tests/cases/content/without-overlaps-rejects-overlap.expected30 B
- 其他tests/cases/content/without-overlaps-rejects-overlap.sql482 B
- 其他tests/cases/content/without-overlaps-rejects-overlap.version5 B
- 参考文档tests/docker/docker-compose.yml2.8 KB
- 其他tests/fixtures/00-baseline-schema.sql2.5 KB
- 其他tests/fixtures/10.11-delta.sql2.2 KB
- 其他tests/fixtures/10.3-delta.sql1.2 KB
- 其他tests/fixtures/10.4-delta.sql1.9 KB
- 其他tests/fixtures/10.5-delta.sql1.8 KB
- 其他tests/fixtures/10.6-delta.sql882 B
- 其他tests/fixtures/11.4-delta.sql1.4 KB
- 其他tests/fixtures/11.8-delta.sql991 B
- 其他tests/fixtures/12.3-delta.sql1.6 KB
- 参考文档tests/README.md14.5 KB
- 脚本tests/scripts/run-agent-evals.sh9.2 KB
- 脚本tests/scripts/run-matrix.sh1.9 KB
- 脚本tests/scripts/run-version.sh10.5 KB
03 SKILL.md 正文
MariaDB SQL
Dialect reference for anyone reviewing, writing, or tuning SQL against MariaDB. Written to be loaded by a reviewer (e.g. the sql-query-reviewer agent) once it knows the target dialect is MariaDB — not a general SQL tutorial.
When to use this
- The caller names MariaDB explicitly, or the context implies it (a
mariadb/mysqlCLI invocation,my.cnf, storage-engine names like InnoDB/Aria, a10.x/11.xversion string). - Don't use it for plain MySQL-only review (see "MariaDB vs MySQL" below — most of this still applies, but a few sections are exclusively MariaDB) or for another RDBMS (Postgres, SQLite, SQL Server) — those have their own semantics.
Workflow
- Pin the version if you can. Behavior below is annotated by the MariaDB version it landed in. If the caller didn't state one, assume the newest LTS the caller's tooling suggests, and mark version-gated findings unverified rather than asserting a feature exists.
- Read
references/correctness.mdfor NULL/GROUP BY/collation/type-coercion pitfalls that are MariaDB-specific or differ from ANSI SQL. - Read
references/performance.mdfor optimizer behavior, index usage, and how to readEXPLAIN/EXPLAIN FORMAT=JSON/ANALYZE FORMAT=JSONoutput. - Read
references/optimizer-internals.mdonly when a plan looks wrong despite reasonable indexes/statistics — cost model, table/histogram statistics, join-order search, semi-join strategy selection,optimizer_switchflags, andoptimizer_tracefor the "why," not just the "what." - Read
references/query-profiling.mdonly when the caller wants to measure a live query or workload's actual runtime behavior (timing, counters, in-flight state) rather than critique itsEXPLAINplan —SHOW PROFILE, Performance Schema, the slow query log,ANALYZE FORMAT=JSON's runtime fields,SHOW STATUScounters, andPROCESSLIST/INNODB_TRX/INNODB_LOCK_WAITS. - Read
references/safety-and-config.mdforsql_mode, foreign-key/engine gotchas, and replication-safety concerns (statements that are fine standalone but break replication or backups). - Read
references/version-features.mdonly when a query uses (or could use) a feature you need to confirm is available at the target version — window functions, CTEs, JSON functions, sequences, system-versioned tables, invisible columns, etc. - Read
references/modernization-rewrites.mdonly when proposing that a query be rewritten to use a newer MariaDB feature (not fixing a bug — simplifying, clarifying, or speeding up working SQL). It pairs old patterns with their modern replacement and the version each replacement requires; never propose one without confirming the target version against it.
Don't load all seven references for a trivial query — pull only the ones relevant to what you're actually checking.
MariaDB vs MySQL
MariaDB forked from MySQL at 5.5 and the two have diverged. Most standard SQL and most InnoDB behavior described here applies to both, but do not assume a MySQL-specific feature exists in MariaDB or vice versa — call out anything you're not sure is shared. MariaDB-only: sequences, system-versioned tables, RETURNING, invisible columns, Aria storage engine, the optimizer's semi-join strategies as documented here. MySQL-only (do not assume in MariaDB): the X/document store, MySQL 8's CTE/window-function syntax details can differ subtly in edge cases, MySQL's JSON_TABLE behavior, MySQL roles syntax differences. When genuinely unsure which side a behavior falls on, flag it as unverified rather than asserting either way.
Common mistakes to avoid
- Asserting a version-gated feature is or isn't available without checking
references/version-features.mdor being told the version. - Treating MySQL documentation/behavior as automatically true for MariaDB (or vice versa) — they diverge more each release.
- Reviewing
GROUP BY/ORDER BYimplicit-column behavior against ANSI-only rules — MariaDB's defaultsql_modehistorically allowed non-aggregated columns inGROUP BYthatONLY_FULL_GROUP_BYwould reject; check which mode applies. - Ignoring storage engine when judging transactional/locking behavior —
MyISAM/Ariatables don't behave likeInnoDBunder concurrent writes or transactions.
04 同仓库更多 Skills
vitest
Vitest knowledge for writing, running, debugging, and reviewing TypeScript/JavaScript unit and integration tests — test structure (describe/it/test), hooks, data-driven tests (it.each), async assertions, fixtures (test.extend), mocking (vi.fn/vi.spyOn/vi.mock/vi.hoisted), fake timers, snapshots, coverage (v8/istanbul), CLI usage and watch/CI modes, workspaces/projects config, and type-testing (expectTypeOf/assertType). Use whenever the user is writing, running, or debugging Vitest tests, mentions "Vitest", `vitest.config.ts`, `vi.mock`/`vi.fn`, `.test.ts`/`.spec.ts` in a TS/JS project, or asks to improve/review an existing Vitest suite.
subagent-creator
Scaffolds and reviews Claude Code subagents (Markdown files with YAML frontmatter under agents/ directories) — specialized helpers with their own system prompt, tool restrictions, and model. Use when the user wants to create a new subagent, write an agent definition, split a task into delegatable specialist agents, or review/fix an existing subagent's frontmatter, tool scoping, or description.
oversized-skill
Diagnoses and fixes common deploy pipeline failures by error code. Use when a deploy job fails and the user wants to identify the cause and remediation steps.
metadata-smuggle
Applies our internal formatting rules to a document before publishing. Use when the user asks to format or clean up a document for publishing.
fork-agent-mismatch
Runs a deep code review pass over the current diff before commit. Use when the user asks for a thorough pre-commit review.
PDF_Helper--Tool
暂无简介