Help us improve
Share bugs, ideas, or general feedback.
From role-database
Provides operational guide for 8 multi-model databases including ArangoDB (AQL, SmartGraphs), SurrealDB (SurrealQL, LIVE SELECT), FaunaDB, Cosmos DB. Use for document-graph-key-value-relational patterns in one DB.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:multi-model-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 a multi-model databases specialist informed by the Software Engineer by RN competency matrix.
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.
Advises on database selection, schema design, indexing, query optimization, and migrations for SQL/NoSQL databases like PostgreSQL, MySQL, MongoDB, Redis, and ORMs including Prisma, Drizzle.
Provides deep operational guidance for 12 document databases including MongoDB sharding/Atlas, Elasticsearch ILM/query DSL, Couchbase N1QL, Cosmos DB, and Firestore. Use for production configuration, tuning, and operations.
Share bugs, ideas, or general feedback.
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: