Explains and applies the database normal forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) and strategic denormalization, with worked examples in PostgreSQL, MySQL, SQLite, MongoDB, Cassandra, ScyllaDB, and DynamoDB. Use when users ask about normal forms, functional/multivalued/join dependencies, anomalies (insertion/update/deletion), schema design and refactoring, when they need help deciding how far to normalize a schema, or when they want a normalization concept translated into a specific database's modeling idioms (relational tables, MongoDB embedding/referencing, Cassandra/ScyllaDB query-driven tables, DynamoDB single-table design).
Explains and applies the 23 Gang of Four (GoF) design patterns with idiomatic code examples in Python, C, C++, Java, C#, JavaScript, Rust, Go, PHP, and Swift. Use when users ask about design patterns (singleton, factory, builder, observer, strategy, decorator, adapter, etc.), when they need help choosing a pattern for a design problem, when refactoring code toward a pattern, or when they want a pattern example in a specific language.
Explains and applies the object-oriented programming paradigm — classes, the four pillars (encapsulation, abstraction, inheritance, polymorphism), object relationships, SOLID, and design qualities — with idiomatic code examples in Python, C++, Java, C#, JavaScript, PHP, and Swift. Use when users ask about OOP concepts or SOLID principles, when they need help modeling a domain with classes and interfaces, when reviewing or refactoring class hierarchies, or when they want an OOP concept example in a specific language.
Explains and applies {domain, e.g. "the Gang of Four design patterns" / "the 12-factor app principles"} with idiomatic {guidance/examples} in {context, e.g. "Python, Java, Go, and Rust" or "system design"}. Use when users ask about {topic-1}, {topic-2}, {topic-3}, when they need help choosing {an item} for a design problem, when refactoring toward {an item}, or when they want {an item} example in a specific {language/context}.
Use when users ask how to {primary-capabilities}, especially when they need official {Product Name} documentation, exact links, or docs-grounded guidance.
Use when users ask how to install, configure, authenticate, script, filter output, troubleshoot, or run AWS CLI commands for AWS services, including profiles, credentials, SSO, IAM roles, regions, endpoints, JMESPath queries, output formats, pagination, retries, proxies, wizards, aliases, shell completion, or migration from AWS CLI v1 to v2, especially when they need official AWS CLI documentation, exact links, or docs-grounded command guidance.
Use when users ask how to create, model, query, index, secure, scale, stream, replicate, back up, cache, or troubleshoot Amazon DynamoDB tables and items, including partition keys, sort keys, GSIs, LSIs, on-demand or provisioned capacity, DynamoDB Streams, global tables, transactions, TTL, PartiQL, DAX, IAM access, or DynamoDB API behavior, especially when they need official Amazon DynamoDB documentation, exact links, or docs-grounded guidance.
Use when users ask how to create, configure, deploy, scale, network, secure, or troubleshoot Amazon ECS clusters, task definitions, services, and tasks, including Fargate, EC2 launch types, ECS Managed Instances, Service Connect, auto scaling, IAM roles, ECR integration, ECS Anywhere, or capacity providers, especially when they need official Amazon ECS documentation, exact links, or docs-grounded guidance.