Cloudflare D1Install

Summary

Search messages by content across memory sessions

Inputs

• databaseId (required) — The unique identifier of your Cloudflare D1 database
• searchQuery (required) — Text to search for in message content
• searchSessionId — Optional: Limit search to specific session (leave empty to search all sessions)
• searchMessageTypes — Types of messages to search within (human, ai)
• searchLimit — Maximum number of matching messages to return
• enableFuzzySearch — Whether to enable flexible matching for plurals, suffixes, and word variations

Output shape

an array of matching message objects

Returns up to searchLimit messages; may be empty; fuzzy search can broaden results; no pagination support

Examples

Example 1: Find recent human messages about a hotel classification

databaseId=12345, searchQuery=chef classification hotel, searchMessageTypes=["human","ai"], searchLimit=20, enableFuzzySearch=false

Example 2: Search a specific session for AI messages containing "budget"

databaseId=12345, searchQuery=budget, searchSessionId=abc123, searchMessageTypes=["ai"], searchLimit=10, enableFuzzySearch=true

Example 3: List all sessions and their message counts

operation=getSessionList (downstream use after search)