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. Database Tools connections also support OCI Identity and Access Management (IAM) authentication when connecting to Oracle Database.

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).

Identities

With identity resources, you can use OCI resource principals to access all OCI resources from an Oracle Database. Identity resources manage an Oracle Database credential and automatically refresh access tokens. You can use the credential with packages such as DBMS_CLOUD or the OCI PL/SQL SDK to access all OCI resources, including Object Storage and Compute.

MCP Servers

Model Context Protocol (MCP) server resources enable you to create and manage MCP Servers that can be used to securely access database capabilities such as querying schemas, running approved SQL statements, or executing database-related tools to AI-assisted workflows.

MCP Toolsets

With MCP toolset resources, you can define and manage the set of database tools and operations that are available through a Database Tools MCP Server.

SQL Reports

SQL Report resources enable you to create and manage predefined SQL queries that provide a controlled and consistent way to run approved database reports through Database Tools.

Database API Gateway Configurations

Database API Gateway configuration resources define how database operations are available as REST APIs through the Database Tools service. These configurations map API endpoints to specific database connections and approved SQL or PL/SQL operations, enabling secure access to database functionality.