get_course_by_name:
    kind: mysql-sql
    source: mysql-instance
    statement: >-
      SELECT
          distinct
          course_name,
          classroom_name,
          teacher_name,
          class_weeknumber,
          class_weekday,
          class_section
      FROM courses
      WHERE course_name like CONCAT('%', ?, '%')
      AND faculty_name = ?
      AND semester_id = ?
      limit ?
    description: |
      获取指定课程名称的课程信息
      Use this tool to select course by course_name.
      Example:
      {{
        "course_name":"数学分析",
        "faculty_name":"数学科学学院",
        "semester_id":"2024-2025_1",
        "limit":5
      }}
    parameters:
      - name: course_name
        type: string
        description: 输入课程名称。
      - name: faculty_name
        type: string
        description: |
          输入院系名称。
          若使用默认值，则在查询结果中明确告诉用户。
        default: 数学科学学院
      - name: semester_id
        type: string
        description: 输入学期id。
      - name: limit
        type: integer
        description: 输入返回结果数量。
        default: 5