Slack SQL

Execute SQL queries inside of Slack

get it

Reviews

Seth Wang
 

Discussion

Hunter
Makers
You need to become a Contributor to join the discussion - Find out how.
Seth Wang
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@brianbest · Software Developer
@sethwang10 note to self, don't drop tables from slack :P
Philip Young
Philip Young@philipyoungg · Designer and Developer
@brianbest hahaha!
Seth Wang
Seth WangMaker@sethwang10 · Maker
@brianbest Will pay attention to drop table command hahaha.
Farooq Adam
Farooq Adam@farooq_adam · Co-founder Fynd
This is a game changer! Love the idea and implementation. Great job!
Gennady Barsky
Gennady Barsky@gennady_barsky · CFO
Love this!
Seth Wang
Seth WangMaker@sethwang10 · Maker
@gennady_barsky Thanks! Glad to hear you love it :)
Andrei Oprisan
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
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 Wang
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.