May 4, 2026
gm, builders! Here’s your roundup of this week’s onchain insights.
Highlights:
-
AI SQL Helpers
-
Ask AI Follow-up Questions
-
Funnels Compare Mode
-
Area Chart
-
Global Search
-
Profile Side Panel
-
Analytics API
-
Reading List
AI SQL helpers
Three new AI helpers now sit next to the SQL editor on both the Explorer page and the create/edit chart page
-
Generate SQL turns a plain-English prompt into a query against your project’s schema.
-
Format SQL cleans up an existing query in place.
-
Explain this Query describes what a SQL block does in plain English so you don’t have to read someone else’s CTEs to understand a chart.
Ask AI Follow-up Questions
Every Ask AI response now ends with suggested follow-up questions you can click to keep digging.
The suggestions are generated from the conversation so far and the project’s saved charts, events, and segments, so they stay relevant to the data you’re actually looking at instead of pulling you off-topic.
Funnels Compare Mode
The funnel chart now has a Compare mode toggle in its date controls, mirroring the one on the overview page, so you can put two date ranges side by side.
Each step now also shows the median time to convert from the previous step, so you can see where users stall, not just where they drop.
Area Charts
You can now create Area Charts.
Area charts support stacking out of the box. It’s available alongside Line, Bar, Number, and the other existing chart types.
Global Search
Hit Cmd+K (or Ctrl+K) anywhere in the app to open a command palette. Jump to key pages, custom boards, segments, past chats, and settings even more quickly.
If your query does not match a known action, ask the question directly to Ask AI.
Profile Side Panel
On the Users page, clicking a user now opens its profile in a side panel instead of a full page load.
The side panel keeps your filtered list visible so you can scan a cohort and dip into individual wallets without losing context. A link to the standalone profile page is still there when you want the full surface.
Analytics API
The Analytics API is now live, with 18 public endpoints that expose the same backed data that powers every chart on the Formo dashboard. Use this to build internal tooling and dashboards with Formo data.
Reading List
-
Stablecoins are going local by Robert Hackett and Jeremy Zhang (a16zcrypto) . Link
-
Where I’m spending time in crypto right now by PMAYR . Link
-
The New PMF Playbook: Three Patterns Working in Crypto Right Now by Jason Rosenthal . Link
-
State of Onchain Credit by Patryk . Link