GitHub Copilot Agents

Review agent in vscode

1. create a folder .github in your workspace
2. Create a agents folder in .github
3. Create Reviewer.agent.md file in agents
4. Choose reviewer as agent in chat window

Reviewer.agent.md content

---
name: "Reviewer"
description: "Review code for quality and adherence to best practices."
tools:
  ["vscode/askQuestions", "vscode/vscodeAPI", "read", "agent", "search", "web"]
---

# Code Reviewer agent

You are an experienced senior developer conducting a thorough code review. Your role is to review the code for quality, best practices without making direct code changes.

When reviewing code, structure your feedback with clear headings and specific examples from the code being reviewed.

## Analysis Focus

- Analyze code quality, structure, and best practices
- Identify potential bugs, security issues, or performance problems
- Evaluate accessibility and user experience considerations

## Important Guidelines

- Ask clarifying questions about design decisions when appropriate
- Focus on explaining what should be changed and why
- DO NOT write or suggest specific code changes directly

MySQL docker container in a host machine which has MySQL server running

Map container to another host port other than 3306

version: '3'
services:

  mysql:
    container_name: docker_mysql_1
    ports:
      - 3307:3306/tcp
    privileged: true
    restart: on-failure
    image: mysql:8.4
    volumes:
      - mysql84:/var/lib/mysql
    network_mode: bridge
    environment:
      MYSQL_ROOT_PASSWORD: test1234
    command:
      - --innodb_file_per_table=0
      - --innodb_checksum_algorithm=INNODB
      - --binlog_checksum=NONE
      - --sql_mode=NO_ENGINE_SUBSTITUTION
      - --slow-query-log=1
      - --slow-query-log-file=/var/log/mysql/my-slow.log
      - --long_query_time=1
      - --log-queries-not-using-indexes
      - --restrict_fk_on_non_standard_key=0
    security_opt:
      - seccomp=unconfined

volumes:
  mysql84:

After container is up, connect to container Mysql Server

#when ask password, type: test1234
mysql -h 127.0.0.1 -P 3307 -u root -p 

#another way using container name
docker exec -it docker_mysql_1 mysql -uroot -p

To connect MySQL running on the host machine. Assume there is MySQL user tester

mysql -u tester -p

How to check who owns 3306 now

#On host:
ss -ltnp | grep 3306
# or
lsof -i :3306

GitHub Copilot

Check vscode version

• Code => About Visual Studio Code (in Mac)
• Help => About

Check which github account is logged in for vscode

Click accounts icon (icon like a person

See Github Copilot features enabled and usage for your account

• log into Github
• Copilot Features

Limitations for different plans

Plans for GitHub Copilot

GitHub Copilot in VS Code docs

Copilot in VS Code

Get Start With Github Copilot

vscode external browser

• install Live Preview extension
• go to command palette
• Live Preview: show debug preview

Shortcuts

• add inline chat. (crtl + i)

troubleshooting

Error: request failed. Solution: log into Github while using vscode

1. in vscode account. sign out
2. in browser, sign out github
3. Open vscode and crtl + i
4. following instruction to sign in again

How to check php package in alpine linux

Go to Alpine Linux

• In Package name field, search php83, php84 or php85
• In Branch field, choose v3.23, v3.23 etc