Grain MCP Server

A fast SQL workspace for VS Code, and for the AI agents you work with. Docs · Changelog · Report a bug · Ask a question. It runs locally over stdio via the published package.

People connecting database tools to Claude, Cursor, VS Code, or another MCP client.

VERIFIED ACTIVE

LAST COMMIT 2026-09-28 · ★ 3 · #38 OF 174 MAINTAINED DATABASE · VERIFIED 2026-09-30

how we verify → /methodology

01 · Install Grain

Claude Code

claude mcp add pattrnlabs-grain -- npx -y grain-tools

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "pattrnlabs-grain": {
      "command": "npx",
      "args": [
        "-y",
        "grain-tools"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

repo age created 2026-08-27 - young repo, little track record yet

license no standard license detected - usage rights unclear; check the repo before commercial use

npm package grain-tools - unscoped; check the name against the project README before installing

registry namespace io.github.pattrnlabs is GitHub-verified and matches the repo owner

03 · What Grain can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

Latest releases

v0.10.18 · 2026-09-30

Grain v0.10.18 standalone payloads. Install:

v0.10.17 · 2026-09-28

Grain v0.10.17 standalone payloads. Install:

v0.10.16 · 2026-09-28

Grain v0.10.16 standalone payloads. Install:

04 · Who maintains Grain

Grain is maintained by pattrnlabs. It's the only MCP server we track from this author; the repo dates to Aug 2026.

05 · Facts

repository: github.com/pattrnlabs/grain
website: https://grain.tools/
category: database - ranked #38 of 174 actively-maintained database servers as of 2026-09-30.
release cadence: 10+ releases in the last 90 days (latest 2026-09-30)
registry: io.github.pattrnlabs/grain (active, first published 2026-09-14 · 12 versions)
packages: npm:grain-tools

06 · Grain FAQ

What is Grain?

A fast SQL workspace for VS Code, and for the AI agents you work with. Docs · Changelog · Report a bug · Ask a question. It runs locally over stdio via the published package.

Is Grain still maintained?

Yes - as of 2026-09-30, its last commit was 2026-09-28 and it shipped 10+ releases in the last 90 days. We re-verify nightly.

How do I install Grain?

Run `npx -y grain-tools`. You can also paste the ready-made client config above.

Does Grain run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to Grain

Alternatives to Grain

Maintained database servers if Grain isn't the fit.

Pairs well with

Servers that cover what Grain doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · Arangodb Async · Postgres MCP · Data Link · Pinion05 Supabase MCP Lite · Planet Scale