sqlx-knowledge-patch
Installation
SKILL.md
SQLx Knowledge Patch
Covers SQLx 0.8.3–0.9.0-alpha.1 (2025-01-03 through 2025-10-14). Claude Opus 4.6 knows SQLx through 0.7.x. It is unaware of the 0.8+ features and 0.9 breaking changes below.
Index
| Topic | Reference | Key features |
|---|---|---|
| Transactions | references/transactions.md | begin_with, per-DB option types, is_in_transaction, type aliases |
| Type system & macros | references/type-system.md | SqlSafeStr, Arguments lifetime removal, smart pointer Encode/Decode, PgBindIter, PgHasArrayType auto-derive, json(nullable), transparent named structs |
| SQLite | references/sqlite.md | Commit/rollback/preupdate hooks, feature flags (sqlite-deserialize, sqlite-load-extension, sqlite-unlock-notify), sqlite-unbundled, no_tx migrations |
| Postgres & MySQL | references/postgres-and-mysql.md | Geometry types, ipnet support, PgConnectOptions auto-escaping, MySQL collation inference, PgListener improvements |
| Configuration & runtime | references/configuration.md | sqlx.toml, MSRV 1.86, runtime feature changes, Migrator::with_migrations, RawSql type parameter |
0.8 → 0.9 Migration — Breaking Changes
Note: 0.9.0-alpha.1 is the current alpha. Many breaking changes from 0.8.x.