Node Types
Everything on a FlowFrame canvas is a node. Frames query data, linked frames build on them, charts and parameters make the results interactive, and text, shapes and images explain them.
Query Nodes (Frames)
Frames are the core building blocks of FlowFrame. Each frame holds one SQL query and shows its result as a table, so a frame is a single step in your analysis.
Creating a Frame
Drag a table from the data panel onto the canvas. The frame is named a1 (then a2, a3 and so on) and starts with a default query:
SELECT * FROM table_nameThe frame header shows the frame name, the connection it queries, a Nocode / SQL toggle and an expand button. The query editor sits above the result table.
A frame with its name, connection, Nocode / SQL toggle, query editor and result table
The Frame Toolbar
Click a frame to show its toolbar above it:
Refresh runs the query again.
Analyze data opens the query in a larger editor where you can switch between Nocode steps (Summarize, Filter, Sort and more) and SQL, preview the result, then Save & Run.
+ Add creates a Visualization or a Frame from result linked to this frame.
Frame Settings
With a frame selected, click the menu button at the top right of the canvas to open its settings panel. Click the pencil next to the frame name to rename it.
Style: show or hide the query editor (hide it to use the frame as a plain table), background and text colour, and the border.
Actions: run the query, add a visualization, format the query, get a code breakdown, or add a linked frame.
Export: download the frame as an image or the result as CSV.
Arrange: bring the frame forward or send it back when nodes overlap.
The settings panel for a selected frame
Linked Frames
A linked frame queries the result of another frame, so you can build an analysis in small steps instead of one long query. An arrow on the canvas shows which frame feeds which.
Creating a Linked Frame
Select a frame, click + Add in its toolbar and choose Frame from result. You can also use Add linking frame in the frame settings panel. The new frame starts by selecting everything from its parent:
SELECT * FROM a1Add a visualization or a linked frame from the frame toolbar
Edit the query to reshape the parent's result, for example to aggregate it:
SELECT region, ROUND(SUM(sales)) AS sales
FROM a1
GROUP BY region
ORDER BY sales DESCFrame a2 reads from a1 by name
Dependency Rules
Visualization Nodes
Visualization nodes chart a frame's result. They are connected to their source frame by an arrow and update whenever that frame runs.
Add a chart
Pick the columns
Change the chart type and style
A selected chart with its toolbar and axis chips
Available Chart Types
Line
Vertical Bar
Horizontal Bar
Stacked Bar
Area
Pie
Scatter
Bubble
Histogram
Card
Parameter Nodes
A parameter node holds one value that any number of frames can use. Change the value and every frame that references it, plus the charts built on those frames, update together. This is how you build interactive dashboards.
Create a parameter
(x) Add Parameter Node button in the top toolbar.Configure it
Double-click the name to rename it
Choose a type: String, Number, Date, Boolean or List (comma-separated values)
Enter a value
The footer shows the reference to use in SQL
Reference it in SQL
SELECT order_id, order_date, category, sales
FROM a1
WHERE region = {{region}}Run the frame. An arrow now connects the parameter to the frame.Change the value
'{{region}}' fails with a syntax error.A frame filtered by a parameter
Text, Shape & Image Nodes
Text, shape and image nodes let you label and explain your canvas. Add them from the top toolbar.
Add Text, Add Shapes and Add an Image in the top toolbar
Text Nodes
Click Add Text, then click the canvas where the text should go. Double-click the node to type. While editing, a toolbar lets you set bold, italic, underline, text colour and background fill.
A text node and its formatting toolbar
Shape Nodes
Click Add Shapes and pick a shape: Rectangle, Circle, Triangle, Pentagon, Hexagon, Octagon, Parallelogram, Trapezium, Line. Double-click a shape to open its settings, where you can set rotation (0° to 360°), corner radius, border colour and width, and fill colour.
The shapes you can add to the canvas
Image Nodes
Click Add an Image, then paste an image URL or choose a file from your computer and click Submit. You can resize and move image nodes like any other node.
Add an image from a URL or a local file