This week's sponsor

Tumult Hype Professional

Create stunning web animations without the code

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 MacStories Extras

Club MacStories offers exclusive access to extra MacStories content, delivered every week; it's also a way to support us directly.

Club MacStories will help you discover the best apps for your devices and get the most out of your iPhone, iPad, and Mac. It'll also give you access to advanced iOS shortcuts, tips and tricks, and lots more.

Starting at $5/month, with an annual option available.

Join the Club.

A Club MacStories membership includes:

  • MacStories Weekly newsletter, delivered every week on Friday with app collections, tips, iOS workflows, and more;
  • MacStories Unplugged podcast, published monthly with discussions on what we're working on and more;
  • Monthly Log newsletter, delivered once every month with behind-the-scenes stories, app notes, personal journals, and more;
  • Access to occasional giveaways, discounts, and free downloads.