AWS DynamoDB MCP Server: Setup for Claude, Cursor and Other Apps

• Guides you through designing a DynamoDB data model

  Loads an expert prompt that walks you through your access patterns and then designs tables and indexes. It saves a requirements file and a data model file in your project.

  Try: “Design a data model for my e-commerce app using the DynamoDB MCP server.”

  Files · dynamodb_data_modeling

• Studies an existing database to plan a move to DynamoDB

  Analyzes a MySQL, PostgreSQL, SQL Server or Oracle database for its schema and query patterns, and writes analysis files. In self-service mode you run the SQL yourself. Managed mode, for MySQL only, connects through the RDS Data API or a host.

  Try: “Analyze my MySQL database and help me design a DynamoDB data model.”

  Files · source_db_analyzer

• Tests your data model on a local DynamoDB

  Starts DynamoDB Local with Docker, Podman, Finch, nerdctl or Java, creates your tables with sample data, runs every access pattern and saves the results.

  Try: “Validate my DynamoDB data model.”

  Runs code · dynamodb_data_model_validation

• Estimates capacity and monthly cost

  Works out read and write capacity and monthly cost from your access patterns, including extra writes for indexes and storage. It appends the report to your data model file.

  Try: “Calculate the cost and performance for my DynamoDB data model.”

  Write · compute_performances_and_costs

• Turns your data model into a schema.json file

  Converts the data model document into a structured schema file and checks it, retrying up to 8 times.

  Try: “Convert my data model to schema.json for code generation.”

  Write · dynamodb_data_model_schema_converter

• Checks a schema.json file

  Validates field types, operations, index mappings and pattern IDs, and suggests fixes for errors.

  Try: “Validate my schema.json file at /path/to/schema.json.”

  Files · dynamodb_data_model_schema_validator

• Generates Python code from your schema

  Writes Python entity and repository classes with validation and the access patterns you defined, and optional usage examples. The code uses Pydantic and boto3.

  Try: “Generate Python code from my schema.json.”

  Write · generate_data_access_layer

• Generates a CDK app that creates your tables

  Writes a CDK app that would create the tables and indexes in your data model file. It generates the files and does not deploy them.

  Try: “Generate the resources to deploy my DynamoDB data model using CDK.”

  Write · generate_resources

Watch out for

• It writes files into your project folder

  It saves model, schema, analysis and generated code files. Run it in a clean folder and review the files before you use them. github.com

• Validation starts a local database

  The validation tool launches DynamoDB Local through a container tool or Java. Allow this only on a machine where that is fine. github.com

• Analyze a non-production database

  The README advises running the database analyzer against a non-production instance. github.com

Security advisories