Modern AI development isn’t just about what your agent is trained on—it’s about what skills you give it. Skills dramatically expand your agent’s abilities without forcing it to waste tokens researching or relying solely on its training data. By adding skills, your agent can perform real actions, automate tasks, and interact with your Oracle Database environment instantly and efficiently. In my last blog-https://samappsdba.blogspot.com/2026/01/oracle-sqlcl-mcp-oracle-19c-nlp.html, i have described on how to leverage MCP protocol using sqlcli & Claude client and bring AI to the 19c Database.
This guide walks through how to set up Model Context Protocol (MCP) in Visual Studio Code, connect SQLcl, and import powerful Oracle Database skills from the GitHub repository at https://github.com/krisrice/oracle-db-skills. The result is a fully AI‑enhanced Oracle development environment inside VS Code.
What You Need Before You Start
Latest Visual Studio Code
Latest SQL Developer Extension
SQLcl installed
Oracle Database 26AI or compatible version
Git installed and added to PATH
A workspace folder for skill imports
Install VS Code and SQL Developer Extension
Install VS Code, then add the SQL Developer extension and select Trust Workspace & Install
Once it is installed we will see the icon in the bottom as
Install Oracle Database 26AI
If you don’t have a database yet, install Oracle Database 26AI Free on a VM or local machine.
C:\Users\SamratSinha>cd C:\AI\sqlcli\sqlcl\sqlcl\bin
C:\AI\sqlcli\sqlcl\sqlcl\bin>.\sql /nolog
SQLcl: Release 25.4 Production on Sun Mar 22 15:44:36 2026
Copyright (c) 1982, 2026, Oracle. All rights reserved.
SQL> conn -save oracle19c_mcptest -savepwd
system/******@IP of DB:1521/ FREEPDB1
Name: oracle19c_mcptest
Connect String: 132.145.169.175:1521/ FREEPDB1
User: system
Password: ******
Connected.
SQL> CONNMGR show oracle19c_mcptest
Name: oracle19c_mcptest
Connect String: 132.145.169.175:1521/ FREEPDB1
User: system
Password: ******
SQL> CONNMGR test oracle19c_mcptest
Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop,
Learn, and Run for Free
Connection Test Successful
Restart VS Code so the SQL Developer extension can detect the MCP server
Enable Copilot MCP Integration in VS Code
In VS Code:
Open Command Palette
Search MCP: List Servers
Start the MCP server
Approve the session when prompted
Choose MCP:List Servers and then start MCP
Connect to the desired LLM
connect to the target DB
Once skills are imported, your agent can reuse them repeatedly without needing to re‑query the internet or regenerate complex logic. This means:
Far fewer tokens consumed
Faster responses
More accurate actions
A smarter, more capable agent over time
By giving your agent high‑quality skills—like the Oracle Database skills from Kris Rice’s GitHub, you’re effectively upgrading its intelligence and reducing operational cost at the same time.
No comments:
Post a Comment