Help! How to get credential id for model authentication?

[RobertWangWang]

Self Checks

• I have searched for existing issues search for existing issues, including closed ones.
• I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
• [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:)
• Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing? Tell me about your story.

Assume you add a llm provider like aliyun, dify will add 100+ models but not give you the credential id back, Is there a way to get the credential id? Thank you

2. Additional context or comments

No response

[dosubot[bot]]

To get the credential ID for model authentication in Dify (for example, after adding an LLM provider like Aliyun that registers many models), you have a few options:

1. Dify UI:
If your environment and database are in sync, credential IDs and names should appear in the model/provider configuration UI as dropdown selectors. These are populated from the backend and let you select or view available credentials for each model or provider. If you don't see them, your database may need repair or migration [source].

2. Programmatically (API/backend):
The backend exposes methods to fetch credential IDs. For example, you can use the ProviderManager.get_provider_available_credentials or get_provider_model_available_credentials methods to list all credentials for a provider or a specific model. In the frontend, the useModelProviders() hook fetches available credentials, which you can extract like this:

const { data: modelProviders } = useModelProviders()
const availableCredentials = modelProviders
  ?.find(p => p.provider === model?.provider)
  ?.custom_configuration?.available_credentials || []

Each credential object has a credential_id and credential_name [source].

3. Database (manual):
Credential IDs are stored in the provider_credentials and provider_model_credentials tables, and linked to models/providers via the credential_id column in the provider_models and providers tables. You can query these tables directly to retrieve credential IDs. For example:

SELECT id, credential_name FROM provider_model_credentials WHERE provider_name = 'aliyun';
SELECT credential_id FROM provider_models WHERE provider_name = 'aliyun';

If you have migration or upgrade issues (e.g., missing or mismatched credential IDs), you may need to manually repair the database by ensuring each model's credential_id matches a valid entry in provider_model_credentials. Always back up your database before making manual changes and restart your containers after updates [source], [source], [source].

Let me know if you need step-by-step SQL or Python scripts for your setup!

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}