Slack SQL

Execute SQL queries inside of Slack

get it

Reviews

 

Discussion

Hunter
Makers
You need to become a Contributor to join the discussion - Find out how.
Seth WangMaker@sethwang10 · Maker
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
BrianBest@brianbest · Software Developer
@sethwang10 note to self, don't drop tables from slack :P
Philip Young@philipyoungg · Designer and Developer
@brianbest hahaha!
Seth WangMaker@sethwang10 · Maker
@brianbest Will pay attention to drop table command hahaha.
Farooq Adam@farooq_adam · Co-founder Fynd
This is a game changer! Love the idea and implementation. Great job!
Gennady Barsky@gennady_barsky · CFO
Love this!
Seth WangMaker@sethwang10 · Maker
@gennady_barsky Thanks! Glad to hear you love it :)
Andrei Oprisan@andreioprisan · VP Technology at Liberty Mutual
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!
Jourdan Bul-lalayao@jourdanb21 · Co-Founder & CTO, Jobox
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!!!
Seth WangMaker@sethwang10 · Maker
@jourdanb21 Thanks! Very glad to hear this can be helpful to you! 😉 Let me know if you have any questions about setting things up.