Query Studio, powered up

Query Studio is where most Marketing Cloud SQL gets written. It is also bare: an editor, a Run button, and nothing else. The VeLens Chrome extension turns it into a playground for your data without changing how you use it.

Queries you would otherwise write again

The Query Library holds 24 templates for the things every SFMC admin ends up writing: engagement, list hygiene, operations, subscribers and journeys.

All the system data views

Everyone remembers _Sent, _Open and _Click. Then you need bounce categories or SMS history and you are back in the documentation. The Data View Explorer lists all 30 system data views with their fields, in 7 groups. Click one to drop it into your query.

Field names without typing them

The slow part of writing SFMC SQL is typing 40 field names correctly from a data extension you cannot see. The extension adds a Data Extensions button to the toolbar. Search for a data extension and click Use in Query. The extension fetches its fields and writes the SELECT query with all the fields from the data extension.

Click Use in Query on a second data extension and it joins the two instead of replacing the first. It looks for a shared identity field in this order: SubscriberKey, then Email or EmailAddress, then Phone, then a shared primary key, then any field with the same name in both. If it finds one, you get a LEFT JOIN. If it finds nothing, you get two separate SELECT statements and a note saying why.

Two details that stop the generated SQL failing later. Column names that appear in both data extensions are aliased with the data extension name. Fields that start with an underscore get an alias without it, because a Query Activity will not accept those names in its target. Anything you typed in the editor before is kept above the generated block.

Tabs that stay

The extension adds a tab strip to Query Studio. Keep a query you run every week in its own tab and double-click the tab to give it a name. Tabs survive a reload, a business unit switch and closing the browser. Open Query Studio tomorrow and yesterday's work is still there. You can have up to 50 tabs open.

Your recent queries, kept

Every query you run is kept in a Recent Queries panel: the last 50, with duplicates removed. It sits in the Object Explorer column under Marketing Cloud's own cards. Click one and its SQL drops into the tab you are in, so a query you ran last Tuesday is one click away instead of a rewrite.

Smaller things

• Format SQL tidies a query you pasted in as one long line.
• Remove comments strips -- and /* */ comments, and leaves comment-like text inside quotes alone.
• Dark mode for the Query Studio window.
• A resizable editor. Drag the handle under it. The height is remembered. Double-click to reset.

What it costs

Nothing. Everything runs on the Marketing Cloud session you are already logged into. Your tabs and history live in your browser. No signup, no Installed Package.