Oracle Database Tools Service

Oracle Database Tools Service is a managed offering in Oracle Cloud Infrastructure (OCI) that enables you to create connections to any Oracle Database in OCI that can be reused by multiple users, resources, and services. Once a connection is established, use the web-based SQL Worksheet for direct SQL access or use the connection in a SQLcl session via the OCI Cloud Shell. Sensitive information such as passwords and Autonomous Database client credentials are stored securely and encrypted in your OCI vault and never viewed when connections are being used.

Learn all about the Database Tools Service (23:32)

Oracle Database Tools Service features

Providing you with the tools to make Oracle Cloud Infrastructure cloud database connections secure, easy, and reusable for development, DevOps processes, and SQL access.

Database connections

Database connections are resources that contain the necessary information for accessing an Oracle Database in OCI. Connections are created by simply providing information about where the database is and what type it is (Autonomous, VM, or Exadata). The connection also contains the user used to access the database as well as the location of the password that is stored in the OCI vault.

Creating database connections is simple using the guided user interface. Select the OCI database type and the innovative connection builder automatically discovers databases and assists in creating the connection. Database credentials are stored in the OCI vault and retrieved only when accessing the database. If the credentials change, you can quickly and easily update them in the vault, minimizing any disruptions. Share database connections, not passwords, among groups and users.

Get started by creating a connection

SQL worksheet

The SQL Worksheet utilizes the database connections you create with the service to enable you 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 quickly change the connection that the SQL Worksheet is using.

Using the SQL Worksheet

Private endpoints

Many Oracle Cloud Infrastructure services are protected by multiple layers of network security. For the Database Tools Service to access these database services, a path into a customer's virtual cloud network (VCN) must exist. Private endpoints give the database tools network access to these databases through a customer’s virtual cloud network, which in turn allows you to access these databases from the SQL Worksheet or via SQLcl from the OCI Cloud Shell. One private endpoint can service multiple database in the same virtual cloud network.

Using private endpoints with Database Tools

APIs and events

The Database Tools Service has many APIs for you to use with your favorite application development platform. Our GitHub repository has many examples for all the latest development languages to help you get started with the Database Tools Service APIs. The service also has events you can subscribe to in OCI that enable you to create automation based on changes such as creation or updating of a connection.