Run data warehouse queries directly from chat channels
When a team member posts a request in a designated channel in Symphony, automatically execute a predefined query in MySQL and log the updated row.
Google for Startups AcceleratorHow Knit builds this workflow
The Agent researches both APIs and wires the trigger on one side to the action on the other — no pre-built connector required. Here is the vocabulary it has to work with.
MySQL Explore MySQL →
TriggersFires when a new row is added to a table in MySQL.
Fires when an existing row changes in MySQL.
Fires when a scheduled query in MySQL finishes running.
Runs a SQL query against MySQL and returns the result.
Writes a new or updated row to MySQL.
Syncs a table in MySQL with data from another source.
Symphony Explore Symphony →
TriggersFires when a new message is posted to a channel in Symphony.
Fires when your team or a keyword is mentioned in Symphony.
Fires when a new channel is created in Symphony.
Fires when a new file is shared in Symphony.
Posts a message to a channel in Symphony.
Sends a direct message to a person in Symphony.
Creates a new channel in Symphony.
Adds a user to a channel in Symphony.
More MySQL + Symphony workflows
See all MySQL + Symphony integrations → · Browse the full workflow library →
Enterprise-grade security
Common questions
Can Knit build “Run data warehouse queries directly from chat channels” between MySQL and Symphony?
Yes — describe it in the box above and Knit's Integrations Agent researches MySQL and Symphony's public API docs (or your own uploaded docs) and builds a working workflow, whether or not either app already has a pre-built connector.
How long does it take to build?
Minutes to a first working version, not weeks — you test it against real data before it goes anywhere near production.
Can I post database query results straight into chat?
Yes, when scheduled queries finish or new rows are inserted in MySQL, key insights are posted directly to channels in Symphony.
Can team chat messages update records in my data warehouse?
Yes, posting specific requests or messages in Symphony can invoke automated queries that insert or update rows in MySQL.