DynamoDB MCP Server

A Model Context Protocol server for managing Amazon DynamoDB resources. This server provides tools for table management, capacity management, and data operations.

Author

Vignesh Kumar(rrvigneshkumar2002@gmail.com)

📋 Quick Reference: See QUICK_REFERENCE.md for common commands and configurations.

Quick Start

# Install dependencies
npm install

# Build the project
npm run build

# Set AWS credentials
export AWS_ACCESS_KEY_ID="your_access_key"
export AWS_SECRET_ACCESS_KEY="your_secret_key"
export AWS_REGION="us-east-1"

# Start the server (binds to 0.0.0.0:3000 by default)
npm start

# Test the health endpoint
curl http://localhost:3000/health

Custom Configuration

# Run with custom host and port
MCP_HOST=127.0.0.1 MCP_PORT=8080 npm start

Remote Mode

This MCP server runs exclusively in remote mode using Server-Sent Events (SSE) over HTTP for client connections.

Features:

• HTTP-based transport for remote connections
• Allows multiple clients to connect simultaneously
• Ideal for team environments and cloud deployments
• Health check endpoint for monitoring

Environment Variables:

• MCP_HOST: Host to bind to (default: 0.0.0.0)
• MCP_PORT: Port to listen on (default: 3000)

📖 For detailed configuration, security best practices, and deployment guides, see REMOTE_MODE.md

🚀 For Smithery usage and deployment, see SMITHERY_USAGE.md

Features

Table Management

• Create new DynamoDB tables with customizable configurations
• List existing tables
• Get detailed table information
• Configure table settings

Index Management

• Create and manage Global Secondary Indexes (GSI)
• Update GSI capacity
• Create Local Secondary Indexes (LSI)

Capacity Management

• Update provisioned read/write capacity units
• Manage table throughput settings

Data Operations

• Insert or replace items in tables
• Retrieve items by primary key
• Update specific item attributes
• Query tables with conditions
• Scan tables with filters

Note: Delete operations are not supported to prevent accidental data loss.

Setup

1. Install dependencies:

npm install

2. Configure AWS credentials as environment variables:

export AWS_ACCESS_KEY_ID="your_access_key"
export AWS_SECRET_ACCESS_KEY="your_secret_key"
export AWS_REGION="your_region"

3. Build the server:

npm run build

4. Start the server:

Local Mode (stdio):

npm start

Remote Mode (SSE over HTTP):

npm run start:remote

Or with custom host and port:

MCP_TRANSPORT_MODE=sse MCP_HOST=0.0.0.0 MCP_PORT=8080 npm start

Tools

create_table

Creates a new DynamoDB table with specified configuration.

Parameters:

• tableName: Name of the table to create
• partitionKey: Name of the partition key
• partitionKeyType: Type of partition key (S=String, N=Number, B=Binary)
• sortKey: (Optional) Name of the sort key
• sortKeyType: (Optional) Type of sort key
• readCapacity: Provisioned read capacity units
• writeCapacity: Provisioned write capacity units

Example:

{
  "tableName": "Users",
  "partitionKey": "userId",
  "partitionKeyType": "S",
  "readCapacity": 5,
  "writeCapacity": 5
}

list_tables

Lists all DynamoDB tables in the account.

Parameters:

• limit: (Optional) Maximum number of tables to return
• exclusiveStartTableName: (Optional) Name of the table to start from for pagination

Example:

{
  "limit": 10
}

describe_table

Gets detailed information about a DynamoDB table.

Parameters:

• tableName: Name of the table to describe

Example:

{
  "tableName": "Users"
}

create_gsi

Creates a global secondary index on a table.

Parameters:

• tableName: Name of the table
• indexName: Name of the new index
• partitionKey: Partition key for the index
• partitionKeyType: Type of partition key
• sortKey: (Optional) Sort key for the index
• sortKeyType: (Optional) Type of sort key
• projectionType: Type of projection (ALL, KEYS_ONLY, INCLUDE)
• nonKeyAttributes: (Optional) Non-key attributes to project
• readCapacity: Provisioned read capacity units
• writeCapacity: Provisioned write capacity units

Example:

{
  "tableName": "Users",
  "indexName": "EmailIndex",
  "partitionKey": "email",
  "partitionKeyType": "S",
  "projectionType": "ALL",
  "readCapacity": 5,
  "writeCapacity": 5
}

update_gsi

Updates the provisioned capacity of a global secondary index.

Parameters:

• tableName: Name of the table
• indexName: Name of the index to update
• readCapacity: New read capacity units
• writeCapacity: New write capacity units

Example:

{
  "tableName": "Users",
  "indexName": "EmailIndex",
  "readCapacity": 10,
  "writeCapacity": 10
}

create_lsi

Creates a local secondary index on a table (must be done during table creation).

Parameters:

• tableName: Name of the table
• indexName: Name of the new index
• partitionKey: Partition key for the table
• partitionKeyType: Type of partition key
• sortKey: Sort key for the index
• sortKeyType: Type of sort key
• projectionType: Type of projection (ALL, KEYS_ONLY, INCLUDE)
• nonKeyAttributes: (Optional) Non-key attributes to project
• readCapacity: (Optional) Provisioned read capacity units
• writeCapacity: (Optional) Provisioned write capacity units

Example:

{
  "tableName": "Users",
  "indexName": "CreatedAtIndex",
  "partitionKey": "userId",
  "partitionKeyType": "S",
  "sortKey": "createdAt",
  "sortKeyType": "N",
  "projectionType": "ALL"
}

update_capacity

Updates the provisioned capacity of a table.

Parameters:

• tableName: Name of the table
• readCapacity: New read capacity units
• writeCapacity: New write capacity units

Example:

{
  "tableName": "Users",
  "readCapacity": 10,
  "writeCapacity": 10
}

put_item

Inserts or replaces an item in a table.

Parameters:

• tableName: Name of the table
• item: Item to put into the table (as JSON object)

Example:

{
  "tableName": "Users",
  "item": {
    "userId": "123",
    "name": "John Doe",
    "email": "john@example.com"
  }
}

get_item

Retrieves an item from a table by its primary key.

Parameters:

• tableName: Name of the table
• key: Primary key of the item to retrieve

Example:

{
  "tableName": "Users",
  "key": {
    "userId": "123"
  }
}

update_item

Updates specific attributes of an item in a table.

Parameters:

• tableName: Name of the table
• key: Primary key of the item to update
• updateExpression: Update expression
• expressionAttributeNames: Attribute name mappings
• expressionAttributeValues: Values for the update expression
• conditionExpression: (Optional) Condition for update
• returnValues: (Optional) What values to return

Example:

{
  "tableName": "Users",
  "key": {
    "userId": "123"
  },
  "updateExpression": "SET #n = :name",
  "expressionAttributeNames": {
    "#n": "name"
  },
  "expressionAttributeValues": {
    ":name": "Jane Doe"
  }
}

query_table

Queries a table using key conditions and optional filters.

Parameters:

• tableName: Name of the table
• keyConditionExpression: Key condition expression
• expressionAttributeValues: Values for the key condition expression
• expressionAttributeNames: (Optional) Attribute name mappings
• filterExpression: (Optional) Filter expression for results
• limit: (Optional) Maximum number of items to return

Example:

{
  "tableName": "Users",
  "keyConditionExpression": "userId = :id",
  "expressionAttributeValues": {
    ":id": "123"
  }
}

scan_table

Scans an entire table with optional filters.

Parameters:

• tableName: Name of the table
• filterExpression: (Optional) Filter expression
• expressionAttributeValues: (Optional) Values for the filter expression
• expressionAttributeNames: (Optional) Attribute name mappings
• limit: (Optional) Maximum number of items to return

Example:

{
  "tableName": "Users",
  "filterExpression": "age > :minAge",
  "expressionAttributeValues": {
    ":minAge": 21
  }
}

Sample Questions

Here are some example questions you can ask Claude when using this DynamoDB MCP server:

Table Management

• "Create a new DynamoDB table called 'Products' with a partition key 'productId' (string) and sort key 'timestamp' (number)"
• "List all DynamoDB tables in my account"
• "What's the current configuration of the Users table?"
• "Add a global secondary index on the email field of the Users table"

Capacity Management

• "Update the Users table capacity to 20 read units and 15 write units"
• "Scale up the EmailIndex GSI capacity on the Users table"
• "What's the current provisioned capacity for the Orders table?"

Data Operations

• "Insert a new user with ID '123', name 'John Doe', and email 'john@example.com'"
• "Get the user with ID '123'"
• "Update the email address for user '123' to 'john.doe@example.com'"
• "Find all orders placed by user '123'"
• "List all users who are over 21 years old"
• "Query the EmailIndex to find the user with email 'john@example.com'"

Configuration

Setting up AWS Credentials

1. Obtain AWS access key ID, secret access key, and region from the AWS Management Console.
2. If using temporary credentials (e.g., IAM role), also obtain a session token.
3. Ensure these credentials have appropriate permissions for DynamoDB operations.

Usage with Claude Desktop

First, start the server on your host:

npm start

Then add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "dynamodb": {
      "url": "http://your-server-host:3000/sse"
    }
  }
}

For local testing, use http://localhost:3000/sse.

Security Note: Ensure proper network security measures are in place:

• Use HTTPS/TLS in production
• Implement authentication and authorization
• Restrict network access using firewalls
• Consider using a reverse proxy (nginx, Apache) with SSL termination

Building

Docker

Build the image:

docker build -t mcp/dynamodb-mcp-server -f Dockerfile .

Run the server:

docker run -d --rm \
  -e AWS_ACCESS_KEY_ID="your_access_key" \
  -e AWS_SECRET_ACCESS_KEY="your_secret_key" \
  -e AWS_REGION="your_region" \
  -p 3000:3000 \
  --name dynamodb-mcp \
  mcp/dynamodb-mcp-server

With custom port:

docker run -d --rm \
  -e MCP_PORT=8080 \
  -e AWS_ACCESS_KEY_ID="your_access_key" \
  -e AWS_SECRET_ACCESS_KEY="your_secret_key" \
  -e AWS_REGION="your_region" \
  -p 8080:8080 \
  --name dynamodb-mcp \
  mcp/dynamodb-mcp-server

Development

To run in development mode with auto-reloading:

npm run watch

Testing the Server

Linux/Mac:

chmod +x test-remote.sh
./test-remote.sh

Windows (PowerShell):

.\test-remote.ps1

Or manually test the endpoints:

# Start server
npm start

# In another terminal, test the health endpoint
curl http://localhost:3000/health

# Test SSE connection
curl -N -H "Accept: text/event-stream" http://localhost:3000/sse

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.