itsmostafa/aws-agent-skills
Overview
This skill provides practical guidance and code patterns for designing, operating, and troubleshooting Amazon DynamoDB. It focuses on table schema design, query and batch operations, index configuration, capacity modes, and performance troubleshooting. The content includes CLI and boto3 examples to accelerate implementation and debugging.
How this skill works
I inspect common DynamoDB tasks and translate them into concise, ready-to-run examples and troubleshooting steps. The skill covers table creation, CRUD, queries, batch operations, GSIs/LSIs, conditional writes, and capacity handling with recommended CLI and Python (boto3) snippets. It also highlights best practices for data modeling, performance tuning, cost control, and operational diagnostics.
When to use it
- Designing table schemas and access patterns before development
- Implementing queries, batch reads/writes, and conditional writes with boto3
- Configuring GSIs, LSIs, and capacity (on‑demand vs provisioned)
- Troubleshooting throttling, hot partitions, slow scans, or missing query results
- Optimizing cost with TTL, archiving, and capacity autoscaling
Best practices
- Design for access patterns: model keys and indexes around queries you need
- Prefer Query over Scan; use projections and sparse indexes to reduce data transfer
- Distribute partition keys evenly to avoid hot partitions and use write sharding if needed
- Use on‑demand for unpredictable traffic and provisioned+autoscaling for predictable workloads
- Use batch operations and DAX for heavy read/write workloads to reduce latency and API calls
Example use cases
- Single-table design for related entities using composite PK/SK and item type attributes
- Creating a Users table with a PK/SK schema and implementing profile CRUD with boto3
- Adding an email GSI to support lookup by email address without restructuring the table
- Handling transient throttling with exponential backoff and adaptive retries
- Performing parallel scans to migrate or analyze large datasets while minimizing wall time
FAQ
Use on-demand for unpredictable or spiky workloads to avoid capacity planning. Use provisioned capacity with autoscaling when traffic is stable and you want lower cost per request.
Why does my Query return no items even though data exists?
Verify exact key values and types (case-sensitive and attribute data types), confirm the table or index name, and remember filter expressions are applied after reading items.
17 skills
This skill helps you design scalable DynamoDB schemas, optimize queries, and troubleshoot performance with best-practice guidance for keys, indexes, and
This skill helps design, orchestrate, and troubleshoot AWS Step Functions workflows with state machines, error handling, and parallel execution.
This skill helps you build AI applications with AWS Bedrock foundation models for text, embeddings, and RAG, enabling seamless model access and deployment.
This skill helps you manage AWS IAM resources by guiding policy creation, role setup, cross-account access, and troubleshooting permissions.
This skill helps you manage AWS EKS clusters, node groups, IRSA, and add-ons, enabling deployment and integration with AWS services.
This skill helps you configure and manage AWS SQS queues, DLQs, FIFO settings, and Lambda integration for decoupled architectures.
This skill helps you monitor AWS resources with CloudWatch, create alarms, query logs, and build dashboards for proactive observability.
This skill helps you provision, configure, and optimize AWS RDS databases with best practices for backups, high availability, and security.
This skill helps you manage EC2 instances, security groups, and networking securely and efficiently, enabling quick launches and reliable lifecycle automation.
This skill simplifies managing secrets with AWS Secrets Manager, enabling secure storage, rotation, and retrieval for applications.
This skill helps you manage AWS Lambda functions end-to-end, from creation to triggers, debugging, and performance optimization.
This skill helps you manage AWS SNS topics, subscriptions, and message filtering to reliably publish and route notifications.
This skill helps you deploy and manage containerized applications on AWS ECS, including clusters, task definitions, services, and troubleshooting.
This skill helps you configure and optimize AWS Cognito user pools and identity pools for secure authentication and scalable user management.
This skill helps you manage AWS S3 buckets and objects securely, enabling efficient uploads, lifecycle policies, and access control.
This skill helps you design, configure, and troubleshoot AWS API Gateway setups across REST, HTTP, and WebSocket APIs.
This skill helps you author, deploy, and troubleshoot AWS CloudFormation templates and stacks with best practices and drift detection.
