Setting up SQLcl in Antigravity

Recently I posted about working on this, so I want to share some things I found in the way.

First of All, when you install SQL Developer extension in VS Code, it brings SQLcl on it, and automatically registers it as a tool for GitHub Copilot, so not much to do, other than enabling the tool using the settings, if it's not already enabled.

After Installing the extension in Antigravity, I noticed that registration step was missing, so I tried finding the way to enable it from SQL Developer and didn't find a simple way to do it.

luckily, SCLcl is available to be downloaded and installed locally, so I took that approach and navigated to : SQLcl Downloads

This doesn't require installation, you just need to extract the zip content. I'm going to place it under "C:\\" (as I'm using Windows), So my after extracting I'll have the directory "C:\\sqlcl"

VERY IMPORTANT Java needs to be installed, so if you don't have it, you can download it from Java Downloads | Oracle. If you move with the next steps and forget to do this, every time you open Antigravity, a tab in your browser will be open taking you to that page.

Now, after SQLcl and Java are in place, let's go to Antigravity, and look for the thee dots on the right to open agent's options and click on MCP Servers

Then, click on "Manage MCP Servers"

And then "View raw config"

mcp_config.json file will be opened, there is a blue info icon

Clicking that icon will show examples of how to use the file.

Following that, we can close the example window and paste the text bellow, changing the path to the location of your sqlcl directory:

{
  "mcpServers": {
    "sqlcl": {
      "command": "C:\\sqlcl\\bin\\sql.exe",
      "args": [
        "-mcp"
      ]
    }
  }
}

Should looks like this:

Now restart Antigravity, and if you go back to "Manage MCP Servers", you should see something like this:

Now you can give a simple instruction to your agent, I'm going to try asking to check how many rows are in a table

So it found 2 rows and shows the query it used to find that, and you can see the tools it used.

Hope this is useful, comments and feedback are always welcome :)