sql-reports
by @kyawzo-ptcl
Connects to SQL Server to retrieve and generate monthly, quarterly, and yearly delivery order reports with performance comparisons and growth metrics.
clawhub install sql-reportsπ About This Skill
SQL Reports
Query Delivery Orders from SQL Server and generate delivery reports for business analysis.
Overview
This skill connects to a SQL Server database to extract and analyze delivery order data. It's designed for warehouse managers and logistics teams who need quick access to delivery statistics without writing SQL queries manually.
Database Connection
Prerequisites
1. Python 3.8+ installed
2. pyodbc library installed: pip install pyodbc
3. ODBC Driver 17 for SQL Server installed on Windows
4. Network access to LTEDP056 server on port 1433
Available Queries
1. summary_by_month
Returns monthly delivery summary with total orders, revenue, and delivery status breakdown.Output: Table with Month, TotalOrders, TotalRevenue, Delivered, Pending, Cancelled columns
2. monthly_comparison
Compare delivery performance between two months.Input: Month1 (YYYY-MM), Month2 (YYYY-MM) Output: Side-by-side comparison table
3. quarterly_report
Generate comprehensive quarterly delivery report with trends.Input: Year (YYYY), Quarter (1-4) Output: Detailed report with weekly breakdown
4. summary_by_year
Annual delivery summary with year-over-year growth metrics.Input: Year (YYYY) Output: Annual statistics and growth indicators
Usage
Run from command line: ```bash python query.py summary_by_month python query.py monthly_comparison 2025-01 2025-02 python query.py quarterly_report 2025 1 python query.py summary_by_year 2025
π‘ Examples
Run from command line: ```bash python query.py summary_by_month python query.py monthly_comparison 2025-01 2025-02 python query.py quarterly_report 2025 1 python query.py summary_by_year 2025
βοΈ Configuration
1. Python 3.8+ installed
2. pyodbc library installed: pip install pyodbc
3. ODBC Driver 17 for SQL Server installed on Windows
4. Network access to LTEDP056 server on port 1433