Chatbot

Within MindsDB, chatbots are agents connected to some messaging interface.

Creating a chatbot requires an AI agent and a connection to a chat app, like Slack or MS Teams.

​

How to work with chatbots

A chatbot can be created, deleted, queried, and updated. Here is how you can do that using SQL API.

• Creating a chatbot:

  CREATE CHATBOT my_chatbot
  USING
      database = 'my_slack',                    -- this must be created with CREATE DATABASE
      agent = 'customer_support_agent',         -- this must be created with CREATE AGENT
      included_channels = ['support', 'help'],  -- default is all
      excluded_channels = [],                   -- default is none
      enable_dms = true,                        -- default is true
      is_running = true;                        -- default is true
  

  The parameters include the following:

  • database stores connection to a chat app (like Slack or MS Teams) that should be created with the CREATE DATABASE statement.
  • agent is an AI agent created with the CREATE AGENT command. It consists of an AI model trained with defined data sets.
  • included_channels and excluded_channels are optional and store channel names where the bot will or will not respond.
  • enable_dms is the initially supported mode of talking to a chatbot. A chatbot responds to direct messages.
  • is_running indicates whether or not to start the chatbot upon creation.
  If you want to use Slack in the CREATE CHATBOT syntax, use this method of connecting Slack to MindsDB.

• Deleting a chatbot:

  DROP CHATBOT my_chatbot;
  

You can query all chatbots using these commands:

SHOW CHATBOTS;

SELECT * FROM chatbots;

​

Example

Following the example from here, let’s create a chatbot utilizing the already created agent.

Start by connecting a chat app to MindsDB:

• Follow this instruction to connect Slack to MindsDB.
• Follow this instruction to connect MS Teams to MindsDB.

Next, create a chatbot.

CREATE CHATBOT text_to_sql_chatbot
USING
    database = 'my_slack',        -- this must be created with CREATE DATABASE
    agent = 'text_to_sql_agent',  -- this must be created with CREATE AGENT
    enable_dms = true,
    is_running = true;