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
Report
@sethwang10 note to self, don't drop tables from slack :P
@brianbest Will pay attention to drop table command hahaha.
Report
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!
@sethwang10 Love this concept! Somewhat of a rookie here though – not sure how to install the integration in Slack? Thanks!
Report
Not only is this useful for production environments so that I don't have to ssh into the production server, this is useful for even practicing SQL statements (I gotta practice raw SQL queries instead of relying on the ORM that Ruby on Rails is). Very useful integration, thanks for making it and I can't wait to use it!!!
CLI for Toptal Developer Blogs
Session
CLI for Toptal Developer Blogs
Clay
CLI for Toptal Developer Blogs
CLI for Toptal Developer Blogs