Slack SQL

Execute SQL queries inside of Slack

10 followers

Execute SQL queries inside of Slack

10 followers

Visit website

Launch tags:Messaging•API•Software Engineering

Launch Team

CLI for Toptal Developer Blogs

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

Report

10yr ago

@sethwang10 note to self, don't drop tables from slack :P

Report

10yr ago

Session

@brianbest hahaha!

Report

10yr ago

CLI for Toptal Developer Blogs

Maker

@brianbest Will pay attention to drop table command hahaha.

Report

10yr ago

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!

Report

10yr ago

Clay

@sethwang10 Love this concept! Somewhat of a rookie here though – not sure how to install the integration in Slack? Thanks!

Report

7yr ago

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!!!

Report

10yr ago

CLI for Toptal Developer Blogs

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.

Report

10yr ago