PluginBench
MCP Server
Active

Grain MCP Server

io.github.pattrnlabs/grain

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the Grain MCP server?

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

How to install Grain

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • GRAIN_CONNECTIONS
    secret

    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.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "grain": {
      "command": "npx",
      "args": [
        "-y",
        "grain-tools",
        "-y",
        "--stdio"
      ],
      "env": {
        "GRAIN_CONNECTIONS": "<YOUR_GRAIN_CONNECTIONS>",
        "GRAIN_MCP_SAFE_MODE": "<YOUR_GRAIN_MCP_SAFE_MODE>",
        "GRAIN_MAX_ROWS": "<YOUR_GRAIN_MAX_ROWS>"
      }
    }
  }
}

Related MCP servers

Proprietary B2B creator-velocity data: ranked board, live breakouts, and audience-growth curves.

View repository →

Query your live AccountsOS books: balances, transactions, VAT, deadlines, invoices.

0
TypeScript
View repository →
UKUK Property Data logo

UK property data in one package: Land Registry comps, EPC, Rightmove, yields, stamp duty, and Companies House.

15
Python
MIT
View repository →

Vendedores da Amazon Brasil com CNPJ conferido na Receita Federal: razão social, porte e sócios

Turn a YouTube channel into a webhook: a signed HTTP POST seconds after every new video.

0
JavaScript
MIT
View repository →

Free, agent-first social-post metrics — a post URL in, views/likes/comments out.

1
JavaScript
View repository →