Agent skill
restaurant-report
Create report how many guests there where each day
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/development/restaurant-report
SKILL.md
Restaurant report
Instructions
Google sheet
- Generate the report from the Google sheet specified in environment variable $LUNCH_GOOGLE_SHEET.
- Download the sheet as a CSV.
Generate the report
- Summarize the number of guests per day for all dates that exist in the data.
- Make a list of dates and number of guests.
Number of guests
- Count the number of guests, it is specified on the row marked "Total".
Additional guests
- In the same column on the rows below there is freeform text about additional guests. These should be added to the total.
Additional guests parsing rules
- If specified as "Person + n", it counts as n + 1.
- If specified as "n (Person)", it counts as n.
Save the report to database
- Write the complete report in a database table in the chinook database.
- Connection info is specified in multiple environment variables on the format $CHINOOK*.
- If the table restaurant_report do not exist, then create it.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?