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.
Now available: managed MCP Servers for Oracle AI Database.
Learn and share SQL, for free. Get Instant access to the Oracle AI Database
Key Features
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. Database connections support multiple authentication schemes including user/passwords secured by OCI Vault as well as IAM authentication (token-based).
MCP Servers
Managed MCP Servers enable MCP clients to securely access Oracle AI Database through the Model Context Protocol (MCP). Integrated with OAuth 2.0 support in IAM Identity Domains, it provides enterprise-ready access control. Users can grant MCP clients access through the standard OAuth authorization flow or connect using a Personal Access Token. The service provides built-in tools and supports custom tools implemented in SQL and PL/SQL. Access to each tool is managed through application roles assigned to users and groups.
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.
SQL Reports
SQL Reports are predefined, parameter-driven SQL queries that you create to enable consistent, repeatable reporting. Compared to ad-hoc SQL execution, SQL Reports provide a controlled and auditable way to run approved queries.
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.
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.
AI Database Tools Service key benefits
1
Easy Access to any Oracle Cloud AI Database
In just a few simple guides steps, create a connection to any Oracle Database in Oracle Cloud Infrastructure to instantly start using via SQLcl or the web bases SQL Worksheet.
Learn how to create a connection.
2
Share Database Connections
By utilizing groups and policies, share database connections, not passwords, among services, applications, or users.
Learn more about the Database Tools Policies.
3
MCP Servers
The Database Tools MCP Server is a cloud-based serverless solution that enables you to connect Large Language Models (LLMs) to your database.
Learn more about Database Tools MCP Server.
4
Web-based Tools
No client software to download, configure or install. Use the database connections in either the web-based SQL Worksheet or SQLcl via the Cloud Shell.
Learn how to use the SQL Worksheet.