hmc
hubot-mysql-chatops
npm i hubot-mysql-chatops
hmc

hubot-mysql-chatops

ChatOps for MySQL.

by Sam Lambert

1.0.0 (see all)License:MITTypeScript:Not Found
npm i hubot-mysql-chatops
Readme

Hubot: hubot-mysql-chatops

A small collection of MySQL ChatOps scripts.

See each script in src/ for full documentation.

Installation

Add hubot-mysql-chatops to your package.json file:

"dependencies": {
  "hubot-mysql-chatops": ">= 1.0.0",
}

Add hubot-mysql-chatops to your external-scripts.json:

["hubot-mysql-chatops"]

Run npm install

Warnings

Some of these scripts execute queries. It is very strongly recommended that a read only user is used and queries are executed on a MySQL slave.

I can't be responsible for you deleting all your data ;)

An example GRANT would be: GRANT SELECT ON some_db.* TO 'hubot_mysql'@'hubot_host' IDENTIFIED BY 'some_pass';

Sample Interaction

user1>> mysql explain SELECT * FROM users
hubot>> user1:
        ┌───────────────┬─────────┬──────────┬────────┬────────┬──────────┬────────┬──────────┬────┐
        │Select TypeTableType      │Possibl…│Key     │Key Len   │RefRows      │Ext…│
        ├───────────────┼─────────┼──────────┼────────┼────────┼──────────┼────────┼──────────┼────┤
        │SIMPLE         │users    │ALLnullnullnullnull0         │    │
        └───────────────┴─────────┴──────────┴────────┴────────┴──────────┴────────┴──────────┴────┘

Thanks

Thanks to everyone who has contributed to Hubot and this packages dependencies.

A special thank you to @technicalpickles for being awesome.

Downloads/wk

1

GitHub Stars

89

LAST COMMIT

8yrs ago

MAINTAINERS

1

CONTRIBUTORS

1

OPEN ISSUES

0

OPEN PRs

0
VersionTagPublished
1.0.0
latest
8yrs ago
No alternatives found
No tutorials found
Add a tutorial