Skip to content
Skillpedia
Misc48k · #3622

tech-matrix

Provides access to a reference document about Monopoly's 'tech-matrix'. It's useful for looking up specific technologies within that context.

What it does

This tool helps choose the right technology for different parts of a software project, like databases, messaging systems, or API protocols. It provides tables and a guide to aid decision-making.

When to use it

  • ✓When starting a new software project and needing to select technologies.
  • ✓When evaluating if the current technology is still the best fit.
  • ✓When comparing different database or messaging system options.

Example of what to ask your AI

“Which database is best for storing geographic location data?”

Want more? Open the sections below.

How to use

The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.

Skill link

https://github.com/sickn33/agentic-awesome-skills/blob/main/plugins/agentic-awesome-skills-claude/skills/monopoly/tech-matrix/SKILL.md

Ready-to-paste message

Use this skill to help me: https://github.com/sickn33/agentic-awesome-skills/blob/main/plugins/agentic-awesome-skills-claude/skills/monopoly/tech-matrix/SKILL.md Read the SKILL.md file at that link and follow its instructions for my task.
How it works

The tool compares popular technologies in categories like databases, caching, and message queues. It shows what each is good for, when to avoid it, and its scaling limits, helping you make an informed choice.

Installation

Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.

In the terminal (Claude Code, Codex, Cursor), in your project folder:

npx skills add sickn33/agentic-awesome-skills --skill tech-matrix

Or download just the file:

curl -L https://raw.githubusercontent.com/sickn33/agentic-awesome-skills/main/plugins/agentic-awesome-skills-claude/skills/monopoly/tech-matrix/SKILL.md -o SKILL.md
Technical content (original SKILL.md)

Original text by the author, straight from GitHub.

MONOPOLY — Technology Decision Matrix

When to Use

  • Use this skill when the task matches this description: Reference document for monopoly tech-matrix.

Table of Contents

  1. Database Selection
  2. Cache Selection
  3. Message Queue / Event Streaming
  4. API Protocol
  5. Search Engine
  6. Object Storage
  7. Container Orchestration
  8. Load Balancer
  9. Observability Stack
  10. CDN

1. Database Selection

Relational (SQL)

Database Best For Avoid When Scale Ceiling
PostgreSQL Complex queries, JSONB, GIS, strong consistency, most default use cases Ultra-high write throughput (>100K writes/s) ~10TB single node; use Citus for horizontal
MySQL / MariaDB Read-heavy apps, legacy systems, WordPress/Drupal ecosystem Complex queries, full ACID at scale ~10TB; use Vitess for sharding
CockroachDB Global distributed SQL, geo-partitioning, multi-region Simple single-region apps (overkill) Petabyte-scale
PlanetScale MySQL-compatible, serverless, branch-based workflow Complex JOINs (foreign keys removed by design) Very high — Vitess based
Amazon Aurora AWS-native apps, managed PostgreSQL/MySQL, high availability Non-AWS environments Up to 128TB, 15 replicas

NoSQL

Database Best For Avoid When Scale Ceiling
MongoDB Flexible schema, document model, prototyping Financial transactions requiring ACID Petabyte-scale with sharding
DynamoDB Key-value at massive scale, AWS-native, serverless, predictable latency Complex queries, ad-hoc analytics, JOINs Unlimited (AWS-managed)
Cassandra Write-heavy, time-series, wide-column, geographically distributed Read-heavy with complex queries Petabyte-scale; used at Apple, Netflix
Redis Cache, sessions, leaderboards, pub/sub, rate limiting Primary data store for complex models ~1TB per node; cluster for more
Elasticsearch Full-text search, log aggregation, analytics Primary database (durability risk) Petabyte-scale with clusters
InfluxDB Time-series metrics, IoT, monitoring data General-purpose data Very high write throughput
Neo4j Graph data, social networks, recommendation engines, fraud detection Non-graph data (overhead not worth it) Billions of nodes

Decision Framework

Is your data relational (joins, foreign keys, transactions)?
  YES → Start with PostgreSQL
  NO  → Continue below

Is your primary access pattern key-value?
  YES, need extreme scale → DynamoDB or Cassandra
  YES, need speed/cache → Redis

Is your data document-shaped (nested, flexible schema)?
  YES → MongoDB

Is it time-series (metrics, logs, IoT)?
  YES → InfluxDB or TimescaleDB

Is it graph (relationships are the data)?
  YES → Neo4j

Is it search?
  YES → Elasticsearch / OpenSearch

2. Cache Selection

Technology Best For Max Single Node Cluster Support
Redis Sessions, leaderboards, pub/sub, complex data structures, Lua scripting ~1TB RAM Yes (Redis Cluster, Redis Sentinel)
Memcached Simple key-value, multi-threaded, large object cache ~64GB RAM Yes (client-side sharding)
Varnish HTTP reverse proxy cache, full-page caching RAM bound Limited
CloudFront / CDN Static assets, edge caching globally N/A (distributed) Built-in global distribution

Default recommendation: Redis — more features, better ecosystem, active development.

Use Memcached only when: you need multi-threading for CPU-bound caching workloads and don't need data structures beyond string.


3. Message Queue / Event Streaming

Technology Model Best For Throughput Retention
Apache Kafka Log-based streaming Event sourcing, high-throughput pipelines, replay, audit Millions msg/s Days to forever
RabbitMQ AMQP message broker Task queues, RPC, routing, fanout 50K–100K msg/s Until consumed
AWS SQS Managed queue AWS-native, simple task queue, serverless Very high (managed) Up to 14 days
AWS SNS Pub/sub notification Fan-out to many subscribers (email, SMS, Lambda, SQS) Very high (managed) No retention

…

FAQ

What is a relational database?

It's a type of database that organizes data into tables with rows and columns, like a spreadsheet, and allows you to link information between them.

What is a NoSQL database?

It's a type of database that doesn't use the traditional table format. It's more flexible and good for large data volumes or data with varied structures.

What is an 'API protocol'?

It's a set of rules that defines how different software programs can communicate with each other, like a common language for exchanging information.

Details

Original description by the author

Reference document for monopoly tech-matrix.

repo: sickn33/agentic-awesome-skills

Popularity

GitHub stars
48k
Ranking position
#3622
License
MIT
Updated
10/15/2026

Is this skill useful?

0

Sign in to vote.

Comments

  • …

More skills from this repository

Similar skills