Now you can execute SQL queries right in your Slack input box! After config the database host and deploy the codes to whichever server, add the integration to Slack, then you can execute SQL query right in your Slack.
This is extremely useful for database administrators and engineers, without switching screen or opening another terminal, type the SQL query in Slack and you will get what you want!
Try it out:
1. Add an Slash command integration to your Slack. (like /sql)
2. Specify url as: https://slack-sql.herokuapp.com/
3. Execute the SQL query in Slack! For example, type "/sql select * from users", and magic happens!
To make it specify to your database host:
1. Get the source code of this project by clicking GET IT, and check out the README.md
Interesting product, I can definitely see this being useful for remote dev box access. Any way to filter out updates, deletes, drops at the client level? I guess a read-only user is a solution as well but it would be nice to not have to go that extreme and get some options around filtering before posting to SQL. On the negative side, this could also be another attack vector!
CLI for Toptal Developer Blogs
Session
CLI for Toptal Developer Blogs
CLI for Toptal Developer Blogs