AutoSkill Gradio PR Dashboard with MySQL and Live Pie Chart

Create a Gradio web application to fetch Purchase Request (PR) details from a MySQL database and visualize status distribution with a live-updating pie chart.

install

source · Clone the upstream repo

git clone https://github.com/ECNU-ICALK/AutoSkill

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/ECNU-ICALK/AutoSkill "$T" && mkdir -p ~/.claude/skills && cp -r "$T/SkillBank/ConvSkill/english_gpt4_8/gradio-pr-dashboard-with-mysql-and-live-pie-chart" ~/.claude/skills/ecnu-icalk-autoskill-gradio-pr-dashboard-with-mysql-and-live-pie-chart && rm -rf "$T"

manifest: SkillBank/ConvSkill/english_gpt4_8/gradio-pr-dashboard-with-mysql-and-live-pie-chart/SKILL.md

source content

Gradio PR Dashboard with MySQL and Live Pie Chart

Create a Gradio web application to fetch Purchase Request (PR) details from a MySQL database and visualize status distribution with a live-updating pie chart.

Prompt

Role & Objective

Act as a Python developer specializing in Gradio web applications. Create a dashboard to interact with a MySQL database containing PR (Purchase Request) records.

Operational Rules & Constraints

Database Connection: Use
```
mysql.connector
```
to connect to
```
localhost
```
, database
```
records
```
, user
```
root
```
.
Table Schema: The table is
```
PR_Details
```
. The primary key is
```
PR_Number
```
. The status column is
```
STATUS
```
(VARCHAR).
UI Layout: Use
```
gr.Blocks
```
with
```
gr.Tabs
```
.
Tab 1: PR Details:
- Input:
```
gr.Textbox
```
  for "PR Number".
- Input:
```
gr.Radio
```
  for "Status" with choices:
```
['Submitted', 'Ordered', 'Composing']
```
  .
- Buttons: "Fetch PR Details" and "Clear".
- Output:
```
gr.HTML
```
  displaying results in a table format.
- Logic: Query
```
SELECT * FROM PR_Details
```
  filtering by
```
PR_Number
```
  and
```
STATUS
```
  if provided.

Tab 2: Live Pie Chart:

Output:
```
gr.Plot
```
.

Logic: Query

SELECT STATUS, COUNT(PR_Number) FROM PR_Details WHERE STATUS IN ('Submitted', 'Ordered', 'Composing') GROUP BY STATUS

Visualization: Use
```
matplotlib
```
to generate a pie chart.
Update: Use
```
gr.update
```
with
```
interval=5
```
to refresh the chart every 5 seconds.

Clear Function: The "Clear" button must reset the PR Number input to empty string and Status to 'Submitted'.

Anti-Patterns

Do not use
```
Current_Status
```
as a column name; use
```
STATUS
```
.
Do not use
```
clear_on_submit=True
```
in
```
gr.Textbox
```
if it causes compatibility issues.

Triggers

create a gradio app for pr details
show pr status pie chart
fetch pr details from mysql
live update pie chart gradio