A NodeJS web application to edit SQL queries and run again Cisco CUCM database. Results are returned to a web-based spreadsheet that can be download to CSV if needed.
Administrative XML (AXL) information can be found at: Administrative XML (AXL) Reference.
Run as native node application using npm:
npm install
npm run start
Build and run using Docker:
npm run docker:build
npm run docker:run
Pull image from Docker.io and run with the following:
docker run -d -p 3000:3000 --name cucm-sql-editor --restart=always --env-file=.env -v cucm-sql-data:/app/data sieteunoseis/cucm-sql-editor:latest
For more information on docker image check hub.docker.com.
NODE_ENV=production
CUCM_HOSTNAME=devnetsandbox.cisco.com
CUCM_USERNAME=administrator
CUCM_PASSWORD=ciscopsdt
CUCM_VERSION=12.5
Check data folder for SQL examples. If you use Docker you want to mount this folder to the host with the -v flag. Once mounted you can edit/add or update files externally from container.
API's used in this project can be used externally. Currently they are unsecured. Documentation can be found at:
Web-based CodeMirror editor. Configured to support x-sql. This allows for generic SQL support as IBM's informix is not widely used.
Option to Run pasted or loaded query for quick access, or ability to save or format query.
Results returned to an excel like table, with the ability to sort, filter and search.
API's used in the application are documented via swagger. Check them out at:
Currently this application will only do select statements. Update queries are not supported.
If you would like to support my work and the time I put in creating the code, you can click the image below to get me a coffee. I would really appreciate it (but is not required).