Hexa Studio in 59 secondsFlows · Flow tasks · Web resources · REST builder

SQL, FetchXML and Flows for Dataverse.

A free Windows app to query any table, build FetchXML visually, read every flow, review flow edits before they ship and see which runs failed.

Download for Windows GitHub

{x}

Set variable - varTotalin Condition › True

Value

@add(variables('varTotal'), body('Get_order')?['amount'])

Variables

varTotal integer

Initialize variable - varTotaltop level

declared

Set variable - varTotalin Condition › True

set

Start an approvalin Condition › True

read

3.1× faster SELECT

On a 15,779-row table, Hexa reads key ranges side by side instead of one page at a time.

16 MB

A native app built with Tauri and Rust. It installs for your user, no admin rights.

Passwords stored. You sign in with Microsoft and the token stays in Windows Credential Manager.

Query any table with SQL. Even the big ones.

Write T-SQL and press F5. Hexa plans it into FetchXML and streams rows into the grid as they land.

SELECT o.name, o.totalamount, a.name AS customer
FROM   salesorder o
JOIN   account a ON a.accountid = o.customerid
WHERE  o.statecode = 0
ORDER BY o.totalamount DESC

name	totalamount	customer
SO-10482	48,200.00	Contoso Ltd
SO-10477	31,505.50	Fabrikam Inc
SO-10469	29,040.00	Adventure Works
SO-10455	17,602.25	Northwind Traders

name

totalamount

customer

SO-10482

48,200.00

Contoso Ltd

SO-10477

31,505.50

Fabrikam Inc

SO-10469

29,040.00

Adventure Works

SO-10455

17,602.25

Northwind Traders

15,779 rows page 1page 2page 3page 4

Reads every table: Virtual tables included. The TDS endpoint takes over for what FetchXML can't plan.
Writes ask first: INSERT, UPDATE and DELETE show how many records change and wait for your OK.
A real editor: Monaco with table and column completion, tabs per environment and full history.

Build FetchXML without typing it.

Pick a table, tick columns, join along real relationships and the XML writes itself. Prefer typing? Every table and column name completes.

fxfetchtop 50

tblaccount

colname

colrevenue

sortrevenue ↓

fltAND

ifstatecode = 0

joincontact as c

colfullname

Condition

Column of account

statecode Status

Operator

eq, Equals ▾

Value

0 · Active ▾

No problems found

1,284

rows match, counted without reading them. Missing columns and wrong operators are flagged before you run.

Page through or load everything, open system and personal views, export to CSV.

<fetch top="50">  <entity name="account">    <attribute name="name" />    <attribute name="revenue" />    <order attribute="revenue" descending="true" />    <filter>      <condition attribute="statecode" operator="eq" value="0" />    </filter>    <link-entity name="contact" from="contactid" to="primarycontactid" alias="c">      <attribute name="fullname" />    </link-entity>  </entity></fetch>

Read a flow like the person who built it.

Designer
Steps in the order they run. Conditions and switches as columns, scopes and loops you can fold.
Variables
Where each variable is declared, changed and read, with a warning when a parallel loop changes it.
Search
Ctrl+F across step names, connectors and settings. Matches light up, the rest steps back.

See which flows failed, and what started them.

Run history for every flow in a solution, read from Dataverse. Count the failures, then follow a failed child flow up to the run that called it.

Runs1,847in the last 24 hours

Failed633.4% of runs

Flows with failures4of 38 that ran

FailedOther runs

1 PM1 AMnow

FlowFailedFail rateLast failure

Sync orders to ERP384.2%8 min ago

Validate shipping address173.7%8 min ago

Nightly invoice export625%9 h ago

Notify account owner21.1%3 h ago

Hand a flow to Claude. See every change before it ships.

Check the flows of one task out into a folder of their own. Whoever edits them, you, a teammate or Claude Code, each save is compared with the original and with the cloud.

HexaTasks › TASK-482

CLAUDE.mdthe task, the rules
task.json
flows
Invoice-Sync__3f2a9c1e/definition.jsonsaved
Notify-approvers__81bd04aa/definition.json
.hexa/baselinethe originals

PS TASK-482> claude
Editing Invoice-Sync__3f2a9c1e/definition.json…

Baseline, DEV when addedWorking copy, saved just now

What changed · List invoice lines

inputs › parameters › $filter

- _invoiceid_value eq @{…invoiceid} + _invoiceid_value eq @{…invoiceid} and statecode eq 0

Checks

Nothing looks broken.

New connection reference shared_office365, it has to exist in DEV.

Only the flows you were given: Add them from the task or with Add to task in Flows. Each one is read from the environment as its baseline.
Any two versions, side by side: The original, the edited file, the cloud now and every earlier version, as JSON or drawn like the designer.
Checks before you trust it: Missing actions and variables, broken runAfter, connection references. And a warning when someone changed the flow in the cloud meanwhile.

The rest of your admin toolbox, in the same window.

Each tool reads the environment you already have open. Nothing is written until you review it and say so.

Press Ctrl K to jump to any table, flow or tool.

Monitoring

Plug-in traces: The trace log, newest first. Filter by class, message or table and follow one execution chain.
System jobs: Async plug-ins, workflows and imports, with their status and the reason they failed.

Configuration

Plug-in steps: Assemblies, steps and images by assembly or by table. Microsoft's stay hidden until you ask.
Dependencies: What blocks deleting a table or column, including the plug-in steps and flows Dataverse doesn't track.
Security: A user's real privileges across every role and team, two roles side by side, and why someone can or can't open a record.

Customization

Web resources: Edit JavaScript, HTML and CSS in place. Before anything is saved you see the diff, then save and publish in one step.

CContoso, FFabrikam and NNorthwind. All signed in.

One project per tenant, each with its own Microsoft sign-in and environments. Switching asks first, and production is marked in red.

About Hexa Studio

Hexa Studio is founded and developed by Truong Tan Dat, a Power Platform and Dataverse developer based in Ho Chi Minh City, Vietnam. It brings flows, web resources and the Dataverse Web API together in one fast desktop app, so makers and developers can review every change before it reaches their environments.

Company: Hexa StudioOperated by Truong Tan Dat as sole founder. Not yet incorporated.
Location: Ho Chi Minh City, Vietnam
Team: Truong Tan Dat, FounderProduct, engineering and support · LinkedIn
Contact: founder@hexastudio.com.vn
Policies: Privacy Terms Security & data

Running in a minute.

Free for Windows 10 and 11, 64-bit. It updates itself from then on.

Download for Windows

Latest release on GitHub

Questions, pilots or partnerships: write to the founder at founder@hexastudio.com.vn or connect on LinkedIn

Download
Get the latest setup.exe from GitHub Releases.
Install
It installs for your user only. The app isn't code-signed yet, so if Windows warns you, choose More info then Run anyway.
Sign in
Create a project, sign in with your Microsoft account and pick an environment.

WebView2 is installed for you if it's missing. The TDS endpoint and writes also need the ODBC Driver 17 for SQL Server.