HeidiSQL: SQL in the Land of Alps and Watches
The majestic call of the Alphorn comes echoing down the mountain, filling the air with ancient mystery. A goat herder tending his modest collection of livestock patiently guides them through an alpine meadow. Children in villages festively dance around the maypole, their ribbons gradually forming a beautiful pattern. A watchmaker hunches over their workbench, patiently placing microscopic gears into place. A developer launches HeidiSQL, eager to begin querying data with their trusted SQL Client.
Yes, these are the sights and sounds of Switzerland! Ancient tradition, beautiful mountain landscapes, and an oddly named, yet time-tested, SQL client. Created in 2006 by Asgar Becker (but having origins pre-dating that), HeidiSQL is a versatile open-source SQL Client. If you are looking for a portable, free SQL Client, it is worth a look.
In this post, we will embark upon a grand Swiss adventure, installing and working with HeidiSQL to achieve our loftiest SQL dreams. Along the way, we'll meet a young ambitious shepherd named Matteo, will see how he uses HeidiSQL to grow his business, and solve problems in his life.
Picture, if you will, snowy mountain peaks, a green valley, and the Heidi SQL download link. Click it. Visualize your request as a flock of Alpine Choughs lifting into
With the download complete, a simple setup screen collects your database information. This includes the standard connection strings, authentication, port info, as well as more technical matters (SSL, etc). Enter your connection string and credentials, and away you go!
Upon logging into the selected session and database, you are greeted with
- list of databases and tables on left
- typical operations in
- toolbar on top
- main query window/workspace in center
- One interesting addition - the lower output pane displays all the SQL sent to the database (for example, to compile the list of tables for the
treeviewon left). This could be valuable for learning about your database schema, and how to interrogate it yourself!
In the folklore version of the story "Heidi", a young girl was sent to live with a recalcitrant grandfather in the remote mountains of Switzerland. She gradually won him over with her innocent charm, and eventually taught him to read! In your own version of Heidi, you are the stubborn grandfather, obstinately refusing to embrace all that your database has to offer. Allow Heidi SQL to shine some light into your withered database worldview, and brighten your SQL experience!
A Boy Named Matteo, a Stubborn Aunt, and Their Cows
Now that we've installed HeidiSQL, let's use it to spin some Volkskunde about a young mountain herdsman (Matteo) who must track his modest collection of Braunvieh (cattle), lest his wicked Auntie Adhelburg
Let's start by creating a database:
What sort of information does young Matteo need to track? He's got cattle he cares
Now that we've defined the table, HeidiSQL allows for adding rows with
And with the data in place, we can use good old fashion SQL to query the results. Once Matteo learns a little SQL, he is hyper-informed about all aspects of the herd:
With this powerful database under his command, Matteo's days of counting cattle on his fingers are over! And if Auntie Adhelburg wishes to question him about the health of their herd, she's in for a surprise! Some simple querying will provide immediate feedback about their weight, and any recent observations Matteo has about the herd. Schöön!
Matteo's glee over this powerful tool is short-lived, however. Auntie Adhelburg saw the
Thankfully, HeidiSQL can connect to multiple types of databases. SQL Server, MySql, as well as PostgreSQL! Matteo is now in control of the situation, effortlessly choosing the best database for the job. When Auntie Adhelburg witnesses this turn of events, a small burst of warmth appears in her
But Seriously Folks...
I'm obviously spicing this article up with as much Swiss-ness as I can reasonably muster, hopefully with some comedic effect. However, Heidi SQL makes for a decent choice as a SQL client, with many cool features:
- MySQL, SQLServer, and PostgreSQL support
- All the standard things (querying, schema, user permissions, etc)
- Reporting, formatting, searching
- SQL text
formatter(this can be really handy when you've got a long block of run-on SQL!)
- Free and Open Source
If you're looking for a cross-platform SQL Client, HeidiSQL is definitely worth taking for a spin!
Now that Matteo is master of his SQL destiny, there's another tool he might include in his "
As Matteo's SQL expertise grows, he can expand upon his helpful database, and continue to feed the reports into SQLBot. If his organization grows (say, a pretty young Swiss girl comes into Matteo's life, and begins managing the books. Beware Auntie Adhelburg's jealousy!), the SQLBot/Slack combination will grow with them. Important data at their fingertips, with only Matteo needing to manage the technical aspect of things (using Heidi SQL, of course!).
Now Matteo can focus on growing his business! The women in his life are happy, everyone's informed on daily progress, and the future never looked brighter! Du
Try SQLBot - It's Free!
Sign up for a free account on SQLBot to see how easy it is to get SQL reports into your Slack. What are you waiting for, it's free!