Method create

server/src/db/agent-context-db.ts:282–326

* Create a new agent context

(input: CreateAgentContextInput)

   * Create a new agent context
   */
  async create(input: CreateAgentContextInput): Promise<AgentContext> {
    const result = await query(
      `INSERT INTO agent_contexts (
        organization_id,
        agent_url,
        agent_name,
        agent_type,
        protocol,
        created_by
      ) VALUES ($1, $2, $3, $4, $5, $6)
      RETURNING
        id,
        organization_id,
        agent_url,
        agent_name,
        agent_type,
        protocol,
        FALSE as has_auth_token,
        auth_token_hint,
        auth_type,
        FALSE as has_oauth_token,
        FALSE as has_oauth_refresh_token,
        oauth_token_expires_at,
        FALSE as has_oauth_client,
        tools_discovered,
        last_discovered_at,
        last_test_scenario,
        last_test_passed,
        last_test_summary,
        last_tested_at,
        total_tests_run,
        created_at,
        updated_at,
        created_by`,
      [
        input.organization_id,
        input.agent_url,
        input.agent_name || null,
        input.agent_type || 'unknown',
        input.protocol || 'mcp',
        input.created_by || null,
      ]
    );
    return result.rows[0];
  }

  /**
   * Update an agent context