slack-reporter

slack-reporter is a node script to identify all those tables in the database that may run out of auto incremented IDs. It identifies all those tables and sends a slack message for the same.

• It uses MySQL's sys database.
• It uses Slack's Webhooks to send messages to Slack.
• The app is going to be deployed on Heroku.

Tech

slack-reporter uses a number of open source projects to work properly:

• node.js - evented I/O for the backend
• Express - fast node.js network app framework @tjholowaychuk
• MySQL - Relational Database
• mysql - A pure node.js JavaScript Client implementing the MySql protocol.

Installation

slack-reporter requires Node.js v6+ to run.

Install the dependencies and start the server. By default it runs at port 5000.

$ cd slack-reporter
$ npm install
$ node app.js

Todos

• Add a cloud database to run on Heroku.
• Add support for Slack commands.
• Optimizations

License

MIT