This documentation describes the integration of MindsDB with Cohere, a technology company focused on artificial intelligence for the enterprise. The integration allows for the deployment of Cohere models within MindsDB, providing the models with access to data from various data sources.

​
Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or Docker Desktop.
  2. To use Cohere within MindsDB, install the required dependencies following this instruction.
  3. Obtain the Cohere API key required to deploy and use Cohere models within MindsDB. Sign up for a Cohere account and request an API key from the Cohere dashboard. Learn more here.

​
Setup

Create an AI engine from the Cohere handler.

CREATE ML_ENGINE cohere_engine
FROM cohere
USING
    cohere_api_key = 'your-cohere-api-key';

Create a model using cohere_engine as an engine.

CREATE MODEL cohere_model
PREDICT target_column
USING
      engine = 'cohere_engine',  -- engine name as created via CREATE ML_ENGINE
      task = 'task_name',        -- choose one of 'text-summarization', 'text-generation'
      column = 'column_name';    -- column that stores input/question to the model

​
Usage

The following usage examples utilize cohere_engine to create a model with the CREATE MODEL statement.

Create a model to predict the answer to a question using the text-generation task.

CREATE MODEL cohere_model
PREDICT answer
USING
      engine = 'cohere_engine',
      task = 'text-generation',
      column = 'question';

Where:

NameDescription
taskIt defines the task to be accomplished.
columnIt defines the column with the text to be acted upon.
engineIt defines the Cohere engine.

Query the model to get predictions.

SELECT answer
FROM cohere_model
WHERE question = 'What is the capital of France?';

Here is the output:

answer
The capital of France is Paris. Paris is France’s largest city and a major global center for art, culture, fashion, and cuisine. It is renowned for its iconic landmarks such as the Eiffel Tower, Notre-Dame Cathedral, and the Louvre Museum.

Next Steps

Go to the Use Cases section to see more examples.