{
  "name": "ARK-NL2SQL",
  "version": "0.2.0",
  "protocol": "2024-11-05",
  "transport": "http+jsonrpc",
  "auth": {
    "primary": "Authorization: Bearer <api-key>",
    "alternates": [
      "X-Ark-Key: <api-key>",
      "?key=<api-key>  (query param — leaks to access logs, dev only)"
    ],
    "signupAt": "/Auth/SignIn",
    "keyLocation": "Visit /Home/Settings while signed in to copy or rotate your API key."
  },
  "capabilities": {
    "resources": true,
    "tools": true,
    "prompts": true
  },
  "tools": [
    {
      "name": "translate_to_sql",
      "purpose": "Convert NL question -> SQL for a registered schema."
    },
    {
      "name": "list_schemas",
      "purpose": "List the caller's registered schemas with metadata."
    },
    {
      "name": "get_schema",
      "purpose": "Return the full table+column shape for one schema."
    },
    {
      "name": "preview_tables",
      "purpose": "Preview which tables the optimizer would send to the LLM for a given question (no LLM call)."
    }
  ],
  "promptTemplates": [
    "explore_schema",
    "sql_for_question",
    "troubleshoot_query"
  ],
  "models": [
    {
      "Key": "AzureOpenAI:gpt-4o",
      "Provider": "AzureOpenAI",
      "ModelName": "gpt-4o",
      "Label": "Azure OpenAI · gpt-4o"
    },
    {
      "Key": "EmbeddedGguf:gemma-2-2b-it-Q4_K_M",
      "Provider": "EmbeddedGguf",
      "ModelName": "gemma-2-2b-it-Q4_K_M",
      "Label": "Embedded · gemma-2-2b-it-Q4_K_M (CPU)"
    }
  ],
  "endpoints": {
    "rpc": "POST /mcp",
    "sse": "GET /mcp",
    "trace": "GET /mcp/audit"
  }
}