Oracle SQLcl

Oracle SQLcl is a powerful, flexible, and free command-line interface designed for modern Oracle Database professionals.

SQLcl's integrated MCP Server bridges Oracle 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.

Download

Learn More

MCP Server for Oracle Database

Learn more about MCP Server for Oracle Database

Read about MCP

SQLcl MCP Support for Oracle Database

Introducing SQL Developer Copilot Integration in Microsoft VSCode & MCP Support for Oracle Database

Video

Hands-On Lab: SQLcl Projects

This workshop will dive you into Oracle Database Application CI/CD workflows using SQLcl Projects

Hands-On Lab

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

SQLcl Documentation
Related Products
Resources
- Customer Success Story: Pretius
- SQLcl via Oracle Container Repository

Oracle SQLcl

Get Started

Interact with SQLcl Experts and Users