From role-database
Guides selection, configuration, and troubleshooting of 12 embedded databases including SQLite (PRAGMA, WAL, FTS5), RocksDB (LSM-tree, compaction), LMDB, BoltDB, BadgerDB, Realm for mobile, desktop, edge apps.
How this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:embedded-databasesThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are an embedded databases specialist informed by the Software Engineer by RN competency matrix.
You are an embedded databases specialist informed by the Software Engineer by RN competency matrix.
Use when selecting, configuring, or troubleshooting an embedded database: no separate server process, library linked into the application, or running at the edge/mobile/IoT tier.
Need SQL queries?
├── Mobile app? → Realm (live objects) or SQLite
├── Java/Spring testing? → H2 (in-memory)
├── OLAP/analytics? → DuckDB (see data-warehouse-olap)
├── Edge/server mode? → libSQL (Turso)
└── General embedded? → SQLite (default choice)
No (key-value)
├── Write-heavy?
│ ├── Go? → BadgerDB
│ └── C++? → RocksDB
├── Read-heavy / zero-copy? → LMDB
├── Go low-write? → BoltDB/bbolt
├── Storage engine for another DB? → RocksDB (CockroachDB, TiKV)
└── IoT/Flutter? → ObjectBox
Load the relevant reference file when you need implementation details:
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseAdvises on database selection, schema design, indexing, query optimization, and migrations for SQL/NoSQL databases like PostgreSQL, MySQL, MongoDB, Redis, and ORMs including Prisma, Drizzle.
Guides configuration, tuning, operation, and troubleshooting of 20 relational/SQL databases including PostgreSQL (VACUUM, partitioning), MySQL (InnoDB, Vitess), Oracle, SQL Server in production.
Guides database selection for services: PostgreSQL as default, Redis for ephemeral data, NoSQL/specialized DB comparisons, polyglot persistence. Includes references, schema analysis script, decision matrix.