Archery MCP Server

by itzhouqio.github.itzhouq/archery-mcpv0.1.1

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

0Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active2d ago

Install Archery MCP server

claude mcp add archery -e ARCHERY_BASE_URL='<archery-base-url>' -e ARCHERY_USERNAME='<archery-username>' -e ARCHERY_PASSWORD='<archery-password>' -e ARCHERY_TOTP_SECRET='<archery-totp-secret>' -e ARCHERY_INSTANCE_NAME='<archery-instance-name>' -e ARCHERY_DB_NAME='<archery-db-name>' -- uvx archery-mcp

{
  "mcpServers": {
    "archery": {
      "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "archery": {
      "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>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "archery": {
      "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>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "archery": {
      "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
ARCHERY_BASE_URL	yes	—	Base URL of your Archery deployment, e.g. https://archery.example.com
ARCHERY_USERNAME	yes	—	Archery account username (use a dedicated least-privilege account)
ARCHERY_PASSWORD	yes	yes	Archery account password
ARCHERY_TOTP_SECRET	—	yes	Base32 TOTP secret if the account enables Google Authenticator 2FA
ARCHERY_INSTANCE_NAME	yes	—	Archery instance name to lock the server to
ARCHERY_DB_NAME	yes	—	Database name to lock the server to
ARCHERY_SCHEMA_NAME	—	—	Schema name (PostgreSQL usually 'public'; leave empty for MySQL)
ARCHERY_QUERY_LIMIT	—	—	Default row limit when the query tool is called without limit; 0 delegates the max to Archery

Freshness

Active — last maintenance signal 2d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-07 · 2d ago · GitHub
Latest release
2026-10-07 · 2d ago · GitHub · v0.1.1
Package published
no data · npm/PyPI
Registry entry updated
2026-10-07 · 2d ago · official registry · v0.1.1

FAQ

›How do I install the Archery MCP server in Claude Code?

Run: claude mcp add archery -e ARCHERY_BASE_URL='<archery-base-url>' -e ARCHERY_USERNAME='<archery-username>' -e ARCHERY_PASSWORD='<archery-password>' -e ARCHERY_TOTP_SECRET='<archery-totp-secret>' -e ARCHERY_INSTANCE_NAME='<archery-instance-name>' -e ARCHERY_DB_NAME='<archery-db-name>' -- uvx archery-mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Archery require an API key?

Yes. It expects ARCHERY_BASE_URL, ARCHERY_USERNAME, ARCHERY_PASSWORD, ARCHERY_INSTANCE_NAME, ARCHERY_DB_NAME, ARCHERY_TOTP_SECRET, of which 2 are secrets.

›Can I use Archery as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Archery in the official MCP registry?

Yes, as io.github.itzhouq/archery-mcp.