Individual skill
data-layer-footguns
Room/SQLite, DataStore and repository traps: migrations, NOT IN with NULLs, LIKE escaping, delete order, local-time bucketing, imports, caching, paging. Use before writing a query or migration, or when data comes back wrong.
skills/data-layer-footguns/SKILL.md
Source commit 2c391bc9c9f873580aa855d7a7b1c3a2ed9e68ae
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Network or broad shell
- Last checked
- Nov 9, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 2,201
- Repository last updated
- Oct 29, 2026
- License
- GPL-3.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai-agents Repository topic
- android Repository topic
- claude-code Repository topic
- compose-multiplatform Repository topic
- jetpack-compose Repository topic
- kotlin Repository topic
- kotlin-multiplatform Repository topic
- writing Derived category
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 17,005 bytesSKILL.mdcore · 17,005 bytesSKILL.mdcore · 17,005 bytesreferences/bucket-local-time-in-code-not-in-sql.mddoc · 6,895 bytesreferences/bulk-json-import-progress.mddoc · 7,343 bytesreferences/cache-then-network.mddoc · 6,299 bytesreferences/cascading-delete-ordering.mddoc · 6,624 bytesreferences/clean-satellite-at-transition.mddoc · 5,050 bytesreferences/continuation-token-pagination-contract.mddoc · 7,356 bytesreferences/datastore-kmp-manager.mddoc · 7,911 bytesreferences/encoded-continuation-tokens-local-sort.mddoc · 8,593 bytesreferences/first-ever-not-first-in-window.mddoc · 6,884 bytesreferences/generic-paged-db-accumulator.mddoc · 6,451 bytesreferences/import-format-contract-design.mddoc · 8,704 bytesreferences/inclusive-period-boundaries-and-offset-reset.mddoc · 7,638 bytesreferences/like-wildcard-escaping-ids.mddoc · 5,486 bytesreferences/local-listening-analytics.mddoc · 8,323 bytesreferences/mirror-local-state-to-a-remote-account.mddoc · 8,322 bytesreferences/order-preserving-section-mapping.mddoc · 5,615 bytesreferences/remote-index-cached-as-rows-with-validator.mddoc · 7,498 bytesreferences/repository-flow-conventions.mddoc · 7,234 bytesreferences/room-kmp-setup.mddoc · 7,732 bytesreferences/room-migrations-at-scale.mddoc · 8,980 bytesreferences/room-rawquery-readonly-vacuum.mddoc · 5,092 bytesreferences/search-over-a-paged-list-queries-the-source.mddoc · 7,604 bytesreferences/sql-not-in-nullable-trap.mddoc · 5,023 bytesreferences/stored-timestamp-is-a-local-wall-clock.mddoc · 8,179 bytesreferences/ttl-keyed-json-cache-lenient-decode.mddoc · 6,543 bytesreferences/unbounded-for-shares-capped-for-lists.mddoc · 6,746 bytes
No licensed excerpt is available. You can inspect the pinned source.