Query Commands

kdx document grep <pattern> <file.kddb> [flags]

kdx document grep "risk factor" doc.kddb

{"uuid":"abc-123","content":"Risk factors include market volatility","page":5}
{"uuid":"def-456","content":"Additional risk factors discussed below","page":5}

kdx document grep -i "revenue" doc.kddb

# Find section headers with numbers
kdx document grep -E "Section\s+\d+" doc.kddb

# Find amounts with dollar signs
kdx document grep -E "\$[\d,]+\.\d{2}" doc.kddb

# Find dates in various formats
kdx document grep -E "\d{1,2}/\d{1,2}/\d{2,4}" doc.kddb

# 2 lines before and after each match
kdx document grep -C 2 "total revenue" doc.kddb

# 3 lines before, 1 line after
kdx document grep -B 3 -A 1 "conclusion" doc.kddb

kdx document grep -c "error" doc.kddb

12

kdx document grep --max 10 "warning" doc.kddb

kdx document grep --page 5 "total" doc.kddb

kdx document grep --pretty "revenue" doc.kddb

{
  "uuid": "abc-123",
  "content": "Total revenue for Q4 was $1.2M",
  "page": 3
}

kdx document lines <file.kddb> [flags]

# Get lines 10-19 (10 lines total)
kdx document lines --range 10:20 doc.kddb

# All lines from page 5
kdx document lines --page 5 doc.kddb

# Single UUID
kdx document lines --uuid abc-123 doc.kddb

# Multiple UUIDs
kdx document lines --uuid abc-123,def-456,ghi-789 doc.kddb

kdx document lines doc.kddb

{"uuid":"abc-123","content":"Line content here","page":3}
{"uuid":"def-456","content":"Another line of text","page":3}
{"uuid":"ghi-789","content":"Third line content","page":4}

kdx document grep -i "risk" doc.kddb | jq -r '.uuid'

kdx document grep "revenue" doc.kddb | jq -s 'group_by(.page) | map({page: .[0].page, count: length})'

[
  {"page": 3, "count": 5},
  {"page": 7, "count": 2},
  {"page": 12, "count": 8}
]

# Read UUIDs from a file and fetch their content
UUIDS=$(cat uuids.txt | tr '\n' ',')
kdx document lines --uuid "$UUIDS" doc.kddb | jq -r '.content'

for p in {10..15}; do
  kdx document lines --page $p doc.kddb
done | jq -s '.'

# Find all amounts and extract the values
kdx document grep -E '\$[\d,]+' doc.kddb | jq -r '.content'

# Get first 5 lines from each page
for p in $(seq 1 10); do
  kdx document lines --page $p doc.kddb | head -5
done

# Extract specific content by UUID for LLM context
kdx document lines --uuid abc-123,def-456 doc.kddb | jq -r '.content' | paste -sd '\n' -

# Find lines mentioning "revenue", then get their page content
PAGES=$(kdx document grep "revenue" doc.kddb | jq -r '.page' | sort -u)
for p in $PAGES; do
  echo "=== Page $p ==="
  kdx document lines --page $p doc.kddb | jq -r '.content'
done

# Find all mentions of a term
kdx document grep "depreciation" financials.kddb

# Case-insensitive search for variations
kdx document grep -i "ebitda" report.kddb

# Find patterns like phone numbers
kdx document grep -E "\(\d{3}\)\s*\d{3}-\d{4}" contract.kddb

# Get all lines from executive summary (page 2)
CONTEXT=$(kdx document lines --page 2 doc.kddb | jq -r '.content' | paste -sd '\n' -)

# Search for relevant lines and build context
CONTEXT=$(kdx document grep -i "key finding" doc.kddb | jq -r '.content' | paste -sd '\n' -)

#!/bin/bash
# Extract all lines mentioning amounts
kdx document grep -E '\$[\d,]+' "$1" | while read -r line; do
  UUID=$(echo "$line" | jq -r '.uuid')
  CONTENT=$(echo "$line" | jq -r '.content')
  PAGE=$(echo "$line" | jq -r '.page')

  # Process each match...
  echo "Found amount on page $PAGE: $CONTENT"
done

# Check if required sections exist
if kdx document grep -c "Terms and Conditions" contract.kddb | grep -q "^0$"; then
  echo "ERROR: Missing Terms and Conditions section"
  exit 1
fi

# Count pages with content
PAGES_WITH_CONTENT=$(kdx document grep "." doc.kddb | jq -r '.page' | sort -u | wc -l)
echo "Document has content on $PAGES_WITH_CONTENT pages"