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.
   Note
   
   This connection is required only for configuring OCI_IAM external authentication in the database.
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 another Database Tools connection dbtoolsmcp in the dbtools-mcp compartment using token-based authentication.

   When creating the connection, do the following:

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