elasticsearch-esql

Convert natural language prompts into executable ES|QL queries for Elasticsearch.

58|5|Updated Nov 26, 2022

Search Tags:#visualization #nlp #elasticsearch #vega-lite #natural-language #esql

Ready to run

npx skills add https://github.com/walterra/eddoapp --skill elasticsearch-esql

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: elasticsearch-esql
Source: https://github.com/walterra/eddoapp/tree/main/packages/chat-agent/skills/elasticsearch-esql
Command: npx skills add https://github.com/walterra/eddoapp --skill elasticsearch-esql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines data exploration by turning natural language prompts into executable ES|QL queries against Elasticsearch, eliminating guesswork and manual crafting of queries.

Core Features & Use Cases

Generate ES|QL queries from natural language descriptions and execute them against Elasticsearch.
Visualize results with Vega-Lite charts or Graphviz diagrams for architecture views.
Access reference material and sample queries via integrated guidance and references, enabling quick iteration on data analysis and dashboards.

Quick Start

Install dependencies, configure Elasticsearch access, and run the CLI to generate or execute ES|QL queries.

Frequently Asked Questions about elasticsearch-esql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I convert natural language to ES|QL queries for Elasticsearch?▼

You can convert natural language to ES|QL queries by providing text prompts that describe your data exploration goals. The tool generates executable ES|QL commands targeting Elasticsearch syntax like FROM, WHERE, EVAL, STATS BY, and SORT.

Can I visualize Elasticsearch query results without manually writing chart code?▼

Yes, you can visualize Elasticsearch query results automatically using Vega-Lite charts or Graphviz diagrams. The tool generates visualizations directly from your executed ES|QL queries to help you explore logs and metrics.

What ES|QL syntax commands are supported when generating queries from text?▼

The supported ES|QL syntax includes FROM, WHERE, EVAL, STATS BY, KEEP, DROP, SORT, and LIMIT commands. This coverage allows you to filter, aggregate, transform, and sort Elasticsearch data sources using natural language prompts.

How do I get started querying Elasticsearch logs using natural language?▼

To start querying Elasticsearch logs, install the necessary dependencies, configure your Elasticsearch access, and run the CLI tool. You can then input natural language prompts to generate, execute, and visualize ES|QL queries against your data sources.

Does this natural language query tool work for exploring Elasticsearch metrics?▼

Yes, the tool works for exploring both Elasticsearch logs and metrics. It translates your natural language data exploration prompts into executable ES|QL queries, enabling quick iteration on data analysis and dashboards.

Are there limitations to generating ES|QL queries from natural language?▼

The tool enforces specific ES|QL syntax coverage including FROM, WHERE, EVAL, STATS BY, KEEP, DROP, SORT, and LIMIT. Queries are constrained to this supported syntax when generating executable commands from natural language prompts.