Using with gemini-cli

📍 Navigation: Documentation Home | Server Guide | Getting started | Architecture | Installation | Configuration | Security | Customization | Client Guide

⚠️ Version Compatibility Notice: This integration requires gemini-cli version 0.1.9. Use the following command to run the correct version:

npx @google/gemini-cli@0.1.9

1. Make sure you have Teradata database access. (the most convenient way: Go to https://clearscape.teradata.com create account and login, start the environment and click on Run Demo)
2. Go to https://github.com/Teradata/teradata-mcp-server run below lines in cmd terminal. (once build finished, you should see Teradata-mcp-server image in your docker desktop)
   • export DATABASE_URI=teradata://username:password@host:1025 (use the username, password, host from above clearscape step)
   • git clone https://github.com/Teradata/teradata-mcp-server.git
   • cd teradata-mcp-server
   • docker compose up
3. Go to https://github.com/google-gemini/gemini-cli follow instruction to install
   • For authenticate, please use personal google email.
4. Go to your project folder, create .gemini/settings.json accordingly

{
    "theme": "Default",
    "selectedAuthType" : "oauth-personal",

    "mcpServers": {
        "teradata-http": {
            "httpUrl" : "http://127.0.0.1:8001/mcp/",
            "timeout" : 300000
        }
    }
}

* **Note:** The timeout is set to 300000ms (5 minutes) to accommodate long-running analytical operations like clustering. Adjust if needed.

5. Open a cmd terminal, type npx @google/gemini-cli@0.1.9 and hit enter, now you should see gemini-cli interface. * Note: Using version 0.1.9 is required for compatibility with the Teradata MCP server.