# ConnectWise PSA MCP server

> Allows an AI assistant to manage tickets, time entries, dispatch schedules, and company configurations within ConnectWise PSA.

- Repository: https://github.com/mspstack/mcp-connectwise-psa
- Page: https://hostedmcp.org/servers/mspstack/mcp-connectwise-psa
- Transport: stdio
- Stars: 6
- License: MIT
- Latest version: 0.12.0

## Install

### Claude Code

```sh
claude mcp add --env 'CW_PRIVATE_KEY=<YOUR_CW_PRIVATE_KEY>' --env 'CW_PUBLIC_KEY=<YOUR_CW_PUBLIC_KEY>' --env 'CW_CLIENT_ID=<CW_CLIENT_ID>' --env 'CW_COMPANY_ID=<CW_COMPANY_ID>' --env 'CW_SITE=<CW_SITE>' --env 'CW_DB_PASSWORD=<YOUR_CW_DB_PASSWORD>' mcp-connectwise-psa -- npx -y mcp-connectwise-psa
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "mcp-connectwise-psa": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-connectwise-psa"
      ],
      "env": {
        "CW_PRIVATE_KEY": "<YOUR_CW_PRIVATE_KEY>",
        "CW_PUBLIC_KEY": "<YOUR_CW_PUBLIC_KEY>",
        "CW_CLIENT_ID": "<CW_CLIENT_ID>",
        "CW_COMPANY_ID": "<CW_COMPANY_ID>",
        "CW_SITE": "<CW_SITE>",
        "CW_DB_PASSWORD": "<YOUR_CW_DB_PASSWORD>"
      }
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "mcp-connectwise-psa": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-connectwise-psa"
      ],
      "env": {
        "CW_PRIVATE_KEY": "<YOUR_CW_PRIVATE_KEY>",
        "CW_PUBLIC_KEY": "<YOUR_CW_PUBLIC_KEY>",
        "CW_CLIENT_ID": "<CW_CLIENT_ID>",
        "CW_COMPANY_ID": "<CW_COMPANY_ID>",
        "CW_SITE": "<CW_SITE>",
        "CW_DB_PASSWORD": "<YOUR_CW_DB_PASSWORD>"
      }
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"mcp-connectwise-psa","type":"stdio","command":"npx","args":["-y","mcp-connectwise-psa"],"env":{"CW_PRIVATE_KEY":"<YOUR_CW_PRIVATE_KEY>","CW_PUBLIC_KEY":"<YOUR_CW_PUBLIC_KEY>","CW_CLIENT_ID":"<CW_CLIENT_ID>","CW_COMPANY_ID":"<CW_COMPANY_ID>","CW_SITE":"<CW_SITE>","CW_DB_PASSWORD":"<YOUR_CW_DB_PASSWORD>"}}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "mcp-connectwise-psa": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-connectwise-psa"
      ],
      "env": {
        "CW_PRIVATE_KEY": "<YOUR_CW_PRIVATE_KEY>",
        "CW_PUBLIC_KEY": "<YOUR_CW_PUBLIC_KEY>",
        "CW_CLIENT_ID": "<CW_CLIENT_ID>",
        "CW_COMPANY_ID": "<CW_COMPANY_ID>",
        "CW_SITE": "<CW_SITE>",
        "CW_DB_PASSWORD": "<YOUR_CW_DB_PASSWORD>"
      }
    }
  }
}
```

### Codex

```sh
codex mcp add mcp-connectwise-psa --env 'CW_PRIVATE_KEY=<YOUR_CW_PRIVATE_KEY>' --env 'CW_PUBLIC_KEY=<YOUR_CW_PUBLIC_KEY>' --env 'CW_CLIENT_ID=<CW_CLIENT_ID>' --env 'CW_COMPANY_ID=<CW_COMPANY_ID>' --env 'CW_SITE=<CW_SITE>' --env 'CW_DB_PASSWORD=<YOUR_CW_DB_PASSWORD>' -- npx -y mcp-connectwise-psa
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.mcp-connectwise-psa]
command = "npx"
args = ["-y", "mcp-connectwise-psa"]

[mcp_servers.mcp-connectwise-psa.env]
CW_PRIVATE_KEY = "<YOUR_CW_PRIVATE_KEY>"
CW_PUBLIC_KEY = "<YOUR_CW_PUBLIC_KEY>"
CW_CLIENT_ID = "<CW_CLIENT_ID>"
CW_COMPANY_ID = "<CW_COMPANY_ID>"
CW_SITE = "<CW_SITE>"
CW_DB_PASSWORD = "<YOUR_CW_DB_PASSWORD>"
```

### Gemini CLI

```sh
gemini mcp add -s user -e 'CW_PRIVATE_KEY=<YOUR_CW_PRIVATE_KEY>' -e 'CW_PUBLIC_KEY=<YOUR_CW_PUBLIC_KEY>' -e 'CW_CLIENT_ID=<CW_CLIENT_ID>' -e 'CW_COMPANY_ID=<CW_COMPANY_ID>' -e 'CW_SITE=<CW_SITE>' -e 'CW_DB_PASSWORD=<YOUR_CW_DB_PASSWORD>' mcp-connectwise-psa npx -- -y mcp-connectwise-psa
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "mcp-connectwise-psa": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-connectwise-psa"
      ],
      "env": {
        "CW_PRIVATE_KEY": "<YOUR_CW_PRIVATE_KEY>",
        "CW_PUBLIC_KEY": "<YOUR_CW_PUBLIC_KEY>",
        "CW_CLIENT_ID": "<CW_CLIENT_ID>",
        "CW_COMPANY_ID": "<CW_COMPANY_ID>",
        "CW_SITE": "<CW_SITE>",
        "CW_DB_PASSWORD": "<YOUR_CW_DB_PASSWORD>"
      }
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `CW_PRIVATE_KEY` | yes | yes | API member private key |
| `CW_PUBLIC_KEY` | yes | yes | API member public key |
| `CW_CLIENT_ID` | yes | no | Integration clientId from developer.connectwise.com |
| `CW_COMPANY_ID` | yes | no | ConnectWise login company id |
| `CW_SITE` | yes | no | ConnectWise host (e.g. na.myconnectwise.net or an on-prem host; full URLs accepted) |
| `CW_DB_PASSWORD` | no | yes | Password for the read-only database login |
| `CW_DB_HOST` | no | no | ConnectWise SQL Server host (on-prem only) — enables the opt-in sql toolset |
| `CW_DB_NAME` | no | no | ConnectWise Manage database, e.g. cwwebapp_acme |
| `CW_DB_QUERY_LIBRARY` | no | no | Path to a writable JSON file holding saved SQL queries |
| `CW_DB_USER` | no | no | Dedicated read-only database login (db_datareader) |
| `CW_MEMBER_IDENTIFIER` | no | no | Member identifier the API keys belong to — enables "my tickets"/"my time" tools |
| `CW_TOOLSETS` | no | no | Comma list of toolsets/presets (default: all). Add sql for database queries. |

## FAQ

### How does the server handle security and user permissions?

The server uses a Bring Your Own Key (BYOK) model where each user provides their own ConnectWise member API keys, ensuring ConnectWise enforces that member's specific security role.

### Can the AI assistant see all available tools at once?

By default, the server provides all capabilities, but you can narrow the toolset per session using presets like 'tech', 'dispatch', or 'invoicing' to keep the context small.

### Is the invoicing toolset capable of making changes?

No, the invoicing toolset is strictly read-only.
