@jimwu There are a few ways you can use existing tools to execute GSQL scripts against your box.
Python
If you are using Python you could look at the pyTigerGraph package which leverages the gsql_client.jar. You can then have your authentication stored in a file that will pull every time you are executing the GSQL function.
Also in Python, there is a tool called pyTigerGraphBeta in which we removed the java dependency, and the client (driver) is in pure python but has the same functions as the non-beta version.
Documentation:
https://pytigergraph.github.io/pyTigerGraph/GettingStarted/
pyTigerGraph Video:
pyTigerGraph Beta Video:
Sample NoteBook:
Gradle with Giraffle Plugin
Another way is using Giraffle a plugin for Gradle that is built to execute GSQL scripts against your environment. You can have a multitude of environments and run the Gradle Tasks that you generate against your box.
Documentation:
Giraffle Video:
Sample Project using Giraffle:
Step by Step Blog: