Gemini

Gemini is Google’s family of large language models (LLMs). It can generate text, images, audio, video, and code. This page explains how to connect the Connect AI MCP to Gemini through either the command-line interface or the Google Agent Development Kit (ADK).

​

Prerequisites

Before you can configure and use Gemini with Connect AI, you must first connect a data source to your Connect AI account. See Sources for more information.

Settings ページでPersonal Access Token（PAT）を生成します。PAT をコピーし、認証時にパスワードとして使用します。

You need Python >= 3.10 to use the Gemini tools.

​

Connect through the Gemini Command Line Interface

After you install Gemini, do the following:

1. Go to your user directory %USERPROFILE% and create a .gemini folder.

2. Within the folder, create a file named settings.json.

3. Copy and paste the following into the settings.json file. Replace EMAIL with your Connect AI email and PAT with the PAT you obtained in the prerequisites:

   {
   "mcpServers": {
      "connect-cloud": {
         "httpUrl": "https://mcp.cloud.cdata.com/mcp/",
         "headers": {
           "Authorization": "Basic EMAIL:PAT"  //Replace with your Connect AI's Email and PAT
        },
         "trust": true
      }
    },
   "selectedAuthType": "oauth-personal"
   }
   
4. In the terminal, type gemini. You may need to give Google authorization to access your account.

5. The Gemini screen appears as follows:

   
6. Enter a prompt in the prompt box to ask Gemini a question. Gemini uses the Connect AI tools such as getCatalogs, getSchemas, and getTables to retrieve data from connected data sources.

7. Gemini returns a response to your prompt.

   

​

Connect through the Google ADK

1. Download the folder adk-mcp-client and unzip the folder.

2. Rename .env example to .env.

3. In the .env file, replace [e-mail] with your Connect AI email, and replace your_mcp_password_here with the PAT created in the prerequisites.

4. Run pip install -r requirements.txt in your terminal.

5. Run python -m google.adk.cli web --port 5000. This starts the ADK at port 5000 on your local machine.

6. In your web browser, open 127.0.0.1:5000. The application looks like the following:

   
7. Enter a prompt in the Type a Message box. Gemini uses the Connect AI tools such as getCatalogs, getSchemas, and getTables to retrieve data from connected data sources.