To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. I may not have gone where I intended to go, but I think I have ended up where I needed to be. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. I may not have gone where I intended to go, but I think I have ended up where I needed to be.

Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. It collects process metrics such as CPU load, RAM usage, and a variety of other resources over SSH/SNMP. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network.