Archery MCP

io.github.itzhouq/archery-mcp · v0.1.1

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

Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add archery-mcp -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> -e ARCHERY_SCHEMA_NAME=<ARCHERY_SCHEMA_NAME> -e ARCHERY_QUERY_LIMIT=<ARCHERY_QUERY_LIMIT> -- uvx archery-mcp==0.1.1

claude_desktop_config.json

{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp==0.1.1"
      ],
      "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>",
        "ARCHERY_SCHEMA_NAME": "<ARCHERY_SCHEMA_NAME>",
        "ARCHERY_QUERY_LIMIT": "<ARCHERY_QUERY_LIMIT>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "archery-mcp": {
      "command": "uvx",
      "args": [
        "archery-mcp==0.1.1"
      ],
      "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>",
        "ARCHERY_SCHEMA_NAME": "<ARCHERY_SCHEMA_NAME>",
        "ARCHERY_QUERY_LIMIT": "<ARCHERY_QUERY_LIMIT>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "archery-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "archery-mcp==0.1.1"
      ],
      "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>",
        "ARCHERY_SCHEMA_NAME": "<ARCHERY_SCHEMA_NAME>",
        "ARCHERY_QUERY_LIMIT": "<ARCHERY_QUERY_LIMIT>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

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

Details

Package	`[email protected]` (PYPI, stdio)
First published	7 Oct 2026
Last updated	7 Oct 2026
Registry name	`io.github.itzhouq/archery-mcp`

More databases servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use Archery MCP often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-itzhouq-archery-mcp/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-itzhouq-archery-mcp)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.