Your Data Dashboard in Beekeeper Studio

Query Magics turn raw data into visualizations you can use.

Raw data can be hard to read when you need to get a quick answer.

Query Magics are Beekeeper Studio’s way to make that data more useful. With them, you can turn:

• Numbers into star ratings or progress bars
• Booleans into clear ✅ or ❌ marks
• Image URLs into inline thumbnails
• Email addresses into mailto links
• Foreign keys into drill-through links to related tables

And it’s all done with standard SQL. Here’s how.

How to use Query Magics

Query Magics use column aliases to tell Beekeeper Studio how to interpret your data. Because they’re just standard SQL, they still behave like normal column names anywhere else.

Say you’ve got a rating column in your product_reviews table — wouldn’t it be better if those ratings showed up as stars?

With the Query Magic __format__stars you can do just that:

SELECT 4 AS rating__format__stars__5;

Run that query now in Beekeeper Studio and you’ll see:

Query Magics don’t just visualize numbers — they can turn URLs into live, inline images too.

SELECT
  'https://placedog.net/200/200' AS 
  photo__format__image__100;

That will give you:

Those are just two of the Query Magics available — simple column aliases that turn raw SQL results into stars, images, progress bars, links, and even replace numeric IDs with readable enums you define.

Try them in Beekeeper Studio, the modern, cross-platform, open-source database GUI with Query Magics, AI-assisted queries, and support for 20+ databases.

Beekeeper Studio Inc. PO Box 140565, Dallas, TX 75214
View web version – Unsubscribe