Query your MPG database using our new(ish) Explorer

A couple months ago, we released a nifty little feature for Fly Managed Postgres - an Explore tab where you could look at all your tables across all your databases, write read-only queries against them, and export the results to a CSV. Neat.

Except it wasn’t actually read-only. Due to the way we (and when I say we here, I mean I) had written the feature, it was running those queries directly in the MPG pod using psql. That was definitely not the intended experience, so we pulled the page to take another pass at it.

We’re happy to announce that it’s finally back. In a neat little twist, we realized there wasn’t much point to keeping it read-only; the new SQL Query Editor will allow you to write to your tables directly (and yes, even drop them) if that’s what you want. In fact, everything you can do as the MPG fly-user is accessible through the query editor, since that’s the same role the editor is using.

So go wild with it! And, as always, let us know what you think :heart:

5 Likes