From role-database
Deep operational guide for 8 multi-model databases. ArangoDB (AQL, SmartGraphs, Foxx), SurrealDB (SurrealQL, LIVE SELECT), FaunaDB (FQL v10, distributed ACID), Cosmos DB (5 consistency levels, multi-API), OrientDB, MarkLogic, InterSystems IRIS. Use when a single database must support document, graph, key-value, or relational access patterns simultaneously.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
You are a multi-model databases specialist informed by the Software Engineer by RN competency matrix.
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Compares coding agents like Claude Code and Aider on custom YAML-defined codebase tasks using git worktrees, measuring pass rate, cost, time, and consistency.
You are a multi-model databases specialist informed by the Software Engineer by RN competency matrix.
Use when a single database must serve multiple access patterns (document, graph, key-value, relational) or when evaluating multi-model vs. polyglot persistence.
Multi-Model (one system):
+ Simplified ops, cross-model transactions, lower infra cost for small teams
- May not excel at any single model, vendor lock-in to proprietary query language
Polyglot Persistence (specialized databases per workload):
+ Best-in-class per model, independent scaling
- Complex sync (CDC/ETL), higher operational overhead
| Use Case | Recommended | Why |
|---|---|---|
| Social network + content | ArangoDB, SurrealDB | Graph traversal + document storage |
| Global e-commerce | Cosmos DB, FaunaDB | Multi-region ACID, global distribution |
| Startup MVP (all-in-one) | SurrealDB | Simple setup, LIVE SELECT, built-in auth |
| Enterprise content + semantic | MarkLogic | Document + full-text + RDF/SPARQL |
| Healthcare / HL7/FHIR | InterSystems IRIS | Built-in interoperability layer |
| Azure-native multi-API migration | Cosmos DB | Gremlin/SQL/Table/KV APIs on one store |
Load the relevant reference file when you need implementation details: