agentsclimarketplace

Setup wrenai mcp

Skill Canner/WrenAI-mcp/skills/setup-wrenai-mcp

Set up WrenAI MCP server connection. Detects Node.js, configures .mcp.json with stdio proxy, and verifies the connection. Triggers on 'connect to wrenai', 'setup wrenai mcp', 'connect mcp', or 'wrenai mcp setup'.From its SKILL.md

Install
npx -y skills add Canner/WrenAI-mcp --skill setup-wrenai-mcp

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 7 stars7 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

4.7 KB, as published. Nobody here has run it

<!-- AUTO-GENERATED from SKILL.md.tmpl for claude — do not edit directly -->

Setup WrenAI MCP Connection

Configures the current project to connect to a WrenAI MCP server so the AI can query data, generate SQL, run queries, build charts, and provide business insights.

When to Use

  • User wants to connect to a WrenAI instance
  • User says "connect to wrenai", "setup mcp", "connect mcp"
  • User needs to query their data through WrenAI

Step 1 — Gather connection info

Ask the user for:

  1. WrenAI URL — e.g. http://localhost:3000 or https://app.getwren.ai
  2. Project ID — the numeric project ID (visible in the WrenAI URL)
  3. Authentication — one of:
    • API key (sk-...) — recommended for most setups
    • None — local dev with MCP_SKIP_AUTH=true on the server

Construct the MCP endpoint: {url}/api/mcp/{project_id}


Step 2 — Check Node.js >= 20

The stdio proxy requires Node.js >= 20 (for native https module ESM support). Find a suitable node binary:

node --version

If not found or version < 20, search common locations:

  • ~/.nvm/versions/node/v2*/bin/node
  • ~/.volta/bin/node
  • /usr/local/bin/node
  • /opt/homebrew/bin/node

If no Node.js >= 20 found, offer to install:

You need Node.js >= 20 for the MCP proxy.

Record the full absolute path to node (e.g. /Users/me/.nvm/versions/node/v20.20.1/bin/node).


Step 3 — Write MCP config

Write the following JSON to .mcp.json in the project root.

If the file already exists with other servers, merge — don't overwrite.

Note: Claude Code's native HTTP transport auto-discovers OAuth and gets stuck if the server advertises /.well-known/oauth-authorization-server. Use the stdio proxy (mcp-proxy.mjs) to bypass this.

Step 3a — Locate the proxy

The mcp-proxy.mjs file ships with this plugin. Find its absolute path:

# If installed as a plugin, it's in the plugin directory:
ls "$(pwd)/mcp-proxy.mjs" 2>/dev/null || echo "Not found in current dir"

Step 3b — Write .mcp.json

Without auth (local dev):

{
  "mcpServers": {
    "wrenai": {
      "type": "stdio",
      "command": "<node_path>",
      "args": [
        "<absolute_path_to>/mcp-proxy.mjs",
        "<endpoint_url>"
      ]
    }
  }
}

With API key:

{
  "mcpServers": {
    "wrenai": {
      "type": "stdio",
      "command": "<node_path>",
      "args": [
        "<absolute_path_to>/mcp-proxy.mjs",
        "<endpoint_url>",
        "<api_key>"
      ]
    }
  }
}

For example:

{
  "mcpServers": {
    "wrenai": {
      "type": "stdio",
      "command": "/Users/me/.nvm/versions/node/v20.20.1/bin/node",
      "args": [
        "/Users/me/wrenai-mcp/mcp-proxy.mjs",
        "https://app.getwren.ai/api/mcp/123",
        "sk-abc123"
      ]
    }
  }
}

IMPORTANT: Do NOT use --transport http or type: "http" — Claude Code's HTTP transport auto-discovers OAuth endpoints and fails if the server exposes one. The stdio proxy bypasses this entirely.


Step 4 — Verify & next steps

Tell the user:

WrenAI MCP config written to .mcp.json.

Next steps:

  1. Restart Claude Code to activate the connection (config changes require a restart)
  2. After restarting, try: /wrenai-analyst how many records do I have?

The wrenai-analyst skill is available for data analysis, SQL generation, and charting.


Step 5 — Troubleshooting

If the connection fails:

IssueFix
"Failed to reconnect"Fully restart the agent — /mcp reconnect uses cached config
401 UnauthorizedCheck API key, or set MCP_SKIP_AUTH=true on the WrenAI server
Node.js version errorThe proxy needs Node >= 20 — check the command path
Connection refusedVerify WrenAI is running at the specified URL
OAuth timeout (HTTP transport)Do NOT use type: "http" — use the stdio proxy to bypass OAuth discovery
"Token expired without refresh token"Remove any stale server config from ~/.claude.json with claude mcp remove wrenai -s local

Claude Desktop setup

The same config works for Claude Desktop. The config file location:

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
  • Windows: %APPDATA%\Claude\claude_desktop_config.json

Use the same command/args structure as .mcp.json. The mcp-proxy.mjs path must be absolute.

Keep looking

Skills are one crate of 610,677. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.