Oracle APEX Component + Claude Code

A comprehensive guide to installing the Oracle APEX Component Modifier, a potent Claude Code skill that facilitates the seamless integration of AI and Oracle SQLcl through the Model Context Protocol (MCP).

What you need first: 

Make sure you have Claude Code installed, along with Oracle SQLcl version 25.2 or later (which includes the necessary built-in MCP server and requires Java 17 or 21).

Step 1:

Copy the skill into your project Clone the repository from GitHub (https://lnkd.in/dUJqqqFt) into a temporary folder. Then, copy the apex-component-modifier skill folder into your project's .claude/skills directory and remove the temporary clone to clean up.

Step 2:

Add the SQLcl MCP server Tell Claude Code how to connect to SQLcl by running this single command: claude mcp add sqlcl -- sql -R 1 -mcp. This registers the server with the least restrictive security level, though you can use -R 4 for tighter security.

Step 3:

Create a saved database connection Open SQLcl without logging in (sql /nolog) and save your credentials securely using the conn -save [ALIAS] -savepwd -user... command. This safely stores your connection so the MCP server can access your APEX instance automatically without prompting for passwords.

Step 4:

Configure your skill settings Create a settings.json file inside the .claude folder at your project root to define your default environment. 
You will need to set three variables: SQLCL_CONNECTION (the saved alias from Step 3), APEX_APP_ID (your numeric application ID), and APEX_WORKSPACE. 

Pro tip: You can commit this file to Git so your whole team shares the same defaults.

Step 5:

Verify the installation Open Claude Code in your project directory and run a simple test: /apex-component-modifier PAGE:1 -- Describe page 1. If everything is set up perfectly, Claude will connect to the database, export Page 1, and describe its contents to you.

That is it! Once installed, you can simply type commands like /apex-component-modifier PAGE:10 -- Add item P10_STATUS as a select list. The AI will automatically handle the complex workflow of exporting the component, analyzing the changes, applying database updates, patching the files, and importing them back into APEX.

Check out the GitHub repo to get started and streamline your APEX development today!

https://github.com/avhrst/apex-component-modifier