Skip to content
Gemini CLI

schemacrawler ai for Gemini CLI

io.github.schemacrawler/schemacrawler-ai

Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast

client:Gemini CLI transport:stdio runtime:oci

Install schemacrawler ai in Gemini CLI

~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.15.4-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs

schemacrawler ai in other clients