4.4 Preparing Your Environment

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

• Installing the Required Software

• Configuring Database Connections

4.4.1 Installing the Required Software

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

• Visual Studio Code, version 1.101.0 or higher
• Oracle SQL Developer Extension for VSCode, version 25.2.0 or higher
• GitHub Copilot Chat Extension for VSCode, version 0.28.5 or higher

4.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.

For information on creating an MCP-compatible connection, see Connecting to Your Database.