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.

Currently, the recommended chat app is Slack. MS Teams will be fully supported soon.

​
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,
    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:

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:

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;

To create my_slack and be able to talk to the chatbot via DMs, follow this instruction.

To see how the agent is created, follow this example.

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.

Currently, the recommended chat app is Slack. MS Teams will be fully supported soon.

​
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,
    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:

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:

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;

To create my_slack and be able to talk to the chatbot via DMs, follow this instruction.

To see how the agent is created, follow this example.