Search / io.github.itzhouq/archery-mcp
Archery MCP
L0· runs locallyRead-only MCP server for the Archery SQL audit platform: production schema and release SQL checks
v0.1.1 · active · repository · descriptor JSON · versions
Search / io.github.itzhouq/archery-mcp
L0· runs locallyRead-only MCP server for the Archery SQL audit platform: production schema and release SQL checks
v0.1.1 · active · repository · descriptor JSON · versions
{
"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}"
}
}
}
}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}" -- uvx archery-mcp==0.1.1[mcp_servers.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}" }
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"archery-mcp": {
"type": "local",
"command": [
"uvx",
"archery-mcp==0.1.1"
],
"enabled": true,
"environment": {
"ARCHERY_BASE_URL": "{env:ARCHERY_BASE_URL}",
"ARCHERY_USERNAME": "{env:ARCHERY_USERNAME}",
"ARCHERY_PASSWORD": "{env:ARCHERY_PASSWORD}",
"ARCHERY_TOTP_SECRET": "{env:ARCHERY_TOTP_SECRET}",
"ARCHERY_INSTANCE_NAME": "{env:ARCHERY_INSTANCE_NAME}",
"ARCHERY_DB_NAME": "{env:ARCHERY_DB_NAME}"
}
}
}
}{
"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}"
}
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=archery-mcp&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJhcmNoZXJ5LW1jcD09MC4xLjEiXSwiZW52Ijp7IkFSQ0hFUllfQkFTRV9VUkwiOiIke0FSQ0hFUllfQkFTRV9VUkx9IiwiQVJDSEVSWV9VU0VSTkFNRSI6IiR7QVJDSEVSWV9VU0VSTkFNRX0iLCJBUkNIRVJZX1BBU1NXT1JEIjoiJHtBUkNIRVJZX1BBU1NXT1JEfSIsIkFSQ0hFUllfVE9UUF9TRUNSRVQiOiIke0FSQ0hFUllfVE9UUF9TRUNSRVR9IiwiQVJDSEVSWV9JTlNUQU5DRV9OQU1FIjoiJHtBUkNIRVJZX0lOU1RBTkNFX05BTUV9IiwiQVJDSEVSWV9EQl9OQU1FIjoiJHtBUkNIRVJZX0RCX05BTUV9In19"
}{
"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}"
}
}
}
}{
"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}"
}
}
}
}extensions:
"archery-mcp":
enabled: true
name: "archery-mcp"
type: stdio
cmd: "uvx"
args:
- "archery-mcp==0.1.1"
envs:
"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}"
timeout: 300
Placeholders to fill from your own secret store: ${ARCHERY_PASSWORD}, ${ARCHERY_TOTP_SECRET}. The registry never accepts secret values.
This is a local package: the command runs on your machine.
Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)auth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)stability.changes, stability.rug_pulltool list unknownNo tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo ~liveness-unmeasured +updated-13d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
[email protected] PyPIthis version is not known to the dependency resolver
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
archery-mcp | pypi | 0.1.1 | – | ARCHERY_PASSWORD, ARCHERY_TOTP_SECRET |
No tools observed. Local packages are never executed by the registry.
Schemas: list_tools.
{
"name": "io.github.itzhouq/archery-mcp",
"title": "Archery MCP",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.1.1",
"packages": [
{
"version": "0.1.1",
"transport": {
"type": "stdio"
},
"identifier": "archery-mcp",
"registryType": "pypi",
"environmentVariables": [
{
"name": "ARCHERY_BASE_URL",
"format": "string",
"isRequired": true,
"description": "Base URL of your Archery deployment, e.g. https://archery.example.com"
},
{
"name": "ARCHERY_USERNAME",
"format": "string",
"isRequired": true,
"description": "Archery account username (use a dedicated least-privilege account)"
},
{
"name": "ARCHERY_PASSWORD",
"format": "string",
"isSecret": true,
"isRequired": true,
"description": "Archery account password"
},
{
"name": "ARCHERY_TOTP_SECRET",
"format": "string",
"isSecret": true,
"description": "Base32 TOTP secret if the account enables Google Authenticator 2FA"
},
{
"name": "ARCHERY_INSTANCE_NAME",
"format": "string",
"isRequired": true,
"description": "Archery instance name to lock the server to"
},
{
"name": "ARCHERY_DB_NAME",
"format": "string",
"isRequired": true,
"description": "Database name to lock the server to"
},
{
"name": "ARCHERY_SCHEMA_NAME",
"format": "string",
"description": "Schema name (PostgreSQL usually 'public'; leave empty for MySQL)"
},
{
"name": "ARCHERY_QUERY_LIMIT",
"format": "string",
"description": "Default row limit when the query tool is called without limit; 0 delegates the max to Archery"
}
]
}
],
"repository": {
"url": "https://github.com/itzhouq/archery-mcp",
"source": "github"
},
"description": "Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks"
}