Archery MCP

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

Connector by itzhouq · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/itzhouq-archery-mcp

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

About

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

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools: 5 read · 0 write · 0 deleteRead-only
Secrets: 2 (API keys, tokens or passwords)
Install scripts: Not scanned yet
Runs as: Python package

Tools by what they do 5

Read from the source code; the running server may list different tools.

Read 5 · Look things up without changing anything.

describe_table
list_tables
query
query_history
sql_check

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

ARCHERY_PASSWORD
ARCHERY_TOTP_SECRET

Other settings (environment variables or headers).

ARCHERY_BASE_URL
ARCHERY_DB_NAME
ARCHERY_INSTANCE_NAME
ARCHERY_QUERY_LIMIT
ARCHERY_SCHEMA_NAME
ARCHERY_USERNAME

Tools (5)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

describe_table
查看当前配置目标库中指定表的字段、类型、默认值和注释。 Args: table_name: Archery 中可访问的表名
list_tables
列出当前配置的 Archery 目标库中的表，可按关键字过滤表名。 Args: keyword: 可选的表名过滤关键字，大小写不敏感
query
通过 Archery 在线查询执行 SQL。 SQL 是否可执行、是否只读、是否包含敏感字段、最大返回行数、查询超时及结果脱敏均由 Archery 的权限和策略控制。本 MCP 不修改 SQL，也不屏蔽 Archery 返回的字段。 Args: sql: 待提交给 Archery 在线查询的 SQL limit: 可选查询行数。未传时使用 ARCHERY_QUERY_LIMIT；传 0 时交给 Archery 使用其最大权限限制
query_history
查看当前 Archery 账号自己的在线查询历史。 Args: limit: 返回条数，必须为正整数 search: 按 SQL 内容、用户名或别名过滤的关键字
sql_check
检查上线 SQL 是否符合内置规范与 Archery 平台要求。检查项（内置规范）： - 上线 SQL 仅支持 DML/DDL，不接受 SELECT 查询； - 上线 SQL 不使用复杂语法（存储过程/函数/触发器/CTE/窗口函数等）； - 上线 SQL 不需要保证事务，不接受 BEGIN/COMMIT 等事务控制； - 尽量不使用临时表； - UPDATE/DELETE 必须带 WHERE 条件。同时调用 Archery 平台的 SQL 检查接口（需要账号在 Archery 的 API 用户白名单内并有上线权限）；平台检查不可用时保留本地结果并说明原因。 Args: sql: 待检查的上线 SQL，可包含多条语句（分号分隔）

Signals

Stars: 0
Forks: 0
Open issues: 0
Weekly downloads: 40
Last commit: Oct 7, 2026 (22 days ago)
Last release: Oct 7, 2026 (22 days ago)
Last package publish: Oct 7, 2026 (22 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name: io.github.itzhouq/archery-mcp
Version: 0.1.1
Auth: API key
Packages: pypi archery-mcp
License: MIT
Repository: github.com/itzhouq/archery-mcp
First seen: Oct 24, 2026
Last checked: Oct 24, 2026
Source: Official MCP Registry github-graphql