Grain SQL

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.pattrnlabs/grain",
  "description": "Run SQL queries and inspect database schemas through safe, visible MCP tools.",
  "title": "Grain SQL",
  "repository": {
    "url": "https://github.com/pattrnlabs/grain",
    "source": "github",
    "id": "1348511592"
  },
  "version": "0.10.30",
  "websiteUrl": "https://grain.tools",
  "icons": [
    {
      "src": "https://grain.tools/icon.png",
      "mimeType": "image/png",
      "sizes": [
        "256x256"
      ]
    }
  ],
  "packages": [
    {
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "identifier": "grain-tools",
      "version": "0.10.30",
      "runtimeHint": "npx",
      "transport": {
        "type": "stdio"
      },
      "runtimeArguments": [
        {
          "value": "-y",
          "type": "positional"
        }
      ],
      "packageArguments": [
        {
          "description": "Run Grain using stdio transport for local MCP clients.",
          "type": "named",
          "name": "--stdio"
        }
      ],
      "environmentVariables": [
        {
          "description": "JSON array of Grain connection profiles for headless use.",
          "format": "string",
          "isSecret": true,
          "name": "GRAIN_CONNECTIONS"
        },
        {
          "description": "Set to false to allow mutating SQL. Defaults to true.",
          "format": "boolean",
          "value": "true",
          "name": "GRAIN_MCP_SAFE_MODE"
        },
        {
          "description": "Maximum rows returned by query tools. Defaults to 10000.",
          "format": "number",
          "value": "10000",
          "name": "GRAIN_MAX_ROWS"
        }
      ]
    }
  ]
}