3.4 Preparing Your Environment

Learn about setting up your environment to use the SQLcl MCP Server.

3.4.1 Installing the Required Software

To use the SQLcl MCP Server, you must install the following software on your system.

  • Oracle SQLcl, version 25.2.0 or higher
  • Java Runtime Environment (JRE), version 17 or higher

3.4.2 Configuring Database Connections

The SQLcl MCP Server relies on the preconfigured connections saved in the connection store, which is in your ~/.dbtools directory. You can manage these connections using the connect and connmgr commands.

Note:

  • For a connection to be accessible to an MCP client, you must save its password. When you create a new connection, use the -savepwd flag to store credentials securely.
  • You can also define and manage connections using the Oracle SQL Developer Extension for VS Code.

To create an MCP-compatible saved connection, execute a command similar to the following example:

SQL> conn -save cline_mcp -savepwd User123/pass123@//localhost:1234/Database1
Name: cline_mcp
Connect String: //localhost:1234/Database1
User: User123
Password: ******
Connected.
SQL>