Database Tools Resources

Use Database Tools to create, manage, and use the following resources:

Connections

Connections are resources that contain the necessary information for accessing an Oracle Database or MySQL Database in OCI. Connections are created by simply providing information about where the database is and what type it is (Autonomous Database, DB system database, MySQL database, or Exadata VM cluster database). The connection also contains the user used to access the database and the location of the password that is stored in the OCI vault. Other connection details include database role (for example, SYSDBA) and if the connection uses a private endpoint.

SQL Worksheet

The SQL Worksheet utilizes the connection you create with the service to provide you the ability to run SQL commands and scripts from the OCI Console. Scripts used in the SQL Worksheet can reside in either OCI Object Storage or on your local drive. Using the Connection selection menu, you can change the connection that the SQL Worksheet is using instantly.

Private endpoints

Private endpoints provide network access from the Database Tools service to a database through your virtual cloud network (VCN).