elastic/elasticsearch-esql

ES|QL(Elasticsearchクエリ言語)クエリを実行します。ユーザーがElasticsearchデータのクエリ、ログの分析、メトリクスの集計、データの探索、またはES|QLの結果に基づくチャートやダッシュボードの作成を希望する場合に使用します。

elasticsearch-esql とは?

このスキルは、Elasticsearchのクエリ言語であるES|QL(Elasticsearch Query Language)を実行するためのものです。ユーザーがElasticsearchに格納されたデータを検索、分析、集計したり、ログを調査したり、データを探索する際に役立ちます。また、ES|QLのクエリ結果を基にしたチャートやダッシュボードの作成もサポートしており、可視化や監視のユースケースに最適です。このスキルは、Claude CodeやClineなどのAIエージェントプラットフォームで使用でき、自然言語による指示から直接ES|QLクエリを生成・実行します。これにより、ユーザーはElasticsearchのクエリ構文を深く理解していなくても、複雑なデータ分析や可視化を効率的に行うことが可能になります。

対応~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/elastic/agent-skills/tree/main/skills/elasticsearch-esql

Installed? Explore more 生産性&コラボレーション skills: steipete/gemini, steipete/gh-issues, steipete/skill-creator · View all 6 →

お気に入りのAIに質問する

このエージェントスキルを事前に読み込んだ状態で新しいチャットを開きます。

ドキュメント

elasticsearch-esql は何をしますか?

ES|QL(Elasticsearchクエリ言語)クエリを実行します。ユーザーがElasticsearchデータのクエリ、ログの分析、メトリクスの集計、データの探索、またはES|QLの結果に基づくチャートやダッシュボードの作成を希望する場合に使用します。

使用方法

このスキルは、AIエージェントがES|QLクエリを実行するためのものです。以下のようなリクエストに対して使用します。

  • Elasticsearchデータに対するクエリの実行
  • ログデータの分析
  • メトリクスの集計
  • データの探索
  • ES|QLの結果に基づくチャートやダッシュボードの作成

例

# 直近1時間のエラーログを検索
FROM logs-*
| WHERE @timestamp >= NOW() - 1 hour
| WHERE severity == "error"
| SORT @timestamp DESC
| LIMIT 100
# レスポンスコード別のリクエスト数を集計
FROM nginx-access-*
| STATS count = COUNT(*) BY response_code
| SORT count DESC

対応プラットフォーム

このスキルは、Claude Code、Cline、Cursor、CodexなどのAIエージェントプラットフォームで使用できます。

注意事項

  • ES|QLクエリを実行する前に、Elasticsearchクラスターへの接続が適切に設定されていることを確認してください。
  • クエリの実行結果は、直接チャートやダッシュボードとして表示できます。
  • このスキルは、ElasticsearchのドキュメントやAPIと連携して動作します。

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

elastic/cloud-access-management

Manage Elastic Cloud organization access: invite users, assign roles to Serverless projects, and create or revoke Cloud API keys. Use when granting, modifying, or auditing user access.

elastic/cloud-create-project

Creates Elastic Cloud Serverless projects (Elasticsearch, Observability, or Security) via the REST API, saves credentials to file, and bootstraps a scoped Elasticsearch API key. Use when creating a new serverless project, provisioning a search or observability environment, or spinning up a new Elastic Cloud project.

elastic/cloud-manage-project

Manages existing Elastic Cloud Serverless projects: list, get, update, delete, reset credentials, resume, and load saved credentials. Connects to existing projects by resolving endpoints and acquiring scoped Elasticsearch API keys. Use when performing day-2 operations on serverless projects, connecting to an existing project, loading or resetting project credentials, or looking up project details.

elastic/cloud-network-security

Manage Serverless network security (traffic filters): create, update, and delete IP filters and AWS PrivateLink VPC filters. Use when restricting network access or configuring private connectivity.

elastic/cloud-setup

Configures Elastic Cloud authentication and environment defaults. Use when setting up EC_API_KEY, configuring Cloud API access, or when another cloud skill requires credentials.

elastic/elasticsearch-audit

Enable, configure, and query Elasticsearch security audit logs. Use when the task involves audit logging setup, event filtering, or investigating security incidents like failed logins.

elastic/elasticsearch-authn

Authenticate to Elasticsearch using native, file-based, LDAP/AD, SAML, OIDC, Kerberos, JWT, or certificate realms. Use when connecting with credentials, choosing a realm, or managing API keys. Assumes the target realms are already configured.

elastic/elasticsearch-authz

Manage Elasticsearch RBAC: native users, roles, role mappings, document- and field-level security. Use when creating users or roles, assigning privileges, or mapping external realms like LDAP/SAML.

elastic/elasticsearch-file-ingest

Ingest and transform data files (CSV/JSON/Parquet/Arrow IPC) into Elasticsearch with stream processing and custom transforms. Use when loading files or batch importing data — not for reindexing, general ingest pipeline design, or bulk API patterns.

elastic/elasticsearch-onboarding

Help developers new to Elasticsearch get from zero to a working search experience. Guide them through understanding their intent, mapping their data, and building a search experience with best practices baked in. Use this when the user shows intent to build search-related functionality, asks about Elasticsearch-related concepts for their use case, or expresses the need for help getting started with Elasticsearch.

elastic/elasticsearch-security-troubleshooting

Diagnose and resolve Elasticsearch security errors: 401/403 failures, TLS problems, expired API keys, role mapping mismatches, and Kibana login issues. Use when the user reports a security error.

elastic/kibana-agent-builder

Create and manage Agent Builder agents and custom tools in Kibana. Use when asked to create, update, delete, test, or inspect agents or tools in Agent Builder.

elastic/kibana-alerting-rules

Create and manage Kibana alerting rules via REST API or Terraform. Use when creating, updating, or managing rule lifecycle (enable, disable, mute, snooze) or rules-as-code workflows.

elastic/kibana-audit

Enable and configure Kibana audit logging for saved object access, logins, and space operations. Use when setting up Kibana audit, filtering events, or correlating Kibana and ES audit logs.

elastic/kibana-connectors

Create and manage Kibana connectors for Slack, PagerDuty, Jira, webhooks, and more via REST API or Terraform. Use when configuring third-party integrations or managing connectors as code.

elastic/kibana-dashboards

Create and manage Kibana Dashboards and visualizations. Use when you need to define dashboards and visualizations declaratively, version control them, or automate their deployment.

elastic/kibana-streams

List, inspect, enable, disable, and resync Kibana Streams via the REST API. Use when the user needs stream details, ingest/query settings, queries, significant events, or attachments.

elastic/kibana-vega

Create Vega and Vega-Lite visualizations with ES|QL data sources in Kibana. Use when building custom charts, dashboards, or programmatic panel layouts beyond standard Lens charts.

elastic/observability-edot-dotnet-instrument

Instrument a .NET application with the Elastic Distribution of OpenTelemetry (EDOT) .NET SDK for automatic tracing, metrics, and logs. Use when adding observability to a .NET service that has no existing APM agent.

elastic/observability-edot-dotnet-migrate

Migrate a .NET application from the classic Elastic APM .NET agent to the EDOT .NET SDK. Use when switching from Elastic.Apm.* packages to Elastic.OpenTelemetry.

関連スキル