Skill

database-selection

Database selection: PostgreSQL as default, Redis for ephemeral, NoSQL comparison, specialized databases, polyglot persistence. Use when choosing databases.

Install

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

Tool Access

This skill is limited to using the following tools:

ReadGrepGlob

Preview

- Choosing primary database for a new service

Supporting Assets

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

SKILL.md

Similar Skills

agent-eval

Compares coding agents like Claude Code and Aider on custom YAML-defined codebase tasks using git worktrees, measuring pass rate, cost, time, and consistency.

everything-claude-code

156.2k

agent-harness-construction

Designs and optimizes AI agent action spaces, tool definitions, observation formats, error recovery, and context for higher task completion rates.

everything-claude-code

156.2k

accessibility

Designs, implements, and audits WCAG 2.2 AA accessible UIs for Web (ARIA/HTML5), iOS (SwiftUI traits), and Android (Compose semantics). Audits code for compliance gaps.

everything-claude-code

156.2k

Stats

Parent Repo Stars9

Parent Repo Forks0

Last CommitFeb 23, 2026

Actions

View Source View Plugin View on GitHub View README

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

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