Skip to content
MCP server

Archery MCP

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

Runs locally
Install
Pricing
Open source
Runs
Locally
Version
0.1.1
Listing updated
1 month ago

About Archery MCP

Archery MCP is an open-source MCP server. It runs locally on your machine and is started by your AI client.

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

Install

Run in a 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

Add to claude_desktop_config.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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.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>"
      }
    }
  }
}

Add to .vscode/mcp.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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.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>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "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>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • ARCHERY_BASE_URLBase URL of your Archery deployment, e.g. https://archery.example.comRequired
  • ARCHERY_USERNAMEArchery account username (use a dedicated least-privilege account)Required
  • ARCHERY_PASSWORDArchery account passwordRequired
  • ARCHERY_TOTP_SECRETBase32 TOTP secret if the account enables Google Authenticator 2FA
  • ARCHERY_INSTANCE_NAMEArchery instance name to lock the server toRequired
  • ARCHERY_DB_NAMEDatabase name to lock the server toRequired
  • ARCHERY_SCHEMA_NAMESchema name (PostgreSQL usually 'public'; leave empty for MySQL)
  • ARCHERY_QUERY_LIMITDefault row limit when the query tool is called without limit; 0 delegates the max to Archery

Pricing

Open source

Archery MCP 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.

How AIPoweredBot checks servers