DynamoDB Read-Only Server enables LLMs to query AWS DynamoDB NoSQL databases through natural language requests. It bridges the gap between conversational AI and DynamoDB's API, allowing you to inspect schemas and retrieve data without writing raw query syntax. Key capabilities include: - **Table discovery and inspection**: List all tables in your AWS account and view detailed schema information including partition keys, sort keys, and attribute definitions. - **Flexible data retrieval**: Scan entire tables, query with specific partition key conditions, paginate through large result sets, retrieve individual items by key, and count items matching criteria. - **Schema-aware resources**: Access table metadata and schema information as MCP resources to help LLMs construct optimal queries. - **Read-only safety**: All operations are constrained to non-destructive actions — query, scan, and describe operations only, with no write, update, or delete capabilities. Works with AWS DynamoDB tables across all AWS regions using standard AWS credentials.

[](https://mseep.ai/app/jjikky-dynamo-readonly-mcp)

DynamoDB Read-Only MCP

[](https://badge.fury.io/js/dynamo-readonly-mcp) [](https://smithery.ai/server/@jjikky/dynamo-readonly-mcp)

A server that utilizes the Model Context Protocol (MCP) to query AWS DynamoDB databases. This server allows LLMs like Claude to query DynamoDB data through natural language requests.

Features

This MCP server provides the following features:

Installation and Execution

You can run it without installation using the Run with NPX method below.

Installing via Smithery

To install DynamoDB Read-Only Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @jjikky/dynamo-readonly-mcp --client claude

Installation

1. Clone the repository:

   git clone https://github.com/jjikky/dynamo-readonly-mcp.git
   cd dynamo-readonly-mcp
   

2. Install the required packages:

   npm install
   

3. Create a .env file and set up your AWS credentials:

   AWS_ACCESS_KEY_ID=your_access_key
   AWS_SECRET_ACCESS_KEY=your_secret_key
   AWS_REGION=your_region
   

Build and Run

npm run build
npm start

Connect to Claude Desktop

To use this MCP server with Claude Desktop, you need to modify the Claude Desktop configuration file.

1. Open the Claude Desktop configuration file: - macOS: ~/Library/Application Support/Claude/claude_desktop_config.json - Windows: %APPDATA%\Claude\claude_desktop_config.json 2. Add the server configuration as follows:

   {
     "mcpServers": {
       "dynamodb-readonly": {
         "command": "node",
         "args": ["/absolute-path/dynamo-readonly-mcp/dist/index.js"],
         "env": {
           "AWS_ACCESS_KEY_ID": "your_access_key",
           "AWS_SECRET_ACCESS_KEY": "your_secret_key",
           "AWS_REGION": "your_region"
         }
       }
     }
   }
   

3. Restart Claude Desktop.

Run with NPX

You can also run this server using npx without a global installation:

{
  "mcpServers": {
    "dynamodb-readonly": {
      "command": "npx",
      "args": ["-y", "dynamo-readonly-mcp"],
      "env": {
        "AWS_ACCESS_KEY_ID": "your_access_key",
        "AWS_SECRET_ACCESS_KEY": "your_secret_key",
        "AWS_REGION": "your_region"
      }
    }
  }
}

Usage Examples

You can ask Claude questions like:

1. "Can you tell me what tables are in DynamoDB?" 2. "Explain the structure of the Users table" 3. "Find the number of users in the 'Users' table where groupId is '0lxp4paxk7'"

---

Architecture

This MCP server consists of the following layered structure:

1. Client Interface (Claude Desktop) - Interaction between user and LLM 2. MCP Protocol Layer - Provides standardized message exchange method 3. DynamoDB Server - Implements functions that interact with DynamoDB 4. AWS SDK - Communicates with AWS DynamoDB service

Key Operation Mechanisms

1. Initialization and Connection

When the server starts, the following process occurs:

async function main() {
  const transport = new StdioServerTransport();
  await server.connect(transport);
  console.error('DynamoDB read-only MCP server is running...');
}

2. Tool Request Processing

When a user asks Claude something like "Show me the list of DynamoDB tables":

1. Claude analyzes this request and calls the `list-tabl