2 Select your AI Provider and LLMs

Choose an AI provider and LLM that meets your security standards and aligns with your specific needs, like text or code generation.

Different LLMs excel at various tasks based on their training data and intended purpose. Some models are excellent for text generation but may not perform well in code generation, while others are specifically optimized for coding tasks. Choose an LLM that best suits your needs.

AI Provider LLMs Purpose

OCI Generative AI

  • meta.llama-3.3-70b-instruct (default)

  • meta.llama-3.2-90b-vision-instruct

  • meta.llama-3.2-11b-vision-instruct

  • meta.llama-3.1-70b-instruct

  • meta.llama-3.1-405b-instruct

  • cohere.command-r-08-2024

  • cohere.command-r-plus-08-2024

  • cohere.command-r-16k (deprecated)

  • cohere.command–r-plus (deprecated)

  • xai.grok-3

  • xai.grok-3-fast

  • xai.grok-3-mini

  • xai.grok-3-mini-fast

  • xai.grok-4

  • xai.grok-4-fast-reasoning

  • xai.grok-4-fast-non-reasoning

The OCI Generative AI Chat models are supported for all SELECT AI actions such as runsql, showsql, explainsql, narrate, and chat.

The OCI Generate text models are supported only for SELECT AI chat action.

To configure your profile attributes, see Profile Attributes.

Azure OpenAI Service

  • GPT-4o
  • GPT-4
  • GPT-4 Turbo with Vision
  • GPT-3.5-Turbo

Best suited for generating SQL from natural language prompts, chat action, and Select AI.

OpenAI

  • gpt-3.5-turbo (default)
  • gpt-4o
  • gpt-4o-mini
  • gpt-4
  • gpt-4-0613
  • gpt-4-32k
  • gpt-4-32k-0613
  • gpt-3.5-turbo-0613
  • gpt-3.5-turbo-16k
  • gpt-3.5-turbo-16k-0613

Best suited for generating SQL from natural language prompts, chat action, and Select AI.

OpenAI-Compatible

Models from OpenAI-compatible providers such as:
  • Fireworks AI
  • xAI
  • Others

Supports a wide range of use cases.

Cohere

  • command (default)
  • command-nightly (experimental)
  • command-r
  • command-r-plus
  • command-light
  • command-light-nightly (experimental)
  • custom models

Best suited for chat action.

Google

  • gemini-1.5-flash (default)
  • gemini-1.5-pro
  • gemini-1.0-pro

Best suited for generating SQL from natural language prompts, chat action, and Select AI.

Anthropic

  • claude-3-5-sonnet-20240620 (default)
  • claude-3-opus-20240229
  • claude-3-sonnet-20240229
  • claude-3-haiku-20240307

Best suited for generating SQL from natural language prompts, chat action, and Select AI.

Hugging Face

  • Mixtral-8x7B-Instruct-v0.1 (default)
  • Meta-Llama-3-70B-Instruct
  • Qwen1.5-1.8B
  • other chat models

Best suited for generating SQL from natural language prompts, chat action, and Select AI.

AWS

Supports a wide range of use cases.

Note:

  • Specify OpenAI-compatible provider through provider_endpoint instead of provider parameter. See Profile Attributes.

  • For models that accept images, use meta.llama-3.2-90b-vision-instruct. This model is specifically trained for vision and images. While it can be used for text and SQL generation, the model is best suited for images. To learn more, see Chat in OCI Generative AI.

    The meta.llama-3.2-11b-vision-instruct model provides robust multimodal capabilities.