oci-db-management-mcp-server

Run SQL against OCI managed databases using OCI DB Management Jobs — no direct DB connectivity needed, DBM handles authentication. Use this skill whenever the user wants to execute SQL on a managed database, schedule data operations, check job history, monitor running jobs, run SELECT queries and retrieve results, or troubleshoot failed jobs. Triggers on: "run SQL on AIDB", "run SQL on DBMDEMO", "create a job to insert/update/delete", "execute SQL against", "schedule SQL", "run a SELECT and show me results", "query the database", "did any jobs fail", "show job history", "what jobs ran today", "monitor job run".

Generate a controlled, time-bounded database workload on an Oracle Autonomous Database via OCI DB Management Jobs. Produces real enq:TX row lock contention and parse pressure (cursor:pin S / hard parses) so the oci-dbm-diagnose skill can analyze the resulting wait profile against live AWR data. Use this skill when a user asks to "generate workload", "create test load", "simulate lock contention", "produce parse pressure", or "set up a diagnostic scenario" on an ADB. Always runs via DBM SQL Jobs — no direct database credentials required. Requires the target ADB to be onboarded via oci-dbm-commission.

Interactive commissioning skill for onboarding an Oracle Autonomous Database (ADB) into OCI Database Management (DBM) with full feature enablement — including private endpoint, vault secret, IAM policy, and security list setup. Trigger this skill whenever a user wants to: - Enable Database Management on a new or existing ADB - Provision a fresh ADB and bring it under DBM management - Understand what's needed before enabling DBM on ADB - Troubleshoot a DBM enablement that says "full mode required" or Jobs not working This skill grills the user upfront — surfacing every prerequisite and known gotcha before writing or running a single line of code. It prevents the 6-round error cycle that happens when people attempt DBM enablement without validating network, IAM, and connection details first.

Enables OCI Database Management on an Autonomous Database using the correct feature API with Private Endpoint connector and vault credentials. Handles the false-positive state from the old API. Trigger when a user says "enable DBM on my ADB", "enable database management", "DBM jobs not working", or when oci-dbm-commission directs here as the final step.

Validates and configures network prerequisites for OCI DBM enablement on ADB. Checks for a DBM Private Endpoint in the VCN and verifies/adds the ingress security list rule for TCP port 1522 from the subnet CIDR. Trigger when a user says "check my network for DBM", "set up network rules for DBM", or when oci-dbm-commission directs here after the grill.

Provisions a new Autonomous Database (ADB) with private endpoint and TLS-only access. Skipped automatically by oci-dbm-commission if the ADB already exists. Trigger when a user says "create an ADB for DBM", "provision a new autonomous database", or when oci-dbm-commission directs here for fresh provisioning.

Start the OCI Database Management MCP server locally so Claude can call DBM tools. This skill wires the MCP server into Claude's tool context, making all 24 DBM tools available. Use this skill when a user says "start the database management server", "connect to my database tools", "enable database management tools", or after oci-setup completes successfully. This skill must run before any oci-dbm-* operational skills (diagnose, performance, jobs, sql-tuning). It is the gateway — nothing else works without it.

Creates or validates a vault secret for the ADB ADMIN password and ensures the IAM policy has both required statements for DBM secret access. Trigger when a user says "set up vault for DBM", "create the DBM secret", or when oci-dbm-commission directs here.

Validate OCI credentials, SDK installation, and IAM access for working with Oracle databases on OCI. Lists compartments and managed databases to confirm connectivity. Use this skill whenever a user is getting started with OCI, asks how to connect Claude to their Oracle database, has credential problems, wants to verify their OCI config, or says anything like "I want to use Claude to manage my Oracle database — how do I get started?". This is the entry point for all OCI database management workflows — always run this first.