Archery MCP
Read-only MCP server for the Archery SQL audit platform: production schema and release…
- 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-mcpAdd 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.comRequiredARCHERY_USERNAMEArchery account username (use a dedicated least-privilege account)RequiredARCHERY_PASSWORDArchery account passwordRequiredARCHERY_TOTP_SECRETBase32 TOTP secret if the account enables Google Authenticator 2FAARCHERY_INSTANCE_NAMEArchery instance name to lock the server toRequiredARCHERY_DB_NAMEDatabase name to lock the server toRequiredARCHERY_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.