DynamoDB AI Query Generator — plain English to expressions.

Generated DynamoDB operation

// Generated DynamoDB Query operation
const thirtyDaysAgo = new Date();
thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);

const params = {
  TableName: "orders",
  KeyConditionExpression:
    "customerId = :cid AND createdAt >= :date",
  ExpressionAttributeValues: {
    ":cid": { S: "user-123" },
    ":date": { S: thirtyDaysAgo.toISOString() },
  },
};

Query operation using partition key (customerId) and sort key range (createdAt). Automatically generates ExpressionAttributeValues with the correct DynamoDB type descriptors.

Generated DynamoDB operation

// Generated DynamoDB Scan with FilterExpression
const params = {
  TableName: "products",
  FilterExpression:
    "#cat = :category AND #price < :maxPrice",
  ExpressionAttributeNames: {
    "#cat": "category",
    "#price": "price",
  },
  ExpressionAttributeValues: {
    ":category": { S: "Electronics" },
    ":maxPrice": { N: "100" },
  },
};

Uses ExpressionAttributeNames (#cat, #price) to avoid reserved word conflicts — 'price' is a reserved word in DynamoDB. Insight O' Mate handles this automatically.

Generated DynamoDB operation

// Generated DynamoDB Scan with Count
const params = {
  TableName: "subscriptions",
  FilterExpression: "#status = :active",
  ExpressionAttributeNames: {
    "#status": "status",
  },
  ExpressionAttributeValues: {
    ":active": { S: "active" },
  },
  Select: "COUNT",
};

Uses Select: 'COUNT' to return only the count without fetching item data, and handles 'status' as a reserved word automatically.

Generated DynamoDB operation

// Generated DynamoDB Query — most recent item
const params = {
  TableName: "orders",
  KeyConditionExpression: "customerId = :cid",
  ExpressionAttributeValues: {
    ":cid": { S: "user-456" },
  },
  ScanIndexForward: false,
  Limit: 1,
};

Queries by partition key, sets ScanIndexForward to false for descending sort-key order, and limits to 1 result to get the most recent order.

Generated DynamoDB operation

// Generated DynamoDB Scan with begins_with
const params = {
  TableName: "users",
  FilterExpression: "begins_with(#name, :prefix)",
  ExpressionAttributeNames: {
    "#name": "name",
  },
  ExpressionAttributeValues: {
    ":prefix": { S: "Alex" },
  },
};

Uses the begins_with function in FilterExpression. 'name' is handled via ExpressionAttributeNames since it's a reserved word.

Generated DynamoDB operation

// Generated DynamoDB Scan with BETWEEN
const params = {
  TableName: "payments",
  FilterExpression: "#amount BETWEEN :min AND :max",
  ExpressionAttributeNames: {
    "#amount": "amount",
  },
  ExpressionAttributeValues: {
    ":min": { N: "100" },
    ":max": { N: "500" },
  },
};

Uses the BETWEEN operator in FilterExpression with numeric type descriptors ({ N: '100' }) for correct DynamoDB comparison.

Generated DynamoDB operation

// Generated DynamoDB Scan
const oneWeekAgo = new Date();
oneWeekAgo.setDate(oneWeekAgo.getDate() - 7);

const params = {
  TableName: "transactions",
  FilterExpression: "#status = :failed AND createdAt >= :weekAgo",
  ExpressionAttributeNames: {
    "#status": "status",
  },
  ExpressionAttributeValues: {
    ":failed": { S: "failed" },
    ":weekAgo": { S: oneWeekAgo.toISOString() },
  },
};

Scans with a compound FilterExpression combining status equality and date range filters.