Skip to main content
The OCI Database MCP server provides extensive tools to interact with Oracle Cloud Infrastructure Database services, including Autonomous Database, Exadata, VM Clusters, and more.

​
Installation

uvx oracle.oci-database-mcp-server

​
Running the Server

uv run oracle.oci-database-mcp-server

​
Environment Variables

  • OCI_CONFIG_PROFILE - OCI configuration profile name (default: “DEFAULT”)

​
Available Tools

The server provides over 150 tools for comprehensive database management:

​
Autonomous Database Tools

Tool NameDescription
list_autonomous_databasesList Autonomous Databases in a compartment
get_autonomous_databaseGet details of the specified Autonomous Database
list_autonomous_database_backupsList Autonomous Database backups by database ID or compartment
get_autonomous_database_backupGet information about the specified Autonomous Database backup
list_autonomous_database_clonesList clones for a specific Autonomous Database
list_autonomous_database_dataguard_associationsList Autonomous Data Guard associations for an Autonomous Database
get_autonomous_database_dataguard_associationGet an Autonomous Data Guard-enabled database associated with the specified Autonomous Database
list_autonomous_database_character_setsList supported character sets for Autonomous Databases
list_autonomous_db_versionsList supported versions for Autonomous Databases
list_autonomous_db_preview_versionsList supported preview versions for Autonomous Databases
get_autonomous_database_walletGet the wallet details for the specified Autonomous Database
get_autonomous_database_regional_walletGet the Autonomous Database regional wallet details
list_autonomous_database_software_imagesList Autonomous Database Software Images in a compartment
get_autonomous_database_software_imageGet information about the specified Autonomous Database Software Image

​
Autonomous Container Database Tools

Tool NameDescription
list_autonomous_container_databasesList Autonomous Container Databases in a compartment
get_autonomous_container_databaseGet information about the specified Autonomous Container Database
list_autonomous_container_database_versionsList supported Autonomous Container Database versions
list_autonomous_container_database_dataguard_associationsList Autonomous Data Guard associations for an Autonomous Container Database
get_autonomous_container_database_dataguard_associationGet an Autonomous Container Database enabled with Autonomous Data Guard
get_autonomous_container_database_resource_usageGet resource usage details for the specified Autonomous Container Database

​
Pluggable Database (PDB) Tools

Tool NameDescription
list_pluggable_databasesGet a list of pluggable databases in a database or compartment
get_pluggable_databaseGet information about a specific pluggable database
create_pluggable_databaseCreate and start a pluggable database
create_pluggable_database_from_local_cloneCreate a pluggable database from a local clone
create_pluggable_database_from_remote_cloneCreate a pluggable database by cloning from a remote source CDB
create_pluggable_database_from_relocateRelocate (move) a pluggable database from a source CDB into the target CDB
update_pluggable_databaseUpdate a specific pluggable database
delete_pluggable_databaseDelete a specific pluggable database

​
Database System Tools

Tool NameDescription
list_db_systemsList DB systems in a compartment
get_db_systemGet information about the specified DB system
list_db_system_shapesGet a list of shapes available for launching a new DB system
list_db_system_compute_performancesGet a list of expected compute performance for a VM DB system
list_db_system_storage_performancesGet a list of expected storage performance for a VM DB system
list_db_system_patchesList patches applicable to a DB system
get_db_system_patchGet information about the specified patch
get_db_system_patch_history_entryGet the details of the specified patch operation on the specified DB system
get_db_system_upgrade_history_entryGet the details of the specified operating system upgrade operation for the specified DB system

​
Database & Database Home Tools

Tool NameDescription
list_databasesList databases in a specified Database Home
get_databaseGet information about the specified database
list_db_homesList Database Homes in a DB system and compartment
get_db_homeGet information about the specified Database Home
list_db_home_patchesList patches applicable to a Database Home
get_db_home_patchGet information about a specified patch package
list_db_home_patch_history_entriesList patch history for a Database Home
get_db_home_patch_history_entryGet the patch history details for the specified patchHistoryEntryId
list_db_versionsGet a list of supported Oracle Database versions
get_database_upgrade_history_entryGet the upgrade history for a specified database

​
Exadata Infrastructure Tools

Tool NameDescription
list_cloud_exadata_infrastructuresList cloud Exadata infrastructure resources in a compartment
get_cloud_exadata_infrastructureGet information about the specified cloud Exadata infrastructure resource
get_cloud_exadata_infrastructure_unallocated_resourcesGet unallocated resources information for the specified Cloud Exadata infrastructure
list_exadata_infrastructuresList Exadata Cloud@Customer infrastructure resources in a compartment
get_exadata_infrastructureGet information about the specified Exadata infrastructure
get_exadata_infrastructure_ocpusGet details of the available and consumed OCPUs for the specified Autonomous Exadata Infrastructure resource
get_exadata_infrastructure_un_allocated_resourcesGet un allocated resources information for the specified Exadata infrastructure
get_infrastructure_target_versionsGet details of the Exadata Infrastructure target system software versions

​
VM Cluster Tools

Tool NameDescription
list_vm_clustersList VM clusters in a compartment
get_vm_clusterGet information about the VM cluster
list_cloud_vm_clustersList cloud VM clusters in a compartment
get_cloud_vm_clusterGet information about the specified cloud VM cluster
list_autonomous_vm_clustersList Exadata Cloud@Customer Autonomous VM clusters in a compartment
get_autonomous_vm_clusterGet information about the specified Autonomous VM cluster for an Exadata Cloud@Customer system
list_cloud_autonomous_vm_clustersList Autonomous Exadata VM clusters in the Oracle cloud
get_cloud_autonomous_vm_clusterGet information about the specified Autonomous Exadata VM cluster in the Oracle cloud
list_vm_cluster_patchesList patches applicable to a VM cluster
list_vm_cluster_updatesList maintenance updates for a VM cluster
get_vm_cluster_updateGet information about a specified maintenance update package for a VM cluster
list_cloud_vm_cluster_updatesList maintenance updates for a specific cloud VM cluster
get_cloud_vm_cluster_updateGet information about a specified maintenance update package for a cloud VM cluster

​
Exascale Infrastructure Tools

Tool NameDescription
list_exascale_db_storage_vaultsList Exadata Database Storage Vaults in a compartment
get_exascale_db_storage_vaultGet information about the specified Exadata Database Storage Vaults
list_exadb_vm_clustersList Exadata VM clusters on Exascale Infrastructure in a compartment
get_exadb_vm_clusterGet information about the specified Exadata VM cluster on Exascale Infrastructure
list_exadb_vm_cluster_updatesList maintenance updates for an Exadata VM cluster on Exascale
get_exadb_vm_cluster_updateGet information about a specified maintenance update package for an Exadata VM cluster on Exascale

​
Backup & Data Guard Tools

Tool NameDescription
list_backupsList database backups by database ID or compartment
get_backupGet information about the specified backup
list_backup_destinationList backup destinations in a compartment
get_backup_destinationGet information about the specified backup destination
list_data_guard_associationsList Data Guard associations for a database
get_data_guard_associationGet the specified Data Guard association’s configuration information

​
External Database Tools

Tool NameDescription
list_external_container_databasesList external container databases in a compartment
get_external_container_databaseGet information about the specified external container database
list_external_non_container_databasesList external non-container databases in a compartment
get_external_non_container_databaseGet information about a specific external non-container database
list_external_pluggable_databasesList external pluggable databases in a compartment
list_external_database_connectorsList external database connectors in a compartment
get_external_database_connectorGet information about the specified external database connector

​
Maintenance & Scheduling Tools

Tool NameDescription
list_maintenance_runsGet a list of maintenance runs in a compartment
get_maintenance_runGet information about the specified maintenance run
list_maintenance_run_historyGet a list of maintenance run histories in a compartment
get_maintenance_run_historyGet information about the specified maintenance run history
list_scheduling_policiesList Scheduling Policy resources in a compartment
get_scheduling_policyGet information about the specified Scheduling Policy
list_scheduling_plansList Scheduling Plan resources in a compartment
get_scheduling_planGet information about the specified Scheduling Plan
list_scheduling_windowsList Scheduling Window resources in a compartment
get_scheduling_windowGet information about the specified Scheduling Window
list_scheduled_actionsList Scheduled Action resources in a compartment
get_scheduled_actionGet information about the specified Scheduled Action
list_execution_windowsList execution window resources in a compartment
get_execution_windowGet information about the specified execution window
list_execution_actionsList execution action resources in a compartment
get_execution_actionGet information about the specified execution action

​
Additional Tools

Tool NameDescription
list_db_nodesList database nodes in a DB system and compartment
get_db_nodeGet information about the specified database node
list_db_serversList Exadata DB servers for an Exadata infrastructure
get_db_serverGet information about the Exadata Db server
list_key_storesGet a list of key stores in the specified compartment
get_key_storeGet information about the specified key store
list_console_connectionsList console connections for a database node
get_console_connectionGet the specified database node console connection’s information
list_console_historiesList console histories for a database node
get_console_historyGet information about the specified database node console history
list_database_software_imagesList database software images in a compartment
get_database_software_imageGet information about the specified database software image
list_oneoff_patchesList one-off patches in a compartment
get_oneoff_patchGet information about the specified one-off patch

​
Usage Examples

​
Autonomous Database Management

List all Autonomous Databases in my compartment
Retrieves all Autonomous Database instances with their configurations and states. 
Get details for Autonomous Database ocid1.autonomousdatabase.oc1.phx.example
Shows comprehensive information including CPU count, storage, workload type, and connection strings. 
Get the wallet for Autonomous Database ocid1.autonomousdatabase.oc1.phx.example
Retrieves wallet credentials for connecting to the database.

​
Pluggable Database Operations

List all pluggable databases in compartment

Create a new pluggable database named "sales-pdb" in container database ocid1.database.oc1.phx.example

Clone pluggable database "dev-pdb" to create "test-pdb"

​
Database System Management

List all database systems in my compartment

Show available database system shapes for launching new systems

Get information about DB system ocid1.dbsystem.oc1.phx.example

​
Backup Management

List all backups for database ocid1.database.oc1.phx.example

Get backup details for ocid1.backup.oc1.phx.example

​
Data Guard Configuration

List all Data Guard associations for database ocid1.database.oc1.phx.example

Get Data Guard association details

​
Maintenance Operations

List upcoming maintenance runs for my databases

Show maintenance history for the past 30 days

​
Authentication

The server uses OCI CLI configuration from ~/.oci/config. Configure with: 
oci setup config

​
Required Permissions

Your OCI user or instance principal needs appropriate IAM permissions: Full Database Management: 
Allow group DatabaseAdmins to manage database-family in compartment MyCompartment
Allow group DatabaseAdmins to manage autonomous-database-family in compartment MyCompartment
Read-Only Access: 
Allow group DatabaseReaders to inspect database-family in compartment MyCompartment
Allow group DatabaseReaders to inspect autonomous-database-family in compartment MyCompartment
Security NoticeAll actions are performed with the permissions of the configured OCI CLI profile. We advise:
  • Least-privilege IAM setup
  • Secure credential management
  • Safe network practices
  • Secure logging
  • Never expose database credentials or wallets in logs

​
Common Use Cases

​
Autonomous Database Deployment

  • Provision new Autonomous Databases
  • Configure auto-scaling
  • Download connection wallets
  • Monitor database metrics

​
Database Lifecycle Management

  • Create and manage pluggable databases
  • Clone databases for testing
  • Perform backups and restores
  • Apply patches and updates

​
High Availability

  • Configure Data Guard for disaster recovery
  • Monitor Data Guard associations
  • Perform switchover operations
  • Track replication lag

​
Exadata Management

  • Monitor Exadata infrastructure
  • Manage VM clusters
  • Track resource allocation
  • Plan capacity

​
Additional Resources

Build docs developers (and LLMs) love

Get started for freeTalk to us