Query Optimizer
Category: Agent
Optimize database queries (SQL, FHIR, Elasticsearch) using AI
What this node does
- SQL optimization
- FHIR query optimization
- ES query optimization
- Performance tips
How to use
- In the Hydra Builder, open or create a workflow
- In the node palette on the left, find Query Optimizer under the Agent category (or use the search bar)
- Drag the node onto the canvas
- Double-click the node to open its configuration dialog
- Fill in the required parameters (see Configuration below)
- Connect the Original Query and Query Type (SQL/FHIR/ES) input port from an upstream node
- Connect the Optimized Query and Optimization Suggestions output to the next node downstream
Inputs
| Port | Type | Required | Description |
|---|---|---|---|
| Original Query | text | ✓ | Plain text string |
| Query Type (SQL/FHIR/ES) | text | ✓ | Plain text string |
Outputs
| Port | Type | Description |
|---|---|---|
| Optimized Query | text | Plain text string |
| Optimization Suggestions | array | A list of items |
Configuration
Open the configuration dialog by double-clicking the Query Optimizer node on the canvas.
| Parameter | What to enter |
|---|---|
queryType | Configure queryType in the node settings |
includeExplanation | Configure includeExplanation in the node settings |
llmConfig | Configure llmConfig in the node settings |
When to use this node
- Optimize slow queries
- Improve FHIR searches
- Database performance tuning
Need help configuring this node?
Go to Settings → Connectors to set up the connection this node depends on, then reference the connector ID in the node configuration dialog.