2025甲骨文全球AI大会：The SQLcl MCP Server and Oracle Database

Jeff

Smith/Chris

HoinaDistinguishedProductManager/SeniorProductManager

DatabaseToolsOctober2025TheSQLclMCPServerandOracleDatabaseGettoknowSQLclMCP

ServerAgent1Introduction2Environment

Set-up3

Using

the

SQLcl

MCP

Server4

Build

sample

database

objects5Build

an

HTML

dashboard6

Build

a

starter

React

app7

Learn

more2Copyright©2025,Oracle

and/or

its

affiliates

|Confidential:Internal/Restricted/Highly

RestrictedIntroduction3Breaking

itdown:Agent->

LLM->

MCP

->

DatabaseCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:Askyourquestion,stateyourtaskCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:LLMseesatoolthatmightbeofassistance,seeksapprovalCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:MCPtoolisinvoked,responseisreadbyLLMCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:conversationevolves,moretoolsarerequestedCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:LLMgeneratesSQLtogetanswer,asksforapprovalCopyright©2025,Oracle

and/or

its

affiliatesWorkflow:LLMreceivesoutputandgeneratesanswerCopyright©2025,Oracle

and/or

its

affiliatesModelContextProtocol(MCP)Overview•

Launched

Nov2024by

Anthropic•

Marketedas“USB-CforAIapplications”•

Singular

interface

to

standard

interactions

withdatabase,files,businessapps,developer

tools,

…•

Simplification

hides

the

complexity

of

theServerimplementation.AnIntroduction>

https://modelcontextprotocol.io/introduction13Copyright©2025,Oracle

and/or

its

affiliates>MCPServerOracle

DBMCPServerMCPServerMCPServer<

><

>ModelContextProtocolMCP

Server

<

>>><<ModelContextProtocolServer•

Model

Context

Protocol

Servers

provide•

Resources–Staticitemssuchasdocuments,images,files•

Tools–Essentially

a

function

call

with

input/output

arguments•

Prompts–Prompts

to

give

to

the

LLM

for

use•Example

MCP

Servers:https://github.com/punkpeye/awesome-mcp-servers

Tool14Copyright©2025,Oracle

and/or

its

affiliatesPromptResourceModelContextProtocol–SomeUseCases•

Reporting:EndUser(non-developer)•

Named

Report

data

where

reports

are

refined

SQL•

AdhocdataaccessviaNL2SQL•

DatabaseApplication:

End

User(

non-developer)

:•

ChataccesstoApplicationAPIs•

Forexample:•

Project/Ticketing:what

projects

are

not

going

to

make

our

deadline?•

HRSystem:what’sJeff’sboss’boss’phonenumber?•

Developer/DBA/Operations:•

Any

task

could

be

performed

with

chat

interaction:•

Schema/SQL,AWR,DataLoad,

Datatransform,

DBStatus,fleetstatus,topsql,blockedsession,vectorquery,vectorizedata,

…15Copyright©2025,Oracle

and/or

its

affiliatesMorefunwithHumanResources(HR)SQLclrunningasanMCPServerAvailableinversion25.2•

ProvidestoanyMCPClient:o

Tool:list-connectionso

Tool:connecto

Tool:run-sql•

New

tools

to

be

released

monthly*o

Dataloadingo

Performanceo

Securityo

DesignReview16Copyright©2025,Oracle

and/or

its

affiliatesClineExtensioninCursor–askingaboutmyschema.[Date]EnvironmentSetup1718UsingtheSQLclMCPServer192021Buildsampledatabaseobjects22ReviewingtheplanBrandnewschema,noobjectsStarter

prompt

to

generate

objects

and

dataReviewtheplaninPlanmode,transitiontoActmode23Stepping

throughTablecreation>datainsertCheckingdatawithFetchFirst5rowsAdding

views,recommending

two

additional24BuildanHTMLdashboard25ReviewingtheplanStarting

in

Plan

modeReviewingtheplan,transitioningtoActmodeReviewingtheHTMLfile;assistwithFilemarkers

asneeded26AmendingtheHTMLAmend

and

open

the

HTML

dashboardReviewing

the

three

chartsAbove,andbelowthefold27BuildastarterReactapp28Reviewing

the

promptApprovinginPlanmodeTransitioningtoActmodeCreating

the

project

folder

and

app

artifacts29SampleReactappAboveandbelowthefold30Learn

More31OracleSQLclDownloadOracleMCPServer

Blog

PostOracleSQLclMCPDocumentationOracleSQLDeveloperforVSCodeCo