Grain MCP Server

by pattrnlabs Your server? Claim it

local only

Grain runs on your own machine — the client starts it, so there is no endpoint to ping. 191 installs a week from npm. Last commit 27 Aug 2026.

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

191

Installs / week

npm · grain-tools

Stars

0 open issues

27 Aug 2026

Last commit

0 releases in 90 days

—

License

language unknown

Nothing serious here today

Today is the operative word: we check Grain every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

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

~/Library/Application Support/Claude/claude_desktop_config.json

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

~/.codex/config.toml

[mcp_servers.grain]
command = "npx"
args = ["-y", "grain-tools"]

.cursor/mcp.json

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

.vscode/mcp.json

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

This one needs environment variables set before it will start: GRAIN_CONNECTIONS (JSON array of Grain connection profiles for headless use.), GRAIN_MCP_SAFE_MODE (Set to false to allow mutating SQL. Defaults to true.), GRAIN_MAX_ROWS (Maximum rows returned by query tools. Defaults to 10000.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Grain

same job, measured the same way

SQL Preview

by fadnavismehul

Run governed SQL queries and inspect database schemas from MCP agents.

80 installs/wk local only

Sqlite

by ofershap

SQLite MCP — query databases, inspect schemas, explain queries, export data.

139 installs/wk local only

Postgres

by ofershap

PostgreSQL MCP — query databases, inspect schemas, explain queries.

34 installs/wk local only

LINQ to DB

by linq2db

Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB.

local only

MCP Local WP

by verygoodplugins

WordPress database access via Local by Flywheel. Execute read-only MySQL queries and inspect schema.

48 installs/wk local only

Database Admin

by cybeleri

Database admin MCP: schema inspection, query optimization for PostgreSQL and MySQL

26 installs/wk local only

AdoMcp

by john0king

Database MCP server for schema discovery, comments, and SQL queries.

local only

Postgres

by waystation

Connect to your PostgreSQL database to query data and schemas.

answering

Grain — questions

Answers built from our own checks of this server.

Why is there no uptime for Grain?

Grain runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the npm package grain-tools was installed 191 times last week.

How do I connect Grain?

Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls grain-tools straight from npm; nothing to host, nothing to sign up for.

How many people use Grain?

The npm package grain-tools was installed 191 times in the last week. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is Grain open source?

We cannot say either way: 2 stars on GitHub, but we could not determine the licence, and without one the code is not open source by default.