Skip to Content

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:

Screenshot from 2015-09-18 11:54:21.png

Viewing a memory graph:

Screenshot from 2015-09-18 11:52:53.png

Help and command list

Screenshot from 2015-09-18 12:08:12.png

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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. WIlliam Overton Post author

    I have fixed some of the issues windows users were having in the latest release (v1.1.4)

    You can now run ‘npm update -g censql’ to get the latest version 🙂

    (0) 

Leave a Reply