loom-database-design
Database Design
Overview
This skill focuses on designing efficient, scalable, and maintainable database schemas and data models. It covers:
- OLTP Systems: Relational databases (PostgreSQL, MySQL) with normalization and transactional integrity
- OLAP Systems: Data warehouses with star/snowflake schemas for analytics
- NoSQL: Document stores (MongoDB), key-value (Redis), wide-column (Cassandra)
- Time-Series: Specialized databases for metrics and events (TimescaleDB, InfluxDB)
- Event Sourcing: Append-only event stores for audit and temporal queries
- Data Pipelines: Schema design considerations for ETL/ELT workflows
This skill incorporates data modeling expertise for both operational and analytical workloads.
Instructions
1. Understand Data Requirements
More from cosmix/claude-loom
data-validation
Data validation patterns including schema validation, input sanitization, output encoding, and type coercion. Use when implementing validate, validation, schema, form validation, API validation, JSON Schema, Zod, Pydantic, Joi, Yup, sanitize, sanitization, XSS prevention, injection prevention, escape, encode, whitelist, constraint checking, invariant validation, data pipeline validation, ML feature validation, or custom validators.
15refactoring
|
15logging-observability
Comprehensive logging and observability patterns for production systems including structured logging, distributed tracing, metrics collection, log aggregation, and alerting. Triggers for this skill - log, logging, logs, trace, tracing, traces, metrics, observability, OpenTelemetry, OTEL, Jaeger, Zipkin, structured logging, log level, debug, info, warn, error, fatal, correlation ID, span, spans, ELK, Elasticsearch, Loki, Datadog, Prometheus, Grafana, distributed tracing, log aggregation, alerting, monitoring, JSON logs, telemetry.
14event-driven
Event-driven architecture patterns including message queues, pub/sub, event sourcing, CQRS, and sagas. Use when implementing async messaging, distributed transactions, event stores, command query separation, domain events, integration events, data streaming, choreography, orchestration, or integrating with RabbitMQ, Kafka, Apache Pulsar, AWS SQS, AWS SNS, NATS, event buses, or message brokers.
14grafana
|
14prometheus
|
13