AWS DynamoDB

Tools · 8

• dynamodb_data_modeling Retrieves the complete DynamoDB Data Modeling Expert prompt with enterprise-level design patterns, cost optimization strategies, and multi-table design philosophy. Guides through requirements gathering, access pattern analysis, and schema design.
• dynamodb_data_model_validation Validates your DynamoDB data model by loading dynamodb_data_model.json, setting up DynamoDB Local, creating tables with test data, and executing all defined access patterns. Saves detailed validation results to dynamodb_model_validation.json.
• source_db_analyzer Analyzes existing databases (MySQL, PostgreSQL, SQL Server, Oracle) to extract schema structure, access patterns, and generates timestamped analysis files for use with dynamodb_data_modeling. Supports both RDS Data API-based access and connection-based access for MySQL.
• generate_resources Generates various resources from the DynamoDB data model JSON file (dynamodb_data_model.json). Currently only the `cdk` resource type is supported. Passing `cdk` as `resource_type` parameter generates a CDK app to deploy DynamoDB tables.
• dynamodb_data_model_schema_converter Converts your data model (dynamodb_data_model.md) into a structured schema.json file representing your DynamoDB tables, indexes, entities, fields, and access patterns. This machine-readable format is used for code generation and can be extended for other purposes.
• dynamodb_data_model_schema_validator Validates schema.json files for code generation compatibility. Checks field types, operations, GSI mappings, pattern IDs, and provides detailed error messages with fix suggestions. Ensures your schema is ready for the generate_data_access_layer tool.
• generate_data_access_layer Generates type-safe Python code from schema.json including entity classes with field validation, repository classes with CRUD operations, fully implemented access patterns, and optional usage examples. The generated code uses Pydantic for validation and boto3 for DynamoDB operations.
• compute_performances_and_costs Calculates DynamoDB capacity units (RCU/WCU) and monthly costs from access patterns. Analyzes all DynamoDB operations, tracks GSI additional writes, and calculates storage costs. Appends a comprehensive cost report to dynamodb_data_model.md.