Skip to content

kr7shnasomani/kairos / .agents/skills/elasticsearch-esql

elasticsearch-esql

Flagged

Execute ES|QL (Elasticsearch Query Language) queries, use when the user wants to query Elasticsearch data, analyze logs, aggregate metrics, explore data, or create charts and dashboards from ES|QL results.

references/esql-version-history.md

View on GitHub
# ES|QL Version History and Feature Availability

This document tracks ES|QL language features, commands, and functions across Elasticsearch versions. Use this to
determine compatibility when writing queries for specific Elasticsearch deployments.

> **Paired releases:** Certain minor versions shipped simultaneously with nearly identical feature sets. When a feature
> appears in one, assume it is in both unless explicitly noted otherwise. Paired versions: **8.18 / 9.0**, **8.19 /
> 9.1**.
>
> **Serverless:** Elastic Cloud Serverless reports a forward-moving `version.number` from `GET /` (aligned with the next
> minor from main), so clients that only semver-compare often behave as if the cluster is “latest.” **Do not** rely on
> that for feature gating: check `build_flavor` — if it is `"serverless"`, all GA and preview features are available and
> you should skip version-based gates. For snapshot builds (e.g., `9.4.0-SNAPSHOT`), strip the `-SNAPSHOT` suffix and
> use the major.minor for version checks.

## Table of Contents

- [Version Timeline Overview](#version-timeline-overview)
- [Feature Availability by Version](#feature-availability-by-version)
- [Major Limitations](#major-limitations)
- [Cross-Cluster Query Support](#cross-cluster-query-support)
- [Output Formats](#output-formats)
- [API Endpoints](#api-endpoints)
- [Performance Tips by Version](#performance-tips-by-version)
- [Version Detection](#version-detection)
- [References](#references)

## Version Timeline Overview

| Version | Release  | Status       | Key Additions                                                                                           |
| ------- | -------- | ------------ | ------------------------------------------------------------------------------------------------------- |
| 8.11    | Nov 2023 | Tech Preview | Initial ES\|QL release                                                                                  |
| 8.12    | Jan 2024 | Tech Preview | Spatial types, PROFILE                                                                                  |
| 8.13    | Mar 2024 | Tech Preview | Async queries, cross-cluster ENRICH                                                                     |
| 8.14    | May 2024 | **GA**       | Spatial functions, regex optimization                                                                   |
| 8.15    | Aug 2024 | GA           | Type casting (`::`), Arrow output                                                                       |
| 8.16    | Oct 2024 | GA           | Per-aggregation WHERE, new math/string functions                                                        |
| 8.17    | Dec 2024 | GA           | MATCH, QSTR full-text functions                                                                         |
| 8.18    | Feb 2025 | GA           | LOOKUP JOIN (preview), scoring, KQL                                                                     |
| 8.19    | Apr 2025 | GA           | MATCH_PHRASE, FORK, CHANGE_POINT (preview)                                                              |
| 9.0     | Feb 2025 | GA           | Released with 8.18 features                                                                             |
| 9.1     | Jun 2025 | GA           | Full-text functions GA, FORK (preview)                                                                  |
| 9.2     | Oct 2025 | GA           | Multi-field joins, TS, INLINE STATS (preview), CHANGE_POINT GA, FUSE (preview), RERANK (preview)        |
| 9.3     | Jan 2026 | GA           | INLINE STATS GA, SET directive (preview), Lucene-pushable JOIN predicates                               |
| 9.4     | May 2026 | GA           | TS GA, time series functions GA, WITHOUT/METRICS_INFO/TS_INFO GA, PROMQL (preview), MV_EXPAND/VALUES GA |

## Feature Availability by Version

### Commands

| Command        | Introduced | GA       | Notes                                           |
| -------------- | ---------- | -------- | ----------------------------------------------- |
| `FROM`         | 8.11       | 8.14     | Source command                                  |
| `WHERE`        | 8.11       | 8.14     | Filtering                                       |
| `EVAL`         | 8.11       | 8.14     | Computed columns                                |
| `STATS ... BY` | 8.11       | 8.14     | Aggregations with grouping                      |
| `SORT`         | 8.11       | 8.14     | Ordering results                                |
| `LIMIT`        | 8.11       | 8.14     | Result set size                                 |
| `KEEP`         | 8.11       | 8.14     | Column selection                                |
| `DROP`         | 8.11       | 8.14     | Column removal                                  |
| `RENAME`       | 8.11       | 8.14     | Column renaming                                 |
| `DISSECT`      | 8.11       | 8.14     | Pattern extraction                              |
| `GROK`         | 8.11       | 8.14     | Log parsing                                     |
| `ENRICH`       | 8.11       | 8.14     | Data enrichment                                 |
| `MV_EXPAND`    | 8.11       | 9.4      | Multi-value expansion (GA)                      |
| `SHOW`         | 8.11       | 8.14     | Metadata display                                |
| `ROW`          | 8.11       | 8.14     | Literal row creation                            |
| `LOOKUP JOIN`  | 8.18/9.0   | 8.19/9.1 | SQL-style LEFT JOIN with lookup indices         |
| `INLINE STATS` | 9.2        | 9.3      | Inline aggregations (like window functions)     |
| `FORK`         | 8.19/9.1   | Preview  | Multiple execution branches                     |
| `FUSE`         | 9.2        | Preview  | Combine results from FORK branches              |
| `TS`           | 9.2        | 9.4      | Time series source command                      |
| `PROMQL`       | 9.4        | Preview  | Source command using PromQL syntax on TSDS      |
| `METRICS_INFO` | 9.4        | 9.4      | TSDS metric catalogue (after `TS`)              |
| `TS_INFO`      | 9.4        | 9.4      | Per-(metric, time series) metadata (after `TS`) |
| `RERANK`       | 9.2        | Preview  | Re-score results with inference                 |
| `COMPLETION`   | 9.2        | 9.2      | LLM text generation                             |
| `SAMPLE`       | 8.19/9.1   | Preview  | Random sampling                                 |
| `URI_PARTS`    | Srvless    | Srvless  | Parse URI into structured columns               |
| `USER_AGENT`   | Srvless    | Srvless  | Parse user agent into structured columns        |
| `REG_DOMAIN`   | Srvless    | Srvless  | `REGISTERED_DOMAIN`: extract from hostname      |

### Full-Text Search Functions

| Function                      | Introduced | GA       | Notes                        |
| ----------------------------- | ---------- | -------- | ---------------------------- |
| `MATCH(field, query)`         | 8.17       | 8.19/9.1 | Basic full-text matching     |
| `QSTR(query_string)`          | 8.17       | 8.19/9.1 | Query string syntax (Lucene) |
| `KQL(kql_string)`             | 8.18/9.0   | 8.19/9.1 | Kibana Query Language        |
| `MATCH_PHRASE(field, phrase)` | 8.19/9.1   | 8.19/9.1 | Exact phrase matching        |
| Match operator (`:`)          | 8.17       | 8.19/9.1 | Shorthand for MATCH          |

**Scoring support:**

- `METADATA _score` available from 8.18/9.0
- Must use `SORT _score DESC` to rank by relevance

### Spatial Functions

| Function               | Introduced | Notes                        |
| ---------------------- | ---------- | ---------------------------- |
| `GEO_POINT` type       | 8.12       | Basic spatial type support   |
| `CARTESIAN_POINT` type | 8.12       | Cartesian coordinate support |
| `ST_INTERSECTS`        | 8.14       | Geometry intersection test   |
| `ST_CONTAINS`          | 8.14       | Containment test             |
| `ST_DISJOINT`          | 8.14       | Disjoint test                |
| `ST_WITHIN`            | 8.14       | Within test                  |
| `ST_X`, `ST_Y`         | 8.14       | Coordinate extraction        |
| `ST_DISTANCE`          | 8.15       | Distance calculation         |
| `ST_EXTENT_AGG`        | 8.18/9.0   | Bounding box aggregation     |
| `ST_ENVELOPE`          | 8.18/9.0   | Bounding box for geometry    |

### Date/Time Functions

| Function          | Introduced     | Notes                                |
| ----------------- | -------------- | ------------------------------------ |
| `NOW()`           | 8.11           | Current timestamp                    |
| `DATE_TRUNC`      | 8.11           | Truncate to interval                 |
| `DATE_EXTRACT`    | 8.11           | Extract date parts                   |
| `DATE_FORMAT`     | 8.11           | Format dates (no TZ until 9.3)       |
| `DATE_PARSE`      | 8.11           | Parse date strings (no TZ until 9.3) |
| `DATE_DIFF`       | 8.13           | Difference between dates             |
| `date_nanos` type | 8.17 (preview) | Nanosecond precision timestamps      |
| `TRANGE`          | 9.3 (preview)  | Time range filter on `@timestamp`    |

### String Functions

| Function                    | Introduced | Notes                       |
| --------------------------- | ---------- | --------------------------- |
| `LEFT`, `RIGHT`             | 8.11       | Substring extraction        |
| `SUBSTRING`                 | 8.11       | Position-based extraction   |
| `CONCAT`                    | 8.11       | String concatenation        |
| `TRIM`, `LTRIM`, `RTRIM`    | 8.11       | Whitespace removal          |
| `TO_UPPER`, `TO_LOWER`      | 8.13       | Case conversion             |
| `LOCATE`                    | 8.14       | Find substring position     |
| `SPACE`                     | 8.16       | Generate spaces             |
| `REVERSE`                   | 8.16       | Reverse string              |
| `BIT_LENGTH`, `BYTE_LENGTH` | 8.17       | String length in bits/bytes |
| `STARTS_WITH`, `ENDS_WITH`  | 8.11       | Prefix/suffix matching      |
| `CONTAINS`                  | 9.2        | Substring containment check |

### Multi-Value Functions

| Function                  | Introduced | Notes                  |
| ------------------------- | ---------- | ---------------------- |
| `MV_COUNT`                | 8.11       | Count values           |
| `MV_CONCAT`               | 8.11       | Join values            |
| `MV_FIRST`, `MV_LAST`     | 8.13       | First/last value       |
| `MV_MIN`, `MV_MAX`        | 8.11       | Min/max value          |
| `MV_SUM`, `MV_AVG`        | 8.11       | Sum/average            |
| `MV_MEDIAN`               | 8.11       | Median value           |
| `MV_SORT`                 | 8.14       | Sort multi-values      |
| `MV_SLICE`                | 8.14       | Slice multi-values     |
| `MV_PERCENTILE`           | 8.16       | Percentile calculation |
| `MV_PSERIES_WEIGHTED_SUM` | 8.16       | Weighted sum           |

### Aggregation Functions

| Function                              | Introduced | Notes                           |
| ------------------------------------- | ---------- | ------------------------------- |
| `COUNT`, `COUNT_DISTINCT`             | 8.11       | Counting                        |
| `SUM`, `AVG`                          | 8.11       | Basic aggregations              |
| `MIN`, `MAX`                          | 8.11       | Extended to strings/IPs in 8.16 |
| `MEDIAN`, `MEDIAN_ABSOLUTE_DEVIATION` | 8.11       | Statistical                     |
| `PERCENTILE`                          | 8.11       | Percentile calculation          |
| `TOP`                                 | 8.15       | Top N values                    |
| `VALUES`                              | 8.14       | Unique values (GA in 9.4)       |
| `ST_EXTENT_AGG`                       | 8.18/9.0   | Spatial bounding box            |
| `WEIGHTED_AVG`                        | 8.16       | Weighted average                |
| `STD_DEV`                             | 8.18/9.0   | Standard deviation              |
| `VARIANCE`                            | 8.18/9.0   | Variance                        |
| `FIRST` / `EARLIEST`                  | Serverless | Earliest value by sort field    |
| `LAST` / `LATEST`                     | Serverless | Latest value by sort field      |

### Grouping Functions

| Function     | Introduced | Notes                                                            |
| ------------ | ---------- | ---------------------------------------------------------------- |
| `BUCKET`     | 8.11       | Numeric/date bucketing in `BY` clause                            |
| `CATEGORIZE` | 8.18/9.0   | Auto-categorization of text in `BY` clause                       |
| `TBUCKET`    | 9.2        | Time bucketing from `@timestamp`; preferred in TS (GA in 9.4)    |
| `WITHOUT`    | 9.4        | Group time series by every dimension except the listed ones (GA) |

### Per-Aggregation WHERE

Available since 8.16. Allows filtering individual aggregations without affecting others:

```esql
| STATS total = COUNT(*), errors = COUNT(*) WHERE level == "error" BY service.name
```

### IP Functions

| Function     | Introduced | Notes                          |
| ------------ | ---------- | ------------------------------ |
| `CIDR_MATCH` | 8.11       | Check IP against CIDR ranges   |
| `IP_PREFIX`  | 8.14       | Extract network prefix from IP |
| `TO_IP`      | 8.11       | Convert string to IP type      |

### Time Series Aggregation Functions

Available under `TS ... | STATS`. See [time-series-queries.md](time-series-queries.md) for full reference. All time
series aggregation functions in this table — both the 9.2-introduced set and the 9.3-introduced set (`DERIV`,
`PERCENTILE_OVER_TIME`, `STDDEV_OVER_TIME`, `VARIANCE_OVER_TIME`) — are **GA since 9.4**.

| Function                   | Introduced    | Status   | Notes                                           |
| -------------------------- | ------------- | -------- | ----------------------------------------------- |
| `RATE`                     | 9.2 (preview) | GA (9.4) | Per-second rate of counter increase             |
| `IRATE`                    | 9.2 (preview) | GA (9.4) | Instant rate (last two data points)             |
| `INCREASE`                 | 9.2 (preview) | GA (9.4) | Absolute counter increase in window             |
| `DELTA`                    | 9.2 (preview) | GA (9.4) | Absolute change of a gauge                      |
| `IDELTA`                   | 9.2 (preview) | GA (9.4) | Change between last two data points             |
| `AVG_OVER_TIME`            | 9.2 (preview) | GA (9.4) | Average value over time                         |
| `SUM_OVER_TIME`            | 9.2 (preview) | GA (9.4) | Sum of values over time                         |
| `MIN_OVER_TIME`            | 9.2 (preview) | GA (9.4) | Minimum value over time                         |
| `MAX_OVER_TIME`            | 9.2 (preview) | GA (9.4) | Maximum value over time                         |
| `FIRST_OVER_TIME`          | 9.2 (preview) | GA (9.4) | Earliest value by `@timestamp`                  |
| `LAST_OVER_TIME`           | 9.2 (preview) | GA (9.4) | Latest value by `@timestamp` (implicit default) |
| `COUNT_OVER_TIME`          | 9.2 (preview) | GA (9.4) | Count of values over time                       |
| `COUNT_DISTINCT_OVER_TIME` | 9.2 (preview) | GA (9.4) | Count of distinct values over time              |
| `PRESENT_OVER_TIME`        | 9.2 (preview) | GA (9.4) | `true` if field has values in window            |
| `ABSENT_OVER_TIME`         | 9.2 (preview) | GA (9.4) | `true` if field has no values in window         |
| `DERIV`                    | 9.3 (preview) | GA (9.4) | Derivative via linear regression                |
| `PERCENTILE_OVER_TIME`     | 9.3 (preview) | GA (9.4) | Percentile of values over time                  |
| `STDDEV_OVER_TIME`         | 9.3 (preview) | GA (9.4) | Population standard deviation over time         |
| `VARIANCE_OVER_TIME`       | 9.3 (preview) | GA (9.4) | Population variance over time                   |

**Sliding window parameter (second argument):**

- 9.2-9.3 (preview) — accepted window values are limited to multiples of the `TBUCKET` interval in the `BY` clause; if
  no window is specified, the bucket interval is used implicitly.
- 9.4+ (GA) — all window values are accepted, with performance optimizations when the window is a multiple of the
  `TBUCKET` interval. Mixing windows that are smaller than the time bucket for one metric with windows larger than the
  time bucket for another metric in the same query is not allowed.

### Conditional Functions

| Function    | Introduced    | Notes                              |
| ----------- | ------------- | ---------------------------------- |
| `CLAMP`     | 9.3 (preview) | Clamp values to `[min, max]` range |
| `CLAMP_MIN` | 9.3 (preview) | Set lower bound for values         |
| `CLAMP_MAX` | 9.3 (preview) | Set upper bound for values         |

### Type Casting

| Syntax          | Introduced | Notes                  |
| --------------- | ---------- | ---------------------- |
| `TO_STRING(x)`  | 8.11       | Function-based casting |
| `TO_INTEGER(x)` | 8.11       | Function-based casting |
| `TO_DOUBLE(x)`  | 8.11       | Function-based casting |
| `x::string`     | 8.15       | Operator-based casting |
| `x::integer`    | 8.15       | Operator-based casting |

## Major Limitations

### Pagination (Not Supported)

ES|QL **does not support cursor-based pagination** like the Search API's `search_after` or `scroll`.

**Current behavior:**

- Default: 1,000 rows returned
- Maximum: 10,000 rows (configurable via `esql.query.result_truncation_max_size`)
- No cursor or continuation token
- GitHub tracking issue: [#100000](https://github.com/elastic/elasticsearch/issues/100000)

**Workarounds:**

- Use `WHERE` to filter to relevant subset
- Use `STATS` to aggregate at query time
- For exports, use Search API with `search_after` instead

### Time Zone Support (Limited before Serverless / 9.4)

ES|QL has **limited timezone support** on self-managed clusters prior to 9.4. All dates are processed in UTC internally
and there is no per-function timezone argument.

On **Serverless**, ES|QL supports query-wide timezone via the `SET time_zone` directive (GA on Serverless). This accepts
IANA timezone strings and UTC offsets, and applies to all date/time operations including `DATE_TRUNC`, `DATE_FORMAT`,
`NOW()`, bucketing, and display.

```esql
SET time_zone = "America/New_York";
FROM logs-*
| STATS errors = COUNT(*) BY hour = DATE_TRUNC(1 hour, @timestamp)
| SORT hour DESC
```

**Remaining limitations (all versions):**

- No per-function timezone argument — `DATE_TRUNC(1 hour, @timestamp, "America/New_York")` does **not** work
- `DATE_FORMAT` and `DATE_PARSE` do not accept timezone parameters directly; use `SET time_zone` instead
- GitHub tracking issue: [#107560](https://github.com/elastic/elasticsearch/issues/107560)

**Self-managed before 9.4:**

- `SET time_zone` only accepts UTC offsets (`"+05:00"`), not IANA timezone strings
- Workaround: use `EVAL` to add/subtract hours manually:

  ```esql
  | EVAL local_time = timestamp + 1 hour
  ```

### Nested Fields (Not Supported)

ES|QL **cannot query nested field types**. Unlike other unsupported types (which return `null`), nested fields are **not
returned at all** — they are silently omitted from results.

- Cannot use nested paths like `nested_field.sub_field`
- Must flatten data at index time for ES|QL access

### Unsupported Field Types

These field types are not supported or have limitations:

| Type           | Status                                                                             |
| -------------- | ---------------------------------------------------------------------------------- |
| `nested`       | Not supported - returns null                                                       |
| `flattened`    | Not natively supported; use `METADATA _source` + `JSON_EXTRACT` for sub-key access |
| `join`         | Not supported                                                                      |
| `date_range`   | Not supported                                                                      |
| `binary`       | Not supported                                                                      |
| `completion`   | Not supported                                                                      |
| `rank_feature` | Not supported                                                                      |
| `histogram`    | Not supported                                                                      |

### JOIN Limitations

`LOOKUP JOIN` (8.18/9.0+):

- Only LEFT OUTER JOIN behavior
- Lookup index must use `index.mode: lookup` setting
- Lookup index limited to single shard (max 2B docs)
- Cross-cluster joins require lookup index on all clusters
- Only supports equality joins before 9.2

`LOOKUP JOIN` improvements in 9.2 (tech preview):

- Multi-field joins supported
- Complex join predicates with `<`, `>`, `<=`, `>=`
- Expression-based join conditions

`LOOKUP JOIN` improvements in 9.3 (tech preview):

- Lucene-pushable predicates: `MATCH`, `QSTR`, `KQL`, `CIDR_MATCH` in join conditions
- Further performance gains for filtered joins

### Subqueries (Limited)

ES|QL supports **subqueries in `FROM`** (Serverless tech preview) for combining results from multiple pipelines (UNION
ALL semantics). These are non-correlated — each branch is independent.

```esql
FROM
  (FROM web_logs | WHERE status >= 500 | KEEP @timestamp, message, service.name),
  (FROM app_logs | WHERE level == "error" | KEEP @timestamp, message, service.name)
| SORT @timestamp DESC
```

**Not supported:**

- Subqueries in `WHERE` clauses (no `WHERE field IN (FROM ...)`)
- Correlated subqueries (branches cannot reference outer columns)
- Nested SELECT / CTEs (Common Table Expressions)

Use `INLINE STATS` (9.2+) for per-row vs. aggregate comparison patterns.

## Cross-Cluster Query Support

| Feature                   | Version | Notes                                     |
| ------------------------- | ------- | ----------------------------------------- |
| Basic CCS                 | 8.13    | Query remote clusters                     |
| Cross-cluster ENRICH      | 8.13    | Enrich with remote data                   |
| Cross-cluster LOOKUP JOIN | 9.2     | Join with remote lookup indices           |
| `skip_unavailable`        | 8.17    | Graceful handling of unavailable clusters |

## Output Formats

| Format | Version | Notes                   |
| ------ | ------- | ----------------------- |
| JSON   | 8.11    | Default format          |
| CSV    | 8.11    | Tabular output          |
| TSV    | 8.11    | Tab-separated           |
| Arrow  | 8.15    | Apache Arrow IPC format |

## API Endpoints

| Endpoint                    | Version | Notes                   |
| --------------------------- | ------- | ----------------------- |
| `POST /_query`              | 8.11    | Synchronous query       |
| `POST /_query/async`        | 8.13    | Async query submission  |
| `GET /_query/async/{id}`    | 8.13    | Get async query results |
| `DELETE /_query/async/{id}` | 8.13    | Cancel async query      |

## Performance Tips by Version

### 8.14+

- Regex patterns are optimized
- Enrich supports text fields

### 8.15+

- Use `::` casting instead of `TO_*` functions (cleaner syntax)
- Arrow format for analytics tool integration

### 8.17+

- Use `MATCH`/`QSTR` instead of `LIKE`/`RLIKE` for text search (50-1000x faster)
- Full-text functions use Lucene optimizations

### 9.1+

- Use `INLINE STATS` to avoid multiple queries
- Full-text functions are GA and stable

### 9.2+

- Use `TS` with `RATE`, `AVG_OVER_TIME`, etc. for time series metrics aggregations (preview in 9.2-9.3, GA in 9.4)
- Use `TBUCKET` for time bucketing in TS queries (GA in 9.4)
- Multi-field `LOOKUP JOIN` for complex correlations
- `FUSE` for hybrid search scoring

### 9.3+

- Use `TRANGE` instead of manual `WHERE @timestamp` filters
- Sliding window parameter for time series functions (e.g. `RATE(field, 10m)`); in 9.2-9.3 the window must be a multiple
  of the `TBUCKET` interval, this restriction is lifted in 9.4
- `CLAMP`, `CLAMP_MIN`, `CLAMP_MAX` for bounding metric values

### 9.4+

- `TS` source command and **all** time series aggregation functions are now **GA** — both the 9.2-introduced set
  (`RATE`, `IRATE`, `INCREASE`, `DELTA`, `IDELTA`, `*_OVER_TIME`, `PRESENT_OVER_TIME`, `ABSENT_OVER_TIME`) and the
  9.3-introduced set (`DERIV`, `PERCENTILE_OVER_TIME`, `STDDEV_OVER_TIME`, `VARIANCE_OVER_TIME`).
- `TBUCKET` grouping function is **GA**.
- New `WITHOUT(...)` grouping function (GA) for time series queries: `BY WITHOUT(dim1, ...)` groups by every dimension
  except the listed ones; `BY WITHOUT()` (no args) is equivalent to the implicit "group by all dimensions" behavior.
- New `METRICS_INFO` and `TS_INFO` processing commands (both **GA**) for discovering the metric catalogue and dimension
  labels of TSDS data without inspecting index mappings. Both must come after a `TS` source command and must appear
  before pipeline-breaking commands (`STATS`/`SORT`/`LIMIT`). `METRICS_INFO` returns one row per distinct metric
  signature; `TS_INFO` returns one row per (metric, time series) combination with the identifying dimension labels.
- Sliding window parameter (`RATE(field, 10m)`) accepts arbitrary durations — no longer limited to multiples of the
  `TBUCKET` interval. Note: a single query cannot mix windows smaller than the bucket for one metric with windows larger
  than the bucket for another metric.
- New `PROMQL` source command (preview) to run Prometheus Query Language directly against TSDS indices, with implicit
  range selectors and a Kibana-aware `step`/`buckets` model. See [promql-command.md](promql-command.md). Prefer `PROMQL`
  only when the user explicitly thinks in PromQL or is migrating Prometheus dashboards/alerts; otherwise prefer `TS`.
- `MV_EXPAND` is GA
- `VALUES` aggregation is GA

### Serverless (latest)

- `SET time_zone` with IANA timezone strings for query-wide timezone support (GA)
- `LIMIT n BY field` for grouped top-N queries
- `URI_PARTS`, `USER_AGENT`, `REGISTERED_DOMAIN` pipe commands for parsing structured strings
- `FROM` subqueries for combining results from multiple pipelines (tech preview)
- `EARLIEST`/`LATEST` aliases for `FIRST`/`LAST` aggregations
- `JSON_EXTRACT` on `METADATA _source` for accessing flattened field sub-keys

## Version Detection

To check ES|QL availability and version:

```bash
# Check Elasticsearch version and build flavor (use build_flavor to detect Serverless)
curl -s localhost:9200 | jq '.version | {number, build_flavor}'

# Test ES|QL availability
curl -X POST localhost:9200/_query \
  -H "Content-Type: application/json" \
  -d '{"query": "ROW x = 1"}'
```

## References

- [ES|QL Timeline of Improvements](https://www.elastic.co/search-labs/blog/esql-timeline-of-improvements)
- [ES|QL Limitations](https://www.elastic.co/docs/reference/query-languages/esql/limitations)
- [Elasticsearch Release Notes](https://www.elastic.co/docs/release-notes/elasticsearch)
- [ES|QL for Search](https://www.elastic.co/docs/solutions/search/esql-for-search)
- [LOOKUP JOIN Documentation](https://www.elastic.co/docs/reference/query-languages/esql/esql-lookup-join)
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall