The Complete Production SOP: How to Deploy and Run Elasticsearch DSL & Index Lifecycle Management (ILM) in Autonomous AI Agents

---
name: "elasticsearch-dsl-index-lifecycle"
description: "Design production Elasticsearch mappings, complex Boolean DSL queries, and automated ILM rollover."
metadata:
  author: "Elastic"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "write elasticsearch bool query"
  - "configure elasticsearch ilm policy"
  - "create custom analyzer elasticsearch"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

{
  "policy": {
    "phases": {
      "hot": {
        "actions": {
          "rollover": {
            "max_primary_shard_size": "50gb",
            "max_age": "7d"
          }
        }
      },
      "warm": {
        "min_age": "2d",
        "actions": {
          "forcemerge": { "max_num_segments": 1 },
          "allocate": { "number_of_replicas": 1 }
        }
      },
      "cold": {
        "min_age": "30d",
        "actions": {
          "readonly": {}
        }
      },
      "delete": {
        "min_age": "90d",
        "actions": {
          "delete": {}
        }
      }
    }
  }
}

import assert from "node:assert";
import fs from "node:fs";

const raw = fs.readFileSync("queries/search.json", "utf8");
const payload = JSON.parse(raw);

// Ensure non-scoring terms are not placed in must
assert.ok(payload.query.bool.filter, "Filter clause must be defined for exact matches");
if (payload.query.bool.must) {
  payload.query.bool.must.forEach((clause) => {
    assert.ok(!clause.term, "Single term matches should reside inside bool.filter to leverage bitset caching");
  });
}
console.log("Quality gate passed: Boolean DSL conforms to caching SOP.");