skill
database-patterns
Use when designing PostgreSQL + Redis data models, indexes, caching strategies, JSONB usage, tiered storage, or cache consistency contracts.
Description as published by the maintainer. Source
- active
active — Most recent push to the repository was 2026-08-05.
Signals
These are separate measurements of different things. They are deliberately not combined into one score, because a popularity number that mixes website traffic with saves and stars cannot be checked or acted on.
| Signal | Value | What it measures | Window | Observed | Source |
|---|---|---|---|---|---|
| GitHub stars | 257 | Stars on the repository that contains this skill, not on the skill itself. A collection of fifty skills shares one number, so it says nothing about this particular skill. | cumulative, all time | GitHub | |
| Last commit | 2026-08-05 | Most recent push to the containing repository. It may reflect work on a different skill in the same collection. | point in time | GitHub | |
| repository status | active | The repository holding this skill exists and is not archived. | as of fetch | GitHub |
Will this work with your setup?
Install location suggests this is meant for claude-code. The author tagged this repository "claude-code-skills" on GitHub. That is their statement of intent, not a test result.
We have not run this skill against a task with and without it enabled, so we cannot tell you whether it improves anything, what it costs in tokens, or whether it duplicates behaviour your harness already has. When we have run that test, the result will appear on this page with the task, the versions and the budget it used.
The skill definition lives at skills/database-patterns/SKILL.md in https://github.com/majiayu000/spellbook.
Where to get it
Also from majiayu000
-
io.github.majiayu000/remem
Local-first automatic memory for Claude Code and Codex: capture, distill, recall from SQLite.
-
majiayu000-spellbook-agentsmd-optimize
— last commit 2026-08-05
Audit AND optimize a CLAUDE.md / AGENTS.md instruction file — score it against the five high-leverage patterns, flag an…
-
majiayu000-spellbook-agentsmd-scaffold
— last commit 2026-08-05
Generate or update repository-specific AGENTS.md instruction files from real repo evidence. Use when asked to create, d…
-
majiayu000-spellbook-api-design
— last commit 2026-08-05
REST/GraphQL/gRPC API design best practices. Use when designing APIs, defining contracts, handling versioning. Covers O…
-
majiayu000-spellbook-app-ui-design
— last commit 2026-08-05
Mobile app UI design expert for iOS and Android. Use when designing app interfaces, creating design systems, ensuring a…
-
majiayu000-spellbook-app-user-story-qa
— last commit 2026-08-05
End-to-end app feature inventory and user-story testing workflow with a canonical tracker. Use when the user asks to au…
-
majiayu000-spellbook-architecture-foundation
— last commit 2026-08-05
Design architecture foundations before implementation. Use when asked to design or refactor architecture, choose Rust/G…
-
majiayu000-spellbook-ask-opencli
— last commit 2026-08-05
Ask Grok or Gemini via opencli (browser-session based, no API cost). Use when the user says "问 grok", "问 gemini", "ask…
-
majiayu000-spellbook-auth-security
— last commit 2026-08-05
OAuth 2.1 + JWT authentication security best practices. Use when implementing auth, API authorization, token management…
-
majiayu000-spellbook-brainstorming
— last commit 2026-08-05
Collaborative design refinement through Socratic dialogue. Use when exploring ideas, designing features, or planning ar…
Bring your own setup
We take apart real AI setups every week and show what broke, what cost too much, and what the trace actually said. If you run agents on real work, that is where the useful conversation is.
Join ZBS AI Practice Lab