Skip to main content
subagent CX Codex

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

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/dynamodb-expert.md
Open on GitHub

What 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.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

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

Similar subagents

All subagents for Data and databases →

From the same set137

The whole set →
tailwind-expert The tailwind-expert subagent for Claude Code guides responsive Tailwind CSS styling, theme setup, and PurgeCSS cleanup for web projects. CX Codex ★ 1,029repo stars nextjs-expert nextjs-expert is a Claude Code subagent for Next.js work across SSR, SSG, API routes, and React apps. It joins tasks involving routing, data loading, and app checks. CX Codex ★ 1,029repo stars mongodb-expert mongodb-expert — a Claude subagent for MongoDB work: schema design, indexes, aggregation pipelines, replication, backups and migrations. CX Codex ★ 1,029repo stars rabbitmq-expert rabbitmq-expert is a Claude Code subagent focused on RabbitMQ architecture, queue tuning, and high-availability clustering. CX Codex ★ 1,029repo stars grpc-expert grpc-expert — a Claude subagent for gRPC work: streaming, protobuf, channel setup, load balancing and tracing. Useful when calls fail with vague status codes. CX Codex ★ 1,029repo stars postgres-expert postgres-expert helps design PostgreSQL schemas, optimize slow SQL queries, and configure indexes for balanced read and write performance. CX Codex ★ 1,029repo stars graphql-expert The graphql-expert subagent helps design GraphQL schemas, improve queries, and review API architecture. Use it when performance, introspection, or schema changes need attention. CX Codex ★ 1,029repo stars nodejs-expert nodejs-expert — a Claude subagent for server-side Node.js work: async patterns, streams, Express APIs, profiling. Tests, linting and a dependency audit are part of its brief. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open