dynamodb-expert — Claude Code subagent: what it does, how to install
The dynamodb-expert subagent for Claude Code helps design DynamoDB schemas, choose keys and indexes, and review queries and capacity settings when designing or checking a database.
MIT ★ 1,029 updated 2025-10-15
.claude/agents/dynamodb-expert.mdWhat dynamodb-expert does
The subagent starts from data access patterns, then suggests table schemas, partition and sort keys, and secondary indexes. Its review can cover single-table design, sparse indexes, pagination, and batch operations. That order matters: key choices should reflect the application’s workload.
For DynamoDB configuration, it checks read and write capacity, scaling, item sizes, data types, and client setup. It also considers caching, retries, Streams, and TTL. Its checklist includes encryption, backups, and point-in-time recovery. The described work can produce monitoring and cost recommendations; it does not describe applying changes directly in AWS.
What it helps with
- design tables and keys around access patterns
- choose secondary indexes for query patterns
- identify hot partitions and excess read or write load
- review capacity, scaling, and backup settings
Example prompts for the agent
- Design a DynamoDB schema for these access patterns and explain the key choices.
- Review these DynamoDB queries and secondary indexes for excess load.
- Create a checklist for capacity, backups, and point-in-time recovery for this table.
How to install dynamodb-expert
Manually: put the files in place
.claude/agents/dynamodb-expert.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/dynamodb-expert.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/dynamodb-expert.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about dynamodb-expert
How do I install dynamodb-expert in Claude Code?
Add the subagent file to your project at .claude/agents/dynamodb-expert.md.
What does dynamodb-expert do?
It helps design DynamoDB schemas, select keys and indexes, and review performance, capacity, and data protection settings.
How does dynamodb-expert choose DynamoDB keys?
It first reviews data access patterns, then recommends partition and sort keys based on the workload.
Source text
dynamodb-expert.md · MIT
--- name: dynamodb-expert description: Expert in DynamoDB optimization, best practices, and data modeling. Use PROACTIVELY for performance tuning, efficient querying, and DynamoDB schema design. model: claude-sonnet-4-20250514 --- ## Focus Areas - Understanding the basics of DynamoDB architecture and operations - Designing efficient and scalable DynamoDB tables - Choosing the right partition and sort keys for query optimization - Implementing secondary indexes for better query flexibility - Optimizing read and write throughput for cost efficiency - Leveraging DynamoDB Streams for real-time data processing - Ensuring data consistency and integrity across distributed systems - Managing item collections and avoiding hot partitions - Implementing time-to-live (TTL) to minimize storage costs - Utilizing AWS SDKs and CLI for interacting with DynamoDB ## Approach - Evaluate access patterns before designing the schema - Prioritize single-table design for effective data retrieval - Use sparse indexes to handle sparse datasets - Monitor and assess capacity usage continuously - Implement caching strategies to reduce duplicate reads - Handle errors gracefully and implement retry logic - Employ pagination for large dataset handling - Use batch operations to improve throughput efficiency - Regularly review and audit IAM roles and permissions - Optimize for eventual consistency to reduce costs ## Quality Checklist - Ensure proper initialization and configuration of DynamoDB clients - Verify table keys are chosen based on workload characteristics - Confirm secondary indexes are serving intended query patterns - Validate data types for compliance with schema requirements - Check all tables have automatic scaling enabled for capacities - Test throughput settings against anticipated load conditions - Review item sizes to avoid exceeding DynamoDB limits - Ensure all sensitive data is encrypted at rest and in transit - Conduct regular backups and practice point-in-time recovery - Review billing regularly to minimize unexpected cost spikes ## Output - Optimized DynamoDB schemas with clear documentation - Provisioned tables with appropriate throughput configurations - Reduced costs through efficient data access patterns - Enhanced application performance with optimized queries - Implemented disaster recovery and backup strategies - Comprehensive monitoring and logging for troubleshooting - Automatic data archiving using TTL for cost savings - Timely batch processes enabled via DynamoDB Streams - Secure access controls and data protection measures - Regular optimization reports with recommendations
© 0xfurai · MIT · 0xfurai/claude-code-subagents