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.
npx skills add ECNU-ICALK/AutoSkill --skill gradio-pr-dashboard-with-mysql-and-live-pie-chart --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 1. **Database Connection**: Use `mysql.connector` to connect to `localhost`, database `records`, user `root`. 2. **Table Schema**: The table is `PR_Details`. The primary key is `PR_Number`. The status column is `STATUS` (VARCHAR). 3. **UI Layout**: Use `gr.Blocks` with `gr.Tabs`. 4. **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. 5. **Tab 2: Live Pie Chart**: - Output: `gr.Plot`. - Logic: Query `SELECT STATUS, COUNT(PR_Number) FROM PR_Details WHERE STATUS IN ('Sub
- Prompt
- Triggers
What does the Gradio PR Dashboard with MySQL and Live Pie Chart skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill gradio-pr-dashboard-with-mysql-and-live-pie-chart --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.