Announcing CenSQL: A CLI client for SAP HANA
I created CenSQL to provide command history and shorthand commands useful for monitoring SAP HANA which aren’t available in the hdbsql client.
CenSQL provides a lot more functionality which is not present in hdbsql, such as shortcuts for sql queries useful for any DB admin or developer for example
\al for viewing open alerts on the instance you are connected to. I also put a very large amount of work into the usability of CenSQL, making it more like a modern CLI REPL tool.
CenSQL does not need to be installed on the HANA server, and can be installed on a different machine to then access the HANA Server remotely providing the correct port (3XX15, where XX is the instance No.) is open. CenSQL uses password based authentication for each connection.
For Installation Instructions (Windows/Linux/Mac) see https://www.npmjs.com/package/censql#installation
Here are some examples of using CenSQL:
Viewing the current CPU usage per service:
Viewing a memory graph:
Help and command list
Finally, I made CenSQL for my own use initially and was told my colleagues it could be a good addition to the tools available for HANA developers and administrators. I look forward to getting feedback on how it could be improved in the future.