Oracle Database Tools API
The databaseTools API from Oracle — 46 operation(s) for databasetools.
Oracle Database Tools API is one of 378 APIs that Oracle publishes on the APIs.io network, described by a machine-readable OpenAPI specification.
The published artifact set on APIs.io includes an OpenAPI specification and an API reference.
This API exposes 67 operations across 46 paths, and defines 72 schemas. It is described by OpenAPI 3.2.0, at version 20201005.
Requests are made against 2 base URLs: http://127.0.0.1/20201005, https://127.0.0.1/20201005.
67 operations
46 paths
72 schemas
7 DELETE21 GET32 POST7 PUT
Metadata
The identity and technical contract details declared by the specification.
Paths & Operations 67
Across 46 paths, the API surfaces 67 operations — 7 DELETE, 21 GET, 32 POST, 7 PUT. Each is listed below with its method, path, parameters, and response codes.
databaseTools 67
GET
/databaseToolsConnections
Lists Database Tools connections in a compartment
POST
/databaseToolsConnections
Creates a new Database Tools connection
DELETE
/databaseToolsConnections/{databaseToolsConnectionId}
Deletes a Database Tools connection.
GET
/databaseToolsConnections/{databaseToolsConnectionId}
Gets a Database Tools connection.
PUT
/databaseToolsConnections/{databaseToolsConnectionId}
Updates a Database Tools connection.
POST
/databaseToolsConnections/{databaseToolsConnectionId}/actions/addLock
Adds a lock to a DatabaseToolsConnection resource.
POST
/databaseToolsConnections/{databaseToolsConnectionId}/actions/changeCompartment
Change the compartment of the Database Tools connection.
POST
/databaseToolsConnections/{databaseToolsConnectionId}/actions/removeLock
Removes a lock to a DatabaseToolsConnection resource.
POST
/databaseToolsConnections/{databaseToolsConnectionId}/actions/validateConnection
Validates the Database Tools connection.
GET
/databaseToolsDatabaseApiGatewayConfigs
Lists Database Tools database API gateway configs in a compartment
POST
/databaseToolsDatabaseApiGatewayConfigs
Creates a new Database Tools database API gateway config.
DELETE
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}
Deletes a Database Tools database API gateway config.
GET
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}
Gets a Database Tools database API gateway config.
PUT
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}
Updates a Database Tools database API gateway config.
POST
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}/actions/addLock
Adds a lock to a DatabaseToolsDatabaseApiGatewayConfig resource.
POST
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}/actions/changeCompartment
Changes the compartment of a Database Tools database API gateway config.
POST
/databaseToolsDatabaseApiGatewayConfigs/{databaseToolsDatabaseApiGatewayConfigId}/actions/removeLock
Removes a lock to a DatabaseToolsDatabaseApiGatewayConfig resource.
GET
/databaseToolsEndpointServices
Gets a list of all DatabaseToolsEndpointServices in a compartment
GET
/databaseToolsEndpointServices/{databaseToolsEndpointServiceId}
Get DatabaseToolsEndpointService
GET
/databaseToolsIdentities
Lists Database Tools identities in a compartment
POST
/databaseToolsIdentities
Creates a new Database Tools identity.
DELETE
/databaseToolsIdentities/{databaseToolsIdentityId}
Deletes a Database Tools identity.
GET
/databaseToolsIdentities/{databaseToolsIdentityId}
Gets a Database Tools identity.
PUT
/databaseToolsIdentities/{databaseToolsIdentityId}
Updates a Database Tools identity.
POST
/databaseToolsIdentities/{databaseToolsIdentityId}/actions/addLock
Adds a lock to a DatabaseToolsIdentity resource.
POST
/databaseToolsIdentities/{databaseToolsIdentityId}/actions/changeCompartment
Changes the compartment of a Database Tools identity.
POST
/databaseToolsIdentities/{databaseToolsIdentityId}/actions/refreshCredential
Refresh credential of the identity in the database referenced by the related connection.
POST
/databaseToolsIdentities/{databaseToolsIdentityId}/actions/removeLock
Removes a lock to a DatabaseToolsIdentity resource.
POST
/databaseToolsIdentities/{databaseToolsIdentityId}/actions/validateCredential
Validates a Database Tools identity credential.
GET
/databaseToolsMcpServers
Lists Database Tools MCP servers in a compartment.
POST
/databaseToolsMcpServers
Creates a new Database Tools MCP server.
DELETE
/databaseToolsMcpServers/{databaseToolsMcpServerId}
Deletes a Database Tools MCP server.
GET
/databaseToolsMcpServers/{databaseToolsMcpServerId}
Gets a Database Tools MCP server.
PUT
/databaseToolsMcpServers/{databaseToolsMcpServerId}
Updates a Database Tools MCP server.
POST
/databaseToolsMcpServers/{databaseToolsMcpServerId}/actions/addLock
Adds a lock to a DatabaseToolsMcpServer resource.
POST
/databaseToolsMcpServers/{databaseToolsMcpServerId}/actions/cascadingDelete
Deletes the Database Tools MCP server and all its MCP toolsets.
POST
/databaseToolsMcpServers/{databaseToolsMcpServerId}/actions/changeCompartment
Changes the compartment of a Database Tools MCP server.
POST
/databaseToolsMcpServers/{databaseToolsMcpServerId}/actions/removeLock
Removes a lock to a DatabaseToolsMcpServer resource.
GET
/databaseToolsMcpToolsetVersions
Lists Toolsets and their versions
GET
/databaseToolsMcpToolsets
Lists Database Tools MCP Toolset in a compartment.
POST
/databaseToolsMcpToolsets
Creates a new Database Tools McpToolset.
DELETE
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}
Deletes a Database Tools MCP Toolset.
GET
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}
Gets a Database Tools MCP Toolset.
PUT
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}
Updates a Database Tools MCP Toolset.
POST
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}/actions/addLock
Adds a lock to a DatabaseToolsMcpToolset resource.
POST
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}/actions/changeCompartment
Changes the compartment of a Database Tools MCP Toolset.
POST
/databaseToolsMcpToolsets/{databaseToolsMcpToolsetId}/actions/removeLock
Removes a lock to a DatabaseToolsMcpToolset resource.
GET
/databaseToolsPrivateEndpoints
Lists all Database Tools private endpoints in a compartment.
POST
/databaseToolsPrivateEndpoints
Creates a new Database Tools private endpoint.
DELETE
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}
Deletes a Database Tools private endpoint.
GET
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}
Gets a Database Tools private endpoint.
PUT
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}
Updates a Database Tools private endpoint.
POST
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}/actions/addLock
Adds a lock to a DatabaseToolsPrivateEndpoint resource.
POST
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}/actions/changeCompartment
Change the compartment of the Database Tools private endpoint.
POST
/databaseToolsPrivateEndpoints/{databaseToolsPrivateEndpointId}/actions/removeLock
Removes a lock to a DatabaseToolsPrivateEndpoint resource.
GET
/databaseToolsSqlReports
Lists Database Tools SQL reports in a compartment.
POST
/databaseToolsSqlReports
Creates a new Database Tools Sql Report.
DELETE
/databaseToolsSqlReports/{databaseToolsSqlReportId}
Deletes a Database Tools SQL Report.
GET
/databaseToolsSqlReports/{databaseToolsSqlReportId}
Gets a Database Tools SQL report.
PUT
/databaseToolsSqlReports/{databaseToolsSqlReportId}
Updates a Database Tools SQL Report.
POST
/databaseToolsSqlReports/{databaseToolsSqlReportId}/actions/addLock
Adds a lock to a DatabaseToolsSqlReport resource.
POST
/databaseToolsSqlReports/{databaseToolsSqlReportId}/actions/changeCompartment
Changes the compartment of a Database Tools SQL Report.
POST
/databaseToolsSqlReports/{databaseToolsSqlReportId}/actions/removeLock
Removes a lock to a DatabaseToolsSqlReport resource.
GET
/workRequests
List Work Requests
GET
/workRequests/{workRequestId}
GET Work Request Status
GET
/workRequests/{workRequestId}/errors
Lists work request errors
GET
/workRequests/{workRequestId}/logs
Lists work request logs
Schemas 72
The contract defines 72 schemas that model the data the API accepts and returns. The most detailed are DatabaseToolsPrivateEndpoint (22 properties), DatabaseToolsPrivateEndpointSummary (22 properties), DatabaseToolsMcpServer (21 properties), DatabaseToolsMcpServerSummary (18 properties). Each schema is shown below with its type and property counts.
DatabaseToolsEndpointService
object
Description of Database Tools Endpoint Service.
12 properties
3 required
ValidateDatabaseToolsConnectionResult
object
Connection validation result.
5 properties
3 required
DatabaseToolsMcpServerBuiltInRole
object
Built-in MCP server roles
2 properties
2 required
WorkRequestSummary
object
A summary of the status of a work request.
10 properties
6 required
DatabaseToolsSqlReportCollection
object
List of Database Tools SQL report summary items.
1 property
1 required
ChangeDatabaseToolsMcpToolsetCompartmentDetails
object
Contains the details for the compartment to move the Database Tools MCP Toolset to.
1 property
1 required
ResourceLock
object
Resource locks are used to prevent certain APIs from being called for the resource. A full lock prevents both updating the resource and deleting the resource.…
5 properties
2 required
DatabaseToolsSqlReportColumn
object
Descriptive information on columns referenced in the Database Tools SQL Report source.
3 properties
3 required
CreateDatabaseToolsIdentityDetails
object
Details for the new Database Tools identity.
7 properties
4 required
RemoveResourceLockDetails
UpdateDatabaseToolsPrivateEndpointDetails
object
The information to be updated.
6 properties
ChangeDatabaseToolsSqlReportCompartmentDetails
object
Contains the details for the compartment to move the Database Tools SQL Report to.
1 property
1 required
UpdateDatabaseToolsSqlReportDetails
object
Database Tools SQL report information to be updated.
10 properties
1 required
DatabaseToolsPrivateEndpoint
object
Allows the Database Tools service to connect to databases in a customer's virtual cloud network (VCN).
22 properties
7 required
UpdateDatabaseToolsIdentityDetails
object
Database Tools identity information to be updated.
4 properties
1 required
DatabaseToolsEndpointServiceSummary
object
Summary of the Database Tools Endpoint Service.
12 properties
2 required
DatabaseToolsPrivateEndpointReverseConnectionsSourceIp
object
Source IP information for reverse connection configuration.
1 property
WorkRequestCollection
object
List of WorkRequestSummary items.
1 property
1 required
UpdateDatabaseToolsConnectionDetails
object
The information to be updated.
4 properties
1 required
DatabaseToolsIdentityCollection
object
List of Database Tools identity summary items.
1 property
1 required
DatabaseToolsMcpServerEndpoint
object
The details of an MCP server endpoint.
2 properties
WorkRequestErrorCollection
object
List of WorkRequestError items.
1 property
1 required
WorkRequestError
object
An error encountered while executing a work request.
3 properties
3 required
DatabaseToolsConnectionCollection
object
List of Database Tools connection summary items.
1 property
1 required
CreateDatabaseToolsPrivateEndpointDetails
object
The details for the new Database Tools private endpoint.
11 properties
4 required
UpdateDatabaseToolsMcpToolsetDetails
object
Database Tools MCP Toolset information to be updated.
6 properties
1 required
DatabaseToolsDatabaseApiGatewayConfigSummary
object
Summary of the Database Tools database API gateway config.
13 properties
8 required
CreateDatabaseToolsConnectionDetails
object
Details for the new Database Tools connection.
8 properties
3 required
ChangeDatabaseToolsPrivateEndpointCompartmentDetails
object
Contains the details for the compartment to move the Database Tools private endpoint to.
1 property
1 required
DatabaseToolsPrivateEndpointReverseConnectionConfiguration
object
Reverse connection configuration details of the private endpoint.
1 property
WorkRequestLogEntry
object
A log message from the execution of a work request.
2 properties
2 required
DatabaseToolsMcpToolsetSummary
object
Summary of the Database Tools MCP Toolset.
14 properties
9 required
ValidateDatabaseToolsIdentityCredentialResult
object
Identity validation result.
5 properties
3 required
DatabaseToolsMcpServerSummary
object
Summary of the Database Tools MCP server.
18 properties
11 required
DatabaseToolsMcpToolsetCollection
object
List of Database Tools MCP Toolset summary items.
1 property
1 required
DatabaseToolsPrivateEndpointSummary
object
Summary of the Database Tools private endpoint.
22 properties
7 required
DatabaseToolsIdentity
object
Manages credentials in a database to access service resources.
13 properties
8 required
DatabaseToolsConnection
object
Provides connectivity details required to establish a connection to a database.
15 properties
10 required
AddResourceLockDetails
ValidateDatabaseToolsIdentityCredentialDetails
object
Identity Credential validation details.
1 property
1 required
WorkRequest
object
An asynchronous work request.
10 properties
7 required
DatabaseToolsIdentitySummary
object
Summary of the Database Tools identity.
13 properties
8 required
DatabaseToolsPrivateEndpointCollection
object
List of Database Tools private endpoint summary items.
1 property
1 required
DatabaseToolsSqlReport
object
Allows generating a summary of SQL query execution details for database operations.
18 properties
8 required
DatabaseToolsDatabaseApiGatewayConfig
object
Manage configuration related to database API gateway config resources.
13 properties
8 required
ChangeDatabaseToolsConnectionCompartmentDetails
object
Contains the details for the compartment to move the Database Tools connection to.
1 property
1 required
DatabaseToolsSqlReportVariable
object
A variable referenced in the Database Tools SQL Report source.
3 properties
3 required
DatabaseToolsMcpServerCustomRole
object
DatabaseToolsMcpServerCustomRole.
2 properties
2 required
DatabaseToolsMcpToolsetVersionSummary
object
Summary of versions available for a specific MCP toolset type.
2 properties
2 required
DatabaseToolsEndpointServiceCollection
object
List of DatabaseToolsEndpointServiceSummary items.
1 property
1 required
DatabaseToolsMcpServer
object
Allows the creation, configuration and management of an MCP server.
21 properties
10 required
DatabaseToolsMcpToolset
object
Allows the creation, configuration and management of an MCP Toolset.
15 properties
9 required
WorkRequestResource
object
A resource created or operated on by a work request.
4 properties
3 required
DatabaseToolsDatabaseApiGatewayConfigCollection
object
List of Database Tools database API gateway config summary items.
1 property
1 required
DatabaseToolsMcpToolsetVersionCollection
object
List of MCP toolset type version summary items.
1 property
1 required
ChangeDatabaseToolsIdentityCompartmentDetails
object
Contains the details for the compartment to move the Database Tools identity to.
1 property
1 required
UpdateDatabaseToolsDatabaseApiGatewayConfigDetails
object
Database Tools database API gateway config information to be updated.
4 properties
1 required
DatabaseToolsSqlReportSummary
object
Summary of the Database Tools SQL report.
15 properties
7 required
CreateDatabaseToolsMcpToolsetDetails
object
Details for the new Database Tools MCP server.
9 properties
5 required
ChangeDatabaseToolsMcpServerCompartmentDetails
object
Contains the details for the compartment to move the Database Tools MCP server to.
1 property
1 required
ValidateDatabaseToolsConnectionDetails
object
Connection validation details.
1 property
1 required
WorkRequestLogEntryCollection
object
List of work request log items.
1 property
1 required
RefreshDatabaseToolsIdentityCredentialDetails
object
The Database Tools identity refresh credential details.
1 property
1 required
ChangeDatabaseToolsDatabaseApiGatewayConfigCompartmentDetails
object
Contains the details for the compartment to move the Database Tools database API gateway config to.
1 property
1 required
UpdateDatabaseToolsMcpServerDetails
object
Database Tools MCP server information to be updated.
8 properties
1 required
CreateDatabaseToolsDatabaseApiGatewayConfigDetails
object
Details for the new Database Tools database API gateway config.
7 properties
4 required
Error
object
Error Information.
2 properties
2 required
CreateDatabaseToolsSqlReportDetails
object
Details for the new Database Tools SQL report.
12 properties
4 required
CreateDatabaseToolsMcpServerDetails
object
Details for the new Database Tools MCP server.
12 properties
4 required
DatabaseToolsMcpServerCollection
object
List of Database Tools MCP server summary items.
1 property
1 required
DatabaseToolsMcpServerRelatedResource
object
A related resource
2 properties
2 required
DatabaseToolsConnectionSummary
object
Summary of the Database Tools connection.
15 properties
10 required
Specification
The full machine-readable OpenAPI contract behind this narrative.
Source
More from Oracle 12
Other APIs Oracle publishes across the network.
Oracle Database REST APIs
Oracle Integration Cloud API
Oracle Fusion Cloud Applications API
Oracle Fusion Cloud Financials REST API
Oracle Fusion Cloud HCM REST API
Oracle Fusion Cloud CX Sales and Service REST API
Oracle Fusion Cloud SCM REST API
Oracle Fusion Cloud Procurement REST API
Oracle Content Management API
OCI Generative AI API
OCI AI Vision API
OCI AI Language API
Where this information came from
This is an independent, third-party profile of Oracle Database Tools API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.
The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.
Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.
info@apievangelist.com
·
Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and
you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.