Oracle SQLcl
Oracle SQLcl is a powerful, flexible, and free command-line interface designed for modern Oracle AI Database professionals.
SQLcl's integrated MCP Server bridges Oracle AI Databases with AI-driven solutions by allowing Language Learning Models (LLMs) to interactively execute queries and process results. This positions SQLcl as the go-to interface for both traditional database development and cutting-edge AI/ML-driven applications.
Oracle’s MCP Server revolutionizes AI-driven database interactions. It works with any supported Oracle Database—from 19c to 23ai—and can be used on-premises, in hyperscalers such as Azure, AWS, Google and OCI—and even on your laptop. All Oracle Database users should give it a try to chat with their database, generate reports and perform operations such as Data Load and Data Transform.
HyperFRAME Research
Introducing SQL Developer Copilot Integration in Microsoft VS Code and MCP Support for Oracle Database
This workshop will dive you into Oracle Database Application CI/CD workflows using SQLcl Projects
Get Started
Key Features
MCP Server
SQLcl is now available as an MCP Server, offering several tools to your AI code assistants and their LLMs; Tools enable the LLM to access and use your defined connections to work directly with your Oracle Database to run the queries and scripts to answer your questions and complete your tasks; new tools will be provided on a regular basis
Modern interface
SQLcl's command line natively supports inline editing (as well as vi and emacs), tab completion for your SQL keywords and database object names, SQL history for recalling your previous command and scripts, syntax highlighting, and a status bar to remind you what connection you are using, who are logged in as, and if you have any pending transactions
Projects
CI/CD and change management for the Oracle Database has never been easier with our built-in project support. Track and manage your local database development work with Git, easily generate DIFFs, plus create and deploy your artifacts to make your application installs and upgrades completely automated
Database Utilities
Your favorite Oracle Database features made simple with SQLcl commands, including support for AWR, Data Pump, Data Guard, and Transactional Event Queues
Oracle Cloud Infrastructure Support
Simply set your OCI Profile to easily use your OCI Database Tools Service connection definitions to connect to your Oracle Cloud Database Services or read and write from the Object Store
Do More with Less
Common tasks like generating DDL, loading tables from CSV or Excel, backgrounding long running queries and tasks, or saving your favorite queries with SQLcl is as easy as using our DDL, LOAD, BG, and ALIAS commands