Skip to content

Add Suggested SQL Queries Panel to SQL Console in LogExplorer #1549

@elmilan06

Description

@elmilan06

Describe the feature

Enhance the SQL Console within the LogExplorer module by introducing a Suggested SQL Queries Panel.
This new UI component will display a curated list of predefined SQL queries that users can quickly select and load into the SQL editor. The goal is to improve usability, reduce friction for common query patterns, and accelerate investigation workflows.

Currently, the SQL Console allows users to manually write SQL queries against OpenSearch indices. With this enhancement, users will be able to insert ready‑to‑use SQL snippets with a single click, making the console more accessible and efficient.

Use Case

A user wants to run a common SQL query without typing it manually.
They open the SQL Console, click on one of the suggested queries in the left panel, and the system automatically loads that SQL into the editor. The user can then execute the query immediately.

Proposed Solution

Create a new Angular component inside the existing code-editor module:

  • Displays a list of predefined SQL queries with descriptive labels.
  • On click, emits the selected query to the parent component.
  • Integrates visually with the SQL Console layout (left panel).

Other Information

No response

Acknowledgements

  • I may be able to implement this feature request
  • This feature might incur a breaking change

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

Status

🏗 In progress

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions