Create a Database Connection

For Password-Based Authentication

1. Create a Database Tools connection dbuser@dbtoolsmcp with the schema that will be used to connect to the database.

   For more information about creating a connection, see Creating a Connection.

2. Enter the following details when creating the connection:

   • Select Oracle Autonomous AI Database.
   • Enter username: ADMIN.
   • Select user password secret.
   • Select Wallet format: Oracle auto-login wallet (for example, cwallet.sso)
   • Select SSO wallet content secret.
   • In Advanced options - Settings, set Runtime Identity to Resource Principal.
     Note
     
     

     • Connection Resource Principal is used to retrieve secrets.
     • The User password secret and Wallet content secret must be created in the same compartment where the Database Tools Connection resource principal is allowed to read secrets.

For Token-Based Authentication

1. Create a Database Tools connection admin@dbtoolsmcp in the dbtools-mcp compartment with a privileged user (for example, ADMIN) using password-based authentication.
2. Enable IAM Authentication in the database.
   1. Select the admin@dbtoolsmcp connection.
   2. Expand Actions and select Configure external authentication.
   3. For External authentication type, select OCI_IAM.
   4. Click Update to save the configuration.

3. Create a Database Tools connection dbtoolsmcp in the dbtools-mcp compartment using token-based authetication.

   When creating the connection:

   • Select Oracle Autonomous AI Database.
   • In Advanced Options - Authentication, enable Use token based authentication.