Ask from Slack
Query your database from a channel, approve SQL in-thread, and save results to a dashboard.
Commands
| Command | Does |
|---|---|
/cpdb-ask | Ask a question |
/cpdb-setdb | Choose which connection this channel queries |
/cpdb-model | Choose the model |
You can also @mention the app in a thread instead of using a slash command.
Approval in-thread
If SQL approval is on, the generated query is posted with approve and reject buttons. Approving from Slack runs it and posts the result to the same thread: you never leave the channel.
Results
Charts come back as PNGs. Tables come back as formatted text. Either can be saved straight to a dashboard from the message.
The PNG matters: a chart posted into a channel is readable by everyone in it, including people without a ChatPlotDB account.
Feedback
React to a result, or use the feedback buttons. That feedback feeds the same loop the app uses. See Config Studio's refine step.
The channel decides the database
/cpdb-setdb is per channel, so a #finance channel and a #product channel
can point at different connections without anyone re-selecting each time.