Archery MCP

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.itzhouq/archery-mcp",
  "description": "Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks",
  "title": "Archery MCP",
  "repository": {
    "url": "https://github.com/itzhouq/archery-mcp",
    "source": "github"
  },
  "version": "0.1.1",
  "packages": [
    {
      "registryType": "pypi",
      "identifier": "archery-mcp",
      "version": "0.1.1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Base URL of your Archery deployment, e.g. https://archery.example.com",
          "isRequired": true,
          "format": "string",
          "name": "ARCHERY_BASE_URL"
        },
        {
          "description": "Archery account username (use a dedicated least-privilege account)",
          "isRequired": true,
          "format": "string",
          "name": "ARCHERY_USERNAME"
        },
        {
          "description": "Archery account password",
          "isRequired": true,
          "format": "string",
          "isSecret": true,
          "name": "ARCHERY_PASSWORD"
        },
        {
          "description": "Base32 TOTP secret if the account enables Google Authenticator 2FA",
          "format": "string",
          "isSecret": true,
          "name": "ARCHERY_TOTP_SECRET"
        },
        {
          "description": "Archery instance name to lock the server to",
          "isRequired": true,
          "format": "string",
          "name": "ARCHERY_INSTANCE_NAME"
        },
        {
          "description": "Database name to lock the server to",
          "isRequired": true,
          "format": "string",
          "name": "ARCHERY_DB_NAME"
        },
        {
          "description": "Schema name (PostgreSQL usually 'public'; leave empty for MySQL)",
          "format": "string",
          "name": "ARCHERY_SCHEMA_NAME"
        },
        {
          "description": "Default row limit when the query tool is called without limit; 0 delegates the max to Archery",
          "format": "string",
          "name": "ARCHERY_QUERY_LIMIT"
        }
      ]
    }
  ]
}