This Week's Sponsor:

Listen Later

Listen to Articles as Podcasts


SQLPro Studio: A Cross DB Management Tool for macOS [Sponsor]

Do you work on a Mac, but need to interface with Enterprise Databases such as Oracle or Microsoft SQL server? Are you tired of firing up a Windows virtual machine just to run a query? Have you ever wished for a native Mac client? SQLPro Studio is the answer you’ve been looking for.

SQLPro Studio is a native Mac application that works with MSSQL server (both on premise and in Azure), Oracle, MySQL, PostreSQL and SQLite. The interface is fast and responsive, just like you’d expect from a native Mac app. It should go without saying, but SQLPro Studio can connect to databases hosted on Windows, Mac or Linux operating systems and supports either direct connection, or tunneling over SSH.

Write and execute queries in the tabbed query interface, SQLPro Studio supports all the features you’d expect: drag and drop fields from the SQL browser on the left to the SQL editor, auto complete SQL statements including table and field names, even reformat your SQL code to make it ‘pretty.’

You can easily export results as CSV, JSON or XML, and you can edit your results inline so long as you have a primary key on the table.

SQLPro Studio is your all in one solution for managing databases of all kinds, natively, from your Mac!

SQLPro Studio - macOS database management UI is available for $109.99, but MacStories readers can get 20% off by using the promo code MACSTORIES.

SQLPro Studio Studio is also available on the Mac App Store.

Unlock More with Club MacStories

Founded in 2015, Club MacStories has delivered exclusive content every week for over six years.

In that time, members have enjoyed nearly 400 weekly and monthly newsletters packed with more of your favorite MacStories writing as well as Club-only podcasts, eBooks, discounts on apps, icons, and services. Join today, and you’ll get everything new that we publish every week, plus access to our entire archive of back issues and downloadable perks.

The Club expanded in 2021 with Club MacStories+ and Club Premier. Club MacStories+ members enjoy even more exclusive stories, a vibrant Discord community, a rotating roster of app discounts, and more. And, with Club Premier, you get everything we offer at every Club level plus an extended, ad-free version of our podcast AppStories that is delivered early each week in high-bitrate audio.

Choose the Club plan that’s right for you:

  • Club MacStories: Weekly and monthly newsletters via email and the web that are brimming with app collections, tips, automation workflows, longform writing, a Club-only podcast, periodic giveaways, and more;
  • Club MacStories+: Everything that Club MacStories offers, plus exclusive content like Federico’s Automation Academy and John’s Macintosh Desktop Experience, a powerful web app for searching and exploring over 6 years of content and creating custom RSS feeds of Club content, an active Discord community, and a rotating collection of discounts, and more;
  • Club Premier: Everything in from our other plans and AppStories+, an extended version of our flagship podcast that’s delivered early, ad-free, and in high-bitrate audio.