Skip to content

Chart Data Agent Node

UI/Elements/Charts/Agent

Uses an LLM to write and run SQL against a DataFusion session, returning chart-ready struct data.

a2ui_chart_data_agentstdLong running
Inputs7
Outputs4
Security exposure7/10
Packagestd

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

SecurityAttack surface and exposure impact.
7/10High
PrivacyPotential sensitivity of processed data.
6/10Medium
PerformanceRuntime or resource pressure.
5/10Medium
GovernancePolicy, audit, or compliance impact.
7/10High
ReliabilityOperational stability considerations.
6/10Medium
CostExternal or compute cost impact.
4/10Medium

Input Pins

7

Generate

Execution
exec_in

Trigger data generation

Model

Struct
model

LLM model (Bit)

BitBit19 fields
idstring
default ""
typeBitTypes
enum "Llm", "Vlm", "Tts", "Stt"...default "Other"
metaMap<string, Metadata>
default {}
*Metadatamap value
namestringrequired
descriptionstringrequired
long_descriptionstring | null
release_notesstring | null
tagsArray<string>required
itemsstringarray item
+11 more fields
authorsArray<string>
default []
itemsstringarray item
repositorystring | null
default null
download_linkstring | null
default null
file_namestring | null
default null
hashstring
default ""
sizeinteger | null
format uint64default nullmin 0
hubstring
default ""
parametersvalue
default null
versionstring | null
default null
licensestring | null
default null
dependenciesArray<string>
default []
itemsstringarray item
dependency_tree_hashstring
default ""
createdstring
default ""
updatedstring
default ""
model_slugstring | null
default null
+1 more fields
Schema enforced

Session

Struct
session

DataFusion session to query

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired
Schema enforced

Table

String
table

Table name within the session to query

Description

String
description

Natural language task (e.g. 'monthly sales by region')

Chart Type

String
chart_type

Target chart type

Default bar
autobarlinepieradarheatmap+2 more

Element

Struct
element

Chart element reference (from Get Element) to bind the data to

NivoChartPropsNivoChartProps27 fields
chartTypeBoundValuerequired

The chart type (bar, line, pie, radar, etc.)

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 1PathDefaultvariant

Default value for path bindings - stores the preview value

variant 2nullvariant
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
itemsSelectOptionarray item
+1 more fields
titleanyOf (2)

Chart title displayed above the chart

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
dataanyOf (2)

Chart data in Nivo format (varies by chart type)

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
heightanyOf (2)

Chart height (e.g., "400px")

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
colorsanyOf (2)

Color scheme name (e.g., "nivo", "paired") or array of colors

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
animateanyOf (2)

Enable animations

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
showLegendanyOf (2)

Show legend

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
legendPositionanyOf (2)

Legend position: "top", "bottom", "left", "right"

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
indexByanyOf (2)

Key for indexing data (bar, radar charts)

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
keysanyOf (2)

Data keys to display (bar, radar, stream charts)

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
marginanyOf (2)

Chart margins { top, right, bottom, left }

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
axisBottomanyOf (2)

Bottom axis configuration

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
axisLeftanyOf (2)

Left axis configuration

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
axisTopanyOf (2)

Top axis configuration

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
axisRightanyOf (2)

Right axis configuration

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
barStyleanyOf (2)

Bar chart specific style options

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
lineStyleanyOf (2)

Line chart specific style options

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
pieStyleanyOf (2)

Pie/donut chart specific style options

variant 1BoundValuevariant

Represents a value that can be either a literal or a data path binding

variant 1PathBindingvariant

Path binding with optional default value for preview

pathstringrequired
defaultValueanyOf (2)
variant 2objectvariant
literalStringstringrequired
variant 3objectvariant
literalNumbernumber:doublerequired
format double
variant 4objectvariant
literalBoolbooleanrequired
variant 5objectvariant
literalOptionsArray<SelectOption>required
+1 more fields
variant 2nullvariant
+9 more fields

Output Pins

4

Done

Execution
exec_out

Fires when generation is complete

Data

Struct
data

Query results as an array of row structs (chart-ready)

SQL

String
sql

Generated SQL query

Explanation

String
explanation

AI explanation of the query

Node Info

Internal name
a2ui_chart_data_agent
Category
UI/Elements/Charts/Agent
Version
5