sql-reports

SKILL.md

# 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

- **Server:** LTEDP056\SQLEXPRESS
- **Port:** 1433
- **Database:** DeliveryDB
- **Driver:** ODBC Driver 17 for SQL Server

## 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