14.2.1 View Available Models

As of MySQL 9.3.2, once you are connected to a DB System, you can view the list of available models and information on them with the ML_SUPPORTED_LLMS view inside the sys schema of the DB System:

SELECT * FROM sys.ML_SUPPORTED_LLMS;

The output is similar to the following:

+----------------+-------------------------------+-------------------+---------------------+---------------+
| provider       | model_id                      | availability_date | capabilities        | default_model |
+----------------+-------------------------------+-------------------+---------------------+---------------+
| HeatWave       | llama2-7b-v1                  | 2024-07-01        | ["GENERATION"]      |             0 |
| HeatWave       | llama3-8b-instruct-v1         | 2024-07-24        | ["GENERATION"]      |             0 |
| HeatWave       | llama3.1-8b-instruct-v1       | 2025-05-20        | ["GENERATION"]      |             0 |
| HeatWave       | llama3.2-1b-instruct-v1       | 2025-05-20        | ["GENERATION"]      |             0 |
| HeatWave       | llama3.2-3b-instruct-v1       | 2025-05-20        | ["GENERATION"]      |             1 |
| HeatWave       | mistral-7b-instruct-v1        | 2024-07-01        | ["GENERATION"]      |             0 |
| HeatWave       | mistral-7b-instruct-v3        | 2025-05-20        | ["GENERATION"]      |             0 |
| HeatWave       | all_minilm_l12_v2             | 2024-07-01        | ["TEXT_EMBEDDINGS"] |             0 |
| HeatWave       | multilingual-e5-small         | 2024-07-24        | ["TEXT_EMBEDDINGS"] |             1 |
| Amazon Bedrock | cohere.command-text-v14       | NULL              | ["GENERATION"]      |             0 |
| Amazon Bedrock | cohere.command-r-v1:0         | NULL              | ["GENERATION"]      |             0 |
| Amazon Bedrock | cohere.command-r-plus-v1:0    | NULL              | ["GENERATION"]      |             0 |
| Amazon Bedrock | cohere.command-light-text-v14 | NULL              | ["GENERATION"]      |             0 |
| Amazon Bedrock | meta.llama3-8b-instruct-v1:0  | NULL              | ["GENERATION"]      |             0 |
| Amazon Bedrock | meta.llama3-70b-instruct-v1:0 | NULL              | ["GENERATION"]      |             0 |
+----------------+-------------------------------+-------------------+---------------------+---------------+
10 rows in set (1.8985 sec)

Note:

For the external LLMs provided by Amazon Bedrock to appear in the list, you need to satisfy the requirements For using the external LLMs listed in HeatWave GenAI Requirements. Only the LLMs supported in your AWS region are listed.