🎁 Get the FREE AI Skills Starter Guide β€” Subscribe β†’
BytesAgainBytesAgain
BytesAgain β€Ί Skills β€Ί TCM Clinic - English Edition
πŸ¦€ ClawHub

TCM Clinic - English Edition

by @slamw

A full-featured management tool for solo Traditional Chinese Medicine (TCM) practitioners. Manages patient records, medical charts (Four Diagnostic Methods,...

Versionv1.0.1
Downloads572
#crypto-defi#translation#legal#health#productivity
TERMINAL
clawhub install tcm-clinic-en

πŸ“– About This Skill

name: tcm-clinic-en description: "A full-featured management tool for solo Traditional Chinese Medicine (TCM) practitioners. Manages patient records, medical charts (Four Diagnostic Methods, pattern differentiation, prescriptions), herbal inventory (stock-in, stocktake, low-stock alerts), appointment scheduling, and financial bookkeeping with statistics. Data stored in Excel format. Use when: the user mentions patients, medical records, prescriptions, herbs, inventory, appointments, scheduling, billing, finances, clinic, consultation fees, or needs day-to-day clinic management. NOT for: academic TCM theory discussions, formula research, or herb pharmacology analysis." requires: binary: - name: python3 python: - openpyxl

TCM Clinic Management System

Overview

This Skill provides lightweight, full-process management for a solo TCM (Traditional Chinese Medicine) practitioner, covering five modules:

| Module | Trigger Words | |--------|---------------| | πŸ₯ Patient Records | new patient, register patient, find patient, search patient | | πŸ“‹ Medical Charts | write chart, four examinations, pattern differentiation, prescription, medical history | | 🌿 Herbal Inventory | stock in, restock, check inventory, low stock alert, dispense | | πŸ“… Appointments | appointment, schedule, today's appointments, booking | | πŸ’° Finances & Billing | charge, bill, billing, statistics, monthly report, financial report |

All data is stored as structured Excel files in the clinic_data/ directory.

When to Run

  • User wants to register a new patient or look up patient information
  • User needs to record or review medical charts or prescriptions
  • User mentions herbal stock-in, inventory checks, or low-stock alerts
  • User needs to manage appointments or view today's schedule
  • User requests billing, charges, or income reports
  • User initiates a "consultation" request (one-stop visit workflow)
  • User requests "initialize clinic" (first-time setup)

    • Workflow

    Decision Router

    Route the user's intent to the corresponding module:

    User Request
β”œβ”€β”€ Patient-related? β†’ Patient Management Module
β”‚   β”œβ”€β”€ "new patient" / "register patient" β†’ Create patient record
β”‚   β”œβ”€β”€ "find patient" / "search patient" β†’ Search by name/phone/ID
β”‚   β”œβ”€β”€ "update patient" β†’ Update patient record
β”‚   └── "patient list" / "all patients" β†’ Output patient summary
β”œβ”€β”€ Medical chart-related? β†’ Medical Records Module
β”‚   β”œβ”€β”€ "write chart" / "new chart" β†’ Add medical record (incl. four examinations, pattern differentiation, prescription)
β”‚   β”œβ”€β”€ "view chart" / "medical history" β†’ Query historical visit records by patient
β”‚   └── "update chart" β†’ Modify existing record
β”œβ”€β”€ Herb-related? β†’ Herbal Inventory Module
β”‚   β”œβ”€β”€ "stock in" / "restock" / "purchase" β†’ Add new herb or increase stock
β”‚   β”œβ”€β”€ "check inventory" / "herb stock" β†’ Query inventory status
β”‚   β”œβ”€β”€ "low stock" / "out of stock" β†’ Low-stock alert report
β”‚   β”œβ”€β”€ "stock out" / "dispense" β†’ Reduce stock
β”‚   └── "stocktake" / "inventory check" β†’ Generate inventory count sheet
β”œβ”€β”€ Appointment-related? β†’ Appointment Scheduling Module
β”‚   β”œβ”€β”€ "appointment" / "booking" / "schedule" β†’ Add appointment
β”‚   β”œβ”€β”€ "today's appointments" / "today's patients" β†’ View today's schedule
β”‚   └── "change appointment" / "cancel appointment" β†’ Modify appointment status
β”œβ”€β”€ Finance-related? β†’ Financial Module
β”‚   β”œβ”€β”€ "charge" / "bill" / "fee" β†’ Add financial record
β”‚   β”œβ”€β”€ "check accounts" / "income" / "transactions" β†’ Query financial records
β”‚   β”œβ”€β”€ "statistics" / "report" / "monthly report" β†’ Generate income statistics
β”‚   └── "patient charges" / "outstanding balance" β†’ Query patient charge summary
└── Combined request? β†’ Multi-module Workflow
    β”œβ”€β”€ "consultation" β†’ Appointment β†’ Medical Chart β†’ Billing (one-stop)
    β”œβ”€β”€ "clinic report" / "business analysis" β†’ Comprehensive business data report
    └── "today's summary" β†’ Daily summary across all modules

    Initialize New Clinic

    On first use or when the user requests "initialize", execute:

    python3 SKILL_DIR/scripts/clinic_manager.py init

    This creates the clinic_data/ directory in the current working directory, containing 5 empty data tables (header rows only).

    Script Invocation Convention

    Use the bash tool to execute commands in the following format:

    python3 SKILL_DIR/scripts/clinic_manager.py   [options...]

    > SKILL_DIR must be replaced with the actual installation path of the Skill. > For example: ~/.codebuddy/skills/tcm-clinic or ~/.openclaw/workspace/skills/tcm-clinic

    #### Common Commands

    # Initialize
python3 SKILL_DIR/scripts/clinic_manager.py init
    Patient management
    
python3 SKILL_DIR/scripts/clinic_manager.py patients add --name "John Smith" --gender "Male" --phone "555-0100"
python3 SKILL_DIR/scripts/clinic_manager.py patients search --name "John"
python3 SKILL_DIR/scripts/clinic_manager.py patients list
    Medical records
    
python3 SKILL_DIR/scripts/clinic_manager.py records add --patient-id "P20260402001" --complaint "Headache for 3 days" --diagnosis "Wind-cold headache"
python3 SKILL_DIR/scripts/clinic_manager.py records search --patient-id "P20260402001"
    Herbal inventory
    
python3 SKILL_DIR/scripts/clinic_manager.py herbs add --name "Astragalus (Huangqi)" --quantity 500 --unit "g" --category "Qi tonic" --purchase-price 0.15 --min-stock 100
python3 SKILL_DIR/scripts/clinic_manager.py herbs update --herb-id "H001" --quantity -50
python3 SKILL_DIR/scripts/clinic_manager.py herbs alerts
python3 SKILL_DIR/scripts/clinic_manager.py herbs list
    Appointments
    
python3 SKILL_DIR/scripts/clinic_manager.py appointments add --patient-id "P20260402001" --time-slot "Morning"
python3 SKILL_DIR/scripts/clinic_manager.py appointments today
    Financial statistics
    
python3 SKILL_DIR/scripts/clinic_manager.py finance add --patient-id "P20260402001" --type "Consultation fee" --amount 50 --payment-method "WeChat Pay"
python3 SKILL_DIR/scripts/clinic_manager.py finance summary --period day
python3 SKILL_DIR/scripts/clinic_manager.py finance summary --period month --month 2026-04

    Usage Strategy

  • Simple queries and standard CRUD: Call script commands directly, parse JSON output
  • Complex business logic (e.g., one-stop consultation, multi-module workflows): Combine conversational interaction with script commands; query data first, then process
  • Report generation: Scripts provide basic statistics; further format as Markdown tables

    • Data Operation Principles

    1. Pre-use check: Confirm clinic_data/ directory exists; if not, prompt user to initialize 2. Create operations: Auto-generate IDs, validate required fields, append new rows 3. Update operations: Locate target row by ID, update only specified fields 4. Delete operations: Mark as "void" or "cancelled"; no physical deletion 5. Linked updates: When adding a medical record, auto-update patient's last_visit_date and visit_count

    One-Stop Consultation Workflow

    When the user initiates a "consultation" request, execute in order:

    1. Confirm or select patient (choose from existing patients or create new record) 2. Review patient's historical medical chart summary (most recent diagnosis and prescription) 3. Record current visit's four examination findings (inspection, auscultation/olfaction, inquiry, palpation), pattern differentiation, and prescription 4. Calculate fees (consultation fee + herbal cost, etc.) and generate financial record 5. If herbal prescription is involved, auto-deduct corresponding herb stock and check low-stock alerts 6. Output complete summary of this consultation

    ID Generation Rules

  • Patient ID: P + YYYYMMDD + 3-digit sequence (e.g., P20260402001)
  • Record ID: R + YYYYMMDD + 3-digit sequence
  • Appointment ID: A + YYYYMMDD + 3-digit sequence
  • Finance ID: F + YYYYMMDD + 3-digit sequence
  • Herb ID: H + 3-digit sequence (e.g., H001, no date prefix)
  • Sequence number auto-increments from existing data

    • Data Field Reference

    Before performing data operations, read references/data-schema.md for complete field definitions (field name, type, required/optional, value ranges).

    Main data tables:

  • clinic_data/patients.xlsx β€” Patient information (name, gender, age, contact, constitution type, allergies, etc.)
  • clinic_data/medical_records.xlsx β€” Medical records (four examination findings, pattern differentiation, prescription, medical advice)
  • clinic_data/herbs_inventory.xlsx β€” Herbal inventory (herb name, specification, stock quantity, price, expiry date, minimum stock)
  • clinic_data/appointments.xlsx β€” Appointments (date, time slot, patient, status)
  • clinic_data/finances.xlsx β€” Financial records (visit ID, fee type, amount, payment method)

    • Output Format

  • Query results displayed as Markdown tables with key data in bold
  • Amounts precise to cents (e.g., $120.50 or Β₯120.50)
  • Dates in YYYY-MM-DD format
  • Low-stock alerts marked with ⚠️
  • Successful operations marked with βœ…
  • Errors marked with ❌
  • Use TCM professional terminology in conversation (Four Examinations, pattern differentiation, treatment principles and formulas)

    • Interaction Style

  • Conversational yet professional
  • When recording data, if user hasn't provided required fields, proactively ask for clarification
  • Briefly confirm operation details before executing write operations
  • Financial reports grouped by fee type and payment method, showing percentages