# Archery MCP

> Archery MCP is an open-source MCP server. Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Repository:** https://github.com/itzhouq/archery-mcp
- **MCP Registry name:** io.github.itzhouq/archery-mcp
- **Listing updated:** 2026-10-07

## About

Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks

## Install

### Claude Code (Terminal)

```sh
claude mcp add archery-mcp --env ARCHERY_BASE_URL='<ARCHERY_BASE_URL>' --env ARCHERY_USERNAME='<ARCHERY_USERNAME>' --env ARCHERY_PASSWORD='<ARCHERY_PASSWORD>' --env ARCHERY_TOTP_SECRET='<ARCHERY_TOTP_SECRET>' --env ARCHERY_INSTANCE_NAME='<ARCHERY_INSTANCE_NAME>' --env ARCHERY_DB_NAME='<ARCHERY_DB_NAME>' -- uvx archery-mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp"
      ],
      "env": {
        "ARCHERY_BASE_URL": "<ARCHERY_BASE_URL>",
        "ARCHERY_USERNAME": "<ARCHERY_USERNAME>",
        "ARCHERY_PASSWORD": "<ARCHERY_PASSWORD>",
        "ARCHERY_TOTP_SECRET": "<ARCHERY_TOTP_SECRET>",
        "ARCHERY_INSTANCE_NAME": "<ARCHERY_INSTANCE_NAME>",
        "ARCHERY_DB_NAME": "<ARCHERY_DB_NAME>"
      }
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp"
      ],
      "env": {
        "ARCHERY_BASE_URL": "<ARCHERY_BASE_URL>",
        "ARCHERY_USERNAME": "<ARCHERY_USERNAME>",
        "ARCHERY_PASSWORD": "<ARCHERY_PASSWORD>",
        "ARCHERY_TOTP_SECRET": "<ARCHERY_TOTP_SECRET>",
        "ARCHERY_INSTANCE_NAME": "<ARCHERY_INSTANCE_NAME>",
        "ARCHERY_DB_NAME": "<ARCHERY_DB_NAME>"
      }
    }
  }
}
```

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

```json
{
  "servers": {
    "archery-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "archery-mcp"
      ],
      "env": {
        "ARCHERY_BASE_URL": "<ARCHERY_BASE_URL>",
        "ARCHERY_USERNAME": "<ARCHERY_USERNAME>",
        "ARCHERY_PASSWORD": "<ARCHERY_PASSWORD>",
        "ARCHERY_TOTP_SECRET": "<ARCHERY_TOTP_SECRET>",
        "ARCHERY_INSTANCE_NAME": "<ARCHERY_INSTANCE_NAME>",
        "ARCHERY_DB_NAME": "<ARCHERY_DB_NAME>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp"
      ],
      "env": {
        "ARCHERY_BASE_URL": "<ARCHERY_BASE_URL>",
        "ARCHERY_USERNAME": "<ARCHERY_USERNAME>",
        "ARCHERY_PASSWORD": "<ARCHERY_PASSWORD>",
        "ARCHERY_TOTP_SECRET": "<ARCHERY_TOTP_SECRET>",
        "ARCHERY_INSTANCE_NAME": "<ARCHERY_INSTANCE_NAME>",
        "ARCHERY_DB_NAME": "<ARCHERY_DB_NAME>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp"
      ],
      "env": {
        "ARCHERY_BASE_URL": "<ARCHERY_BASE_URL>",
        "ARCHERY_USERNAME": "<ARCHERY_USERNAME>",
        "ARCHERY_PASSWORD": "<ARCHERY_PASSWORD>",
        "ARCHERY_TOTP_SECRET": "<ARCHERY_TOTP_SECRET>",
        "ARCHERY_INSTANCE_NAME": "<ARCHERY_INSTANCE_NAME>",
        "ARCHERY_DB_NAME": "<ARCHERY_DB_NAME>"
      }
    }
  }
}
```

## FAQ

### Is Archery MCP free?

Yes. Archery MCP is open source, so you can use and self-host it for free.

### How do I add Archery MCP to Claude Code?

Run this command in your terminal: claude mcp add archery-mcp --env ARCHERY_BASE_URL='<ARCHERY_BASE_URL>' --env ARCHERY_USERNAME='<ARCHERY_USERNAME>' --env ARCHERY_PASSWORD='<ARCHERY_PASSWORD>' --env ARCHERY_TOTP_SECRET='<ARCHERY_TOTP_SECRET>' --env ARCHERY_INSTANCE_NAME='<ARCHERY_INSTANCE_NAME>' --env ARCHERY_DB_NAME='<ARCHERY_DB_NAME>' -- uvx archery-mcp

## Where this comes from

- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.

---
Source: https://ai-powered.com/mcp/archery-mcp
