Skip to content
Gemini CLI

Grain for Gemini CLI

io.github.pattrnlabs/grain

Run SQL queries and inspect database schemas through safe, visible MCP tools.

client:Gemini CLI transport:stdio runtime:npm

Install Grain 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": {
    "grain": {
      "command": "npx",
      "args": [
        "-y",
        "grain-tools"
      ],
      "env": {
        "GRAIN_CONNECTIONS": "<GRAIN_CONNECTIONS>",
        "GRAIN_MCP_SAFE_MODE": "<GRAIN_MCP_SAFE_MODE>",
        "GRAIN_MAX_ROWS": "<GRAIN_MAX_ROWS>"
      }
    }
  }
}

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

Grain in other clients