Skip to content

v2.0.0: dynamosb schema generation support

Choose a tag to compare

View all tags
@kraghavan kraghavan released this 27 Mar 06:49
v2.0.0
1109d8d

[2.0.1] - 2025-03-27

Added

  • DynamoDB AI Review Workflow

    • ClaudeAdvisor.review_dynamodb_design() — AI reviews local design
    • DynamoDBReview model — structured review with entity/GSI changes
    • apply_review() helper — merges AI suggestions into design
    • summarize_review_changes() — human-readable review summary

  • Consistent AI Flow

    • MongoDB: Claude as architect (designs schema)
    • DynamoDB: Claude as reviewer (validates local design)
    • Both targets now use AI when --use-ai (default)

Fixed

  • Table Alias Resolution (mutations.py)

    • SELECT u.* FROM users u now correctly tracks users table
    • New _extract_tables_with_aliases() method
    • Alias mapping passed to column extraction methods

  • DynamoDB Output Cleanup

    • No MongoDB-style EMBED/REFERENCE in DynamoDB output
    • recommendations=[] for DynamoDB (design in metadata)
    • Console skips recommendations table for DynamoDB

Technical

  • New module: recommender/dynamodb_review.py
  • New models: DynamoDBReview, EntityChange, GSIChange, GSIChangeAction, ReviewChangeType
  • Updated: claude_advisor.py, schema_generator.py, mutations.py, cli/main.py
  • AI reviews cached separately with _review suffix

[2.0.0] - 2025-03-26

Added

  • DynamoDB Single-Table Design Support

    • --target dynamodb option for DynamoDB schema generation
    • --dynamodb-mode [auto|single|multi] for design mode control
    • --dynamodb-output [json|terraform|nosql_workbench] for output formats

  • Access Cluster Analysis

    • Union-Find algorithm groups co-accessed tables
    • CO_ACCESS_THRESHOLD = 0.70 for single-table candidates
    • Automatic PK/SK pattern generation per entity

  • GSI Optimization

    • SELECT clause extraction for projection type decisions
    • KEYS_ONLY / INCLUDE / ALL based on actual column usage
    • Frequently filtered columns → GSI candidates
    • Max 5 GSIs per table (DynamoDB limit)

  • Output Formats

    • JSON: Full design with entities, GSIs, access patterns
    • Terraform HCL: Ready-to-deploy infrastructure code
    • NoSQL Workbench: Import-ready JSON format

  • New Modules

    • recommender/dynamodb_models.py — Pydantic models for DynamoDB
    • recommender/dynamodb_designer.py — Algorithmic design engine
    • recommender/dynamodb_output.py — Output formatters

  • Visualization

    • tools/visualize_schema.py updated for DynamoDB
    • Orange/black AWS-themed HTML output
    • Entity grid with PK/SK patterns
    • GSI table with projection types
Assets 2
Loading