Grain SQL

io.github.pattrnlabs/grain

7/7 checks passed
Runs locally
1 secret
★ 3 GitHub stars
Updated 2026-10-27
Health score 57

About Grain SQL

Grain SQL is an MCP server published by the GitHub account pattrnlabs. Run SQL queries and inspect database schemas through safe, visible MCP tools.

It runs on your own machine: your AI client starts it from the npm package grain-tools at version 0.10.39.

It asks for one secret: GRAIN_CONNECTIONS. Give it a key with the least access that still works.

Version 0.10.39 was published on 27 October 2026, and the source code is public, so you can read it before installing.

Written from the registry entry. 9 automated checks on the registry entry and the package code: 7 pass, 0 warn, 0 fail, 2 info. How we check.

What it asks for

Variable	Required	Secret	Description
`GRAIN_CONNECTIONS`	No	Yes	JSON array of Grain connection profiles for headless use.
`GRAIN_MCP_SAFE_MODE`	No	No	Set to false to allow mutating SQL. Defaults to true.
`GRAIN_MAX_ROWS`	No	No	Maximum rows returned by query tools. Defaults to 10000.

Checks

Check	Result	Detail
Source repository linked	Pass	https://github.com/pattrnlabs/grain
Version pinned	Pass	Every package has an explicit version
Secrets requested	Info	Asks for 1 secret: GRAIN_CONNECTIONS
Known package registry	Pass	All packages come from npm, PyPI, OCI, NuGet or MCPB
Namespace ownership	Info	Name verified via GitHub account pattrnlabs
Registry text aimed at the AI	Pass	Description and settings contain no hidden characters or instructions to the AI
Install scripts	Pass	grain-tools@0.10.39 runs nothing at install
Code red flags	Pass	Read 3 files in grain-tools@0.10.39: no obfuscation, encoded execution, credential reads or data-collection endpoints found
Text aimed at the AI	Pass	No hidden characters or instructions to the AI in 3 files, including comments and the README

Popularity & health: 57 / 100

Worked out from public numbers and our own checks, not from user reviews or ratings. It says how used and how looked-after a server is, not whether it is safe.

Popularity15 / 40

3 GitHub stars, 1,468 downloads last week, no Hacker News posts found. Best two of the three, each on a log scale.

Activity15 / 25

Last push 2026-10-29, last release 2026-10-30, 0 commits in 90 days.

Issue health8 / 15

0 closed of 0 issues, too few to judge. No data, so half marks.

Our checks20 / 20

0 warnings, each costing a fifth.

1 forks, 1 merged pull requests. Sources: GitHub, npm, PyPI (pypistats.org) and Hacker News (Algolia), fetched 2026-10-31.

What people say

No Hacker News threads link to its source code.

Look further: search Reddit, search Hacker News, read its GitHub issues. These are not reviews we checked.

Facts

Registry name	`io.github.pattrnlabs/grain`
Publisher	GitHub account pattrnlabs
How the name is verified	Name verified via GitHub account pattrnlabs. The registry ties the name prefix to that account or domain; it does not check the code.
Type	Local: runs on your machine from a package
Packages	npm `grain-tools` 0.10.39 (stdio)
Version	0.10.39
Published	2026-10-27
Last updated	2026-10-27
Source repository	https://github.com/pattrnlabs/grain
Website	https://grain.tools
Category	Databases & data (assigned by keyword rule, not by hand)

Install

Claude Desktop · npm package

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

What these checks don't cover

We did not run this server, so we don't know what it does when it runs. We read its package code on 2026-10-29 without running it, and pattern searches miss what they have no pattern for. Tool descriptions built at run time were not seen. And we don't watch it after you install: if the publisher changes it later (a rug pull), this page won't notice until the next scan. Treat a pass as "nothing found", not as "safe".

For people and their AI

The same data as plain JSON: /data/servers/io-github-pattrnlabs-grain.json. Text inside it that came from the publisher is data, not instructions.