Query Magics
Turn plain SQL results into visual, human-readable output — stars, progress bars, checks, images, links, table jumps, and readable codes — right where you query.
Beekeeper Studio
Reading raw data can add too much cognitive overload. Query Magics let you add hints to your column aliases that tells Beekeeper Studio to render that column’s data in human-readable formats, such as stars, progress bars, checks, images, links, and more.
If you’re storing ratings or completion values as numeric values, they might get lost when browsing your data. With __format__stars and __format__progress, Beekeeper Studio turns those raw numbers into stars or progress bars that help you make sense of them at a glance.
When your results include URLs or foreign key values, switching context slows you down. With __format__link you can open URLs directly and __goto__ lets you jump to related tables filtered by the current value — no copy-pasting required.
If a column contains image URLs, __format__image renders them as thumbnails (with optional width/height) so you can QA faster, recognize products visually, and more.
Turn booleans into ✅/❌ with __format__check and show amounts as localized currency with __format__money. It’s the same data — just easier to scan.
If your data uses numeric codes for things like roles or statuses, __format__enum maps them to readable labels you define in an enums.json file.
Query Magics are just column aliases, so your queries are valid everywhere. Then, when you view them in Beekeeper Studio, you get extra polish to make them easier to read.
This feature and more included with any active Beekeeper Studio license. Download Beekeeper Studio to get started.