Oracle Sqlcl Mcp Server
The Oracle SQLcl Model Context Protocol (MCP) Server transforms how you interact with the Oracle Database by enabling seamless communication with Artificial Intelligence (AI) applications.
It enables you to perform operations, create reports, and run queries on Oracle Database using natural language through AI-powered interactions. Discover the capabilities of the Oracle SQLcl MCP Server, and learn how to use it with popular MCP clients.
Content
<meta name="dcterms.dateCopyrighted" content="2019, 2025">
<meta name="dcterms.category" content="database">
<meta name="dcterms.identifier" content="G36489-01">
<meta name="dcterms.product" content="en/database/oracle/sql-developer-command-line/25.2">
<link rel="prev" href="using-oci-command-oracle-cloud-infrastructure-rest-apis.html" title="Previous" type="text/html">
<link rel="next" href="sqlcl-mcp-server.html" title="Next" type="text/html">
<script>
document.write('<style type="text/css">');
document.write('body > .noscript, body > .noscript ~ * { visibility: hidden; }');
document.write('</style>');
</script>
<script data-main="/sp_common/book-template/ohc-book-template/js/book-config" src="/sp_common/book-template/requirejs/require.js"></script>
<script>
if (window.require === undefined) {
document.write('<script data-main="sp_common/book-template/ohc-book-template/js/book-config" src="sp_common/book-template/requirejs/require.js"><\/script>');
document.write('<link href="sp_common/book-template/ohc-book-template/css/book.css" rel="stylesheet"/>');
}
</script>
<script type="application/json" id="ssot-metadata">{"primary":{"category":{"short_name":"database","element_name":"Database","display_in_url":true},"suite":{"short_name":"oracle","element_name":"Oracle","display_in_url":true},"product_group":{"short_name":"not-applicable","element_name":"Not applicable","display_in_url":false},"product":{"short_name":"sql-developer-command-line","element_name":"SQL Developer Command Line","display_in_url":true},"release":{"short_name":"25.2","element_name":"Release 25.2","display_in_url":true}}}</script>
<meta name="dcterms.title" content="Oracle SQLcl User's Guide">
<meta name="dcterms.isVersionOf" content="SQCUG">
<meta name="dcterms.release" content="Release 25.2">
<script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head>
Previous
Next
JavaScript must be enabled to correctly display this content
</div>
<article class>
<a id="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8" name="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8"></a>
<h2 id="SQCUG-GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8" class="sect2"><span class="enumeration_chapter">3 </span>Using the Oracle SQLcl MCP
Server
</h2>
<div class="ind">
<div>
<p>The Oracle SQLcl Model Context Protocol (MCP) Server transforms how you
interact with the Oracle Database by enabling seamless communication with Artificial
Intelligence (AI) applications.</p>
<div class="section">
<p>It enables you to perform operations, create reports, and run queries on
Oracle Database using natural language through AI-powered interactions. Discover the
capabilities of the Oracle SQLcl MCP Server, and learn how to use it with popular
MCP clients.</p>
<div class="p">
<div class="infobox-caution" id="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8__GUID-BA771214-310E-4D6E-BCC0-8EF3C58C9B06">
<p class="notep1">Caution:</p>
<p>When you grant a large language model (LLM) access to your database, it
introduces significant security risks. Because LLMs use the data you input
to generate responses, you might inadvertently expose unintended tables or
sensitive details.</p>
<div class="p">To mitigate these risks, implement the following safeguards:
<ul style="list-style-type: disc;" id="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8__UL_YPD_KVT_5FC">
<li><span class="bold">Assign minimum permissions:</span> Configure the
database user account used by the LLM with the absolute minimum
permissions required for its tasks. This approach limits what the
LLM can access.
</li>
<li><span class="bold">Avoid production database access:</span> Do not grant
LLMs direct access to production databases. Instead, you should use
a sanitized, read-only replica or a dedicated data subset.
</li>
<li><span class="bold">Audit LLM activity:</span> Regularly audit the queries
executed by the LLM. This helps you detect anomalies or the attempts
to access restricted data. To support your auditing efforts, the
SQLcl MCP Server provides the following built-in monitoring
capabilities:
<ul style="list-style-type: disc;" id="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8__UL_ZBT_NVT_5FC">
<li><span class="bold">Session tracking:</span> It populates
<code class="codeph">V$SESSION.MODULE</code> with the MCP client in
use, and <code class="codeph">V$SESSION.ACTION</code> with the LLM’s
name.
</li>
<li><span class="bold">Activity logging:</span> It creates a table
named <code class="codeph">DBTOOLS$MCP_LOG</code> that records every
interaction and SQL execution.
</li>
<li><span class="bold">Query identification:</span> All LLM-generated
queries through the SQLcl MCP Server’s tools include the
following comment for easy identification in the logs:
<code class="codeph">/* LLM in use ... */</code>.
</li>
</ul>To learn more about monitoring, see <a href="monitoring-sqlcl-mcp-server.html#GUID-D5B43CF2-1C37-4066-869A-264F83F0E11D" title="Learn how you can monitor the health, status, and activity of your SQLcl MCP Server.">Monitoring the SQLcl MCP Server</a>.
</li>
</ul>
</div>
</div>
</div>
</div>
<div class="section">
<p class="subhead1" id="GUID-94C7C807-E667-4FCB-9E0D-20A1A1FE09D8__GUID-435404AD-0629-427C-B1BF-EBB41FCFD3F9">Topics:</p>
<ul style="list-style-type: disc;">
<li>
<p><a href="sqlcl-mcp-server.html#GUID-B2B28238-4787-4D93-B313-6574B0EBC41F" title="The Model Context Protocol (MCP) is an open standard that defines a consistent way for applications to provide contextual information to AI models.">About the SQLcl MCP Server</a></p>
</li>
<li>
<p><a href="sqlcl-mcp-server-tools.html#GUID-C36D661C-922C-406A-97F7-9D0D5D4CDCA6" title="The SQLcl MCP Server exposes a set of tools that enhance the way AI applications interact with Oracle databases. By abstracting the SQLcl commands used for various database operations, these tools empower AI models to autonomously manage databases. This allows you to focus on strategic objectives instead of manual command-line interactions.">About the SQLcl MCP Server Tools</a></p>
</li>
<li>
<p><a href="how-sqlcl-mcp-server-works.html#GUID-FC97B97C-05D5-4FF6-830F-5E829FEFA5C9" title="The SQLcl MCP Server translates conversational AI requests into powerful, context-aware database operations, ensuring the full capabilities, performance, and integrity of the Oracle environments remain intact.">How the SQLcl MCP Server Works</a></p>
</li>
<li>
<p><a href="preparing-your-environment.html#GUID-488E1167-D76C-4AFA-B74F-C0B154DF5B0F" title="Learn about setting up your environment to use the SQLcl MCP Server.">Preparing Your Environment</a></p>
</li>
<li>
<p><a href="starting-and-managing-sqlcl-mcp-server.html#GUID-5F916B5D-8670-42BD-9F8B-D3D2424EC47E" title="The SQLcl MCP Server is designed to be launched and managed automatically through an MCP client application.">Starting and Managing the SQLcl MCP Server</a></p>
</li>
<li>
<p><a href="example-use-cases-and-prompts.html#GUID-3C6F5BBB-0F46-4CF7-8CAD-6EAD599153E7" title="Here are a few examples of natural language requests you can use to perform various database operations through an MCP client connected to the SQLcl MCP Server.">Example Use Cases and Prompts</a></p>
</li>
<li>
<p><a href="monitoring-sqlcl-mcp-server.html#GUID-D5B43CF2-1C37-4066-869A-264F83F0E11D" title="Learn how you can monitor the health, status, and activity of your SQLcl MCP Server.">Monitoring the SQLcl MCP Server</a></p>
</li>
</ul>
</div>
</div>
</div>
</article>
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Playwright McpPlaywright MCP server
Serper MCP ServerA Serper MCP Server
DeepChatYour AI Partner on Desktop
WindsurfThe new purpose-built IDE to harness magic
Amap Maps高德地图官方 MCP Server
Tavily Mcp
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
CursorThe AI Code Editor
ChatWiseThe second fastest AI chatbot™
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.