Skill

database-selection

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.

PostgreSQL

npx claudepluginhub rnavarych/alpha-engineer --plugin billy-milligan

Popularity

Parent stars

Parent forks

Invocation

How this skill is triggered — by the user, by Claude, or both

Slash command

/billy-milligan:database-selection

User invocable

Model invocable

Inline context

Default effort

Tool Access

This skill is limited to the following tools:

ReadGrepGlob

Context Preview

The summary Claude sees in its skill listing — used to decide when to auto-load this skill

- Choosing primary database for a new service

Supporting Files

assets/database-decision-matrix.mdreferences/multi-database-patterns.mdreferences/nosql-comparison.mdreferences/relational-comparison.mdreferences/specialized-databases.mdscripts/analyze-data-model.sh

SKILL.md

34 lines · ~381 tokens

Similar Skills

alpha-core:database-advisor

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.

4 files4 tools

alpha-core

nw-database-technology-selection

500

Guides database selection with RDBMS vs NoSQL catalogs, CAP/ACID/BASE theory, OLTP/OLAP distinctions, and specifics for PostgreSQL, MySQL, MongoDB, Redis, DynamoDB.

role-database:multi-model-databases

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.

4 files4 tools

role-database

Stats

LanguageShell

Parent stars13

Parent forks1

MaintenanceExcellent

Last CommitMar 5, 2026

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

Stats

Actions

Help us improve

Share bugs, ideas, or general feedback.

Database Selection

When to use

Choosing primary database for a new service

Adding a specialized database (cache, search, analytics, time-series)

Evaluating polyglot persistence or multi-database architecture

Core principles

PostgreSQL is the default — handles 10k TPS, JSONB, full-text search, extensions

Add databases for specific access patterns — not because it's trendy

Every additional database doubles operational complexity — worth it only for clear ROI

Consistency model is a product decision — strong vs eventual affects user experience

Benchmark with YOUR data — vendor benchmarks are meaningless for your workload

References available

references/relational-comparison.md — Postgres vs MySQL vs SQLite vs CockroachDB

references/nosql-comparison.md — MongoDB vs DynamoDB vs Cassandra vs Redis use cases

references/specialized-databases.md — TimescaleDB, Neo4j, Pinecone, pgvector, Elasticsearch

references/multi-database-patterns.md — polyglot persistence, CQRS stores, data sync

Scripts available

scripts/analyze-data-model.sh — reads schema/migration files to suggest database fit

Assets available

assets/database-decision-matrix.md — fillable template: requirements → recommendation