MySkillDB Job Categories MCP

MCP server so Claude (Desktop / Code) or Cursor can push job categories into a college org through the existing MySkillDB API.

Two ways to run it:

Mode	File	Auth	Best for
HTTP connector (recommended)	`src/http.ts`	Click Connect in Claude → login page → done	Claude custom connectors
Stdio	`src/index.ts`	Paste JWT into config env	Cursor / quick local use

Start it (MySkillDB API must be running):

cd MySkillDb-mcp
npm run start:http
# MCP endpoint: http://localhost:3737/mcp

Then in Claude → Settings → Connectors → Add custom connector, enter:

http://localhost:3737/mcp

Click Connect — a MySkillDB login page opens. Sign in with your org admin email/password and Claude gets access automatically. Tokens refresh on their own; no JWT copying.

The org is taken from the logged-in user's account, so there's nothing else to configure.

If your Claude client refuses plain http://localhost (claude.ai web requires a public HTTPS URL), expose it with a tunnel:
npx cloudflared tunnel --url http://localhost:3737
Then restart with MCP_PUBLIC_URL=https://your-tunnel-domain.trycloudflare.com npm run start:http and add https://your-tunnel-domain.trycloudflare.com/mcp as the connector.

Env vars (all optional):

Env	Default
`MYSKILLDB_API_BASE_URL`	`http://localhost:3001/api`
`MCP_PORT`	`3737`
`MCP_PUBLIC_URL`	`http://localhost:3737` (set when tunneling)

Stdio mode (token in config)

Tools

Tool	Purpose
`list_job_categories`	List categories for the org
`get_job_category`	Fetch one by slug or id
`upsert_job_category`	Create or update one category (match by `categoryKey` / `slug`)
`push_job_categories`	Batch upsert (up to 50) — best for Claude-authored catalogs
`ensure_other_category`	Ensure the catch-all Other category exists
`delete_job_category`	Delete by id (Other is protected server-side)

Setup

cd MySkillDb-mcp
npm install

1. Get an access token

Log in as org_admin (or acc_manager / master_admin) and copy the JWT access token, e.g. from DevTools → Application → localStorage, or:

curl -s -X POST http://localhost:3001/api/auth/login \
  -H 'Content-Type: application/json' \
  -d '{"email":"you@college.edu","password":"your-password"}'

Use the accessToken from the response. Also note your organizationId.

2. Env vars the MCP needs

Env	Example
`MYSKILLDB_API_BASE_URL`	`http://localhost:3001/api`
`MYSKILLDB_ACCESS_TOKEN`	JWT from login
`MYSKILLDB_ORGANIZATION_ID`	`69206d9f666e11592c65bcc7`

3. Claude Desktop config

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

{
  "mcpServers": {
    "myskilldb-job-categories": {
      "command": "npx",
      "args": [
        "tsx",
        "/Users/ajaykrishnan/Downloads/MySkillDB/Apps/MySkillDB_New/MySkillDb-mcp/src/index.ts"
      ],
      "env": {
        "MYSKILLDB_API_BASE_URL": "http://localhost:3001/api",
        "MYSKILLDB_ACCESS_TOKEN": "paste-jwt-here",
        "MYSKILLDB_ORGANIZATION_ID": "paste-org-id-here"
      }
    }
  }
}

Restart Claude Desktop after saving.

4. Cursor config

Add the same block under Cursor MCP settings / .cursor/mcp.json:

{
  "mcpServers": {
    "myskilldb-job-categories": {
      "command": "npx",
      "args": [
        "tsx",
        "/Users/ajaykrishnan/Downloads/MySkillDB/Apps/MySkillDB_New/MySkillDb-mcp/src/index.ts"
      ],
      "cwd": "/Users/ajaykrishnan/Downloads/MySkillDB/Apps/MySkillDB_New/MySkillDb-mcp",
      "env": {
        "MYSKILLDB_API_BASE_URL": "http://localhost:3001/api",
        "MYSKILLDB_ACCESS_TOKEN": "paste-jwt-here",
        "MYSKILLDB_ORGANIZATION_ID": "paste-org-id-here"
      }
    }
  }
}

Example prompt for Claude

Using the MySkillDB job categories MCP, push a Tech category for "Backend Engineering" with slug backend-engineering, categoryKey backend, about/day-in-life/skills/tools/growth plan suitable for Indian campus placement students. Then list categories to confirm.

Claude should call upsert_job_category or push_job_categories.

Local smoke test

With the API running and env exported:

export MYSKILLDB_API_BASE_URL=http://localhost:3001/api
export MYSKILLDB_ACCESS_TOKEN=...
export MYSKILLDB_ORGANIZATION_ID=...
npm run inspect

Notes

The MySkillDB server must be running.
Token must belong to an admin role that can write /api/job-categories.
Never commit real JWTs into git — keep them in local MCP config only.
stdout is reserved for MCP JSON-RPC; logs go to stderr.