Search / io.github.pattrnlabs/grain
Grain SQL
L0· runs locallyRun SQL queries and inspect database schemas through safe, visible MCP tools.
v0.10.34 · active · repository · website · descriptor JSON · versions
Search / io.github.pattrnlabs/grain
L0· runs locallyRun SQL queries and inspect database schemas through safe, visible MCP tools.
v0.10.34 · active · repository · website · descriptor JSON · versions
{
"mcpServers": {
"grain": {
"command": "npx",
"args": [
"-y",
"[email protected]",
"--stdio"
],
"env": {
"GRAIN_CONNECTIONS": "${GRAIN_CONNECTIONS}"
}
}
}
}claude mcp add grain -e "GRAIN_CONNECTIONS=${GRAIN_CONNECTIONS}" -- npx -y [email protected] --stdio[mcp_servers.grain]
command = "npx"
args = ["-y", "[email protected]", "--stdio"]
env = { "GRAIN_CONNECTIONS" = "${GRAIN_CONNECTIONS}" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"grain": {
"type": "local",
"command": [
"npx",
"-y",
"[email protected]",
"--stdio"
],
"enabled": true,
"environment": {
"GRAIN_CONNECTIONS": "{env:GRAIN_CONNECTIONS}"
}
}
}
}{
"mcpServers": {
"grain": {
"command": "npx",
"args": [
"-y",
"[email protected]",
"--stdio"
],
"env": {
"GRAIN_CONNECTIONS": "${GRAIN_CONNECTIONS}"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=grain&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsImdyYWluLXRvb2xzQDAuMTAuMzQiLCItLXN0ZGlvIl0sImVudiI6eyJHUkFJTl9DT05ORUNUSU9OUyI6IiR7R1JBSU5fQ09OTkVDVElPTlN9In19"
}{
"servers": {
"grain": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]",
"--stdio"
],
"env": {
"GRAIN_CONNECTIONS": "${GRAIN_CONNECTIONS}"
}
}
}
}{
"mcpServers": {
"grain": {
"command": "npx",
"args": [
"-y",
"[email protected]",
"--stdio"
],
"env": {
"GRAIN_CONNECTIONS": "${GRAIN_CONNECTIONS}"
}
}
}
}extensions:
"grain":
enabled: true
name: "grain"
type: stdio
cmd: "npx"
args:
- "-y"
- "[email protected]"
- "--stdio"
envs:
"GRAIN_CONNECTIONS": "${GRAIN_CONNECTIONS}"
timeout: 300
Placeholders to fill from your own secret store: ${GRAIN_CONNECTIONS}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)stability.changes, stability.rug_pulltool list unknownNo tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-4d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] npmthis version is not known to the dependency resolver
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
grain-tools | npm | 0.10.34 | npx | GRAIN_CONNECTIONS |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.pattrnlabs/grain",
"icons": [
{
"src": "https://grain.tools/icon.png",
"sizes": [
"256x256"
],
"mimeType": "image/png"
}
],
"title": "Grain SQL",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.10.34",
"packages": [
{
"version": "0.10.34",
"transport": {
"type": "stdio"
},
"identifier": "grain-tools",
"runtimeHint": "npx",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"packageArguments": [
{
"name": "--stdio",
"type": "named",
"description": "Run Grain using stdio transport for local MCP clients."
}
],
"runtimeArguments": [
{
"type": "positional",
"value": "-y"
}
],
"environmentVariables": [
{
"name": "GRAIN_CONNECTIONS",
"format": "string",
"isSecret": true,
"description": "JSON array of Grain connection profiles for headless use."
},
{
"name": "GRAIN_MCP_SAFE_MODE",
"value": "true",
"format": "boolean",
"description": "Set to false to allow mutating SQL. Defaults to true."
},
{
"name": "GRAIN_MAX_ROWS",
"value": "10000",
"format": "number",
"description": "Maximum rows returned by query tools. Defaults to 10000."
}
]
}
],
"repository": {
"id": "1348511592",
"url": "https://github.com/pattrnlabs/grain",
"source": "github"
},
"websiteUrl": "https://grain.tools",
"description": "Run SQL queries and inspect database schemas through safe, visible MCP tools."
}