Add Code Agent Prompt Files to TiDB

[hawkingrei]

Enhancement

To enhance the development experience for TiDB contributors, we propose adding Code Agent prompt files to the TiDB repository. These prompt files will provide developers with basic development commands and tips, such as compilation and testing instructions, directly within their development environment.

Background:

Code Agents like Claude and other AI assistants can significantly improve developer productivity by providing context-aware suggestions and commands. By creating specific prompt files, we can ensure that these agents are well-equipped to assist with common development tasks in the TiDB project.

[akilesh1706]

@hawkingrei I can work on this issue. Can I get it assigned as part of Hacktober fest 2025?

[lance6716]

This issue has already got a linked PR, you can check other issues with good first issue labels @akilesh1706

[ekexium]

I suppose files like CLAUDE.md can be personalized. Currently I globally gitignore them in my machine. What's the suggseted best practice that utilze both shared knowledge and personal prompts?