#!/bin/bash
DB_FILE="/root/.openclaw/workspace/projects/ai_usecase_collector/data/ai_usecases.db"
sqlite3 $DB_FILE <<EOF
CREATE TABLE IF NOT EXISTS use_cases (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    description TEXT,
    industry TEXT,
    source TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO use_cases (name, description, industry, source) VALUES
('Customer Service Automation', 'AI agents handle ticket routing, case management, and knowledge base automation, with the capability to scale dramatically during emergencies.', 'Customer Service', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Sales and Marketing Automation', 'Agents perform lead scoring, pipeline management, campaign automation, and customer segmentation.', 'Sales & Marketing', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Supply Chain Optimization', 'Agents monitor inventory, predict demand, reorder products automatically, optimize delivery routes, and manage warehouse operations.', 'Supply Chain', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('HR Automation', 'These agents screen resumes, schedule interviews, send candidate communications, administer benefits, automate onboarding workflows, and track PTO.', 'Human Resources', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('IT & Security Operations', 'Applications include network monitoring, threat detection, automated incident response, vulnerability scanning, VPN troubleshooting, device monitoring, and incident detection.', 'IT & Security', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Financial Services Agents', 'JPMorgan Chase''s Coach AI enables advisors to respond 95% faster during market volatility, while financial trading agents analyze market data and execute trades based on performance.', 'Financial Services', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Healthcare Agents', 'Agents monitor patient vitals, assist with scheduling, improve automated note-taking during patient visits, and analyze medical reports to provide health insights.', 'Healthcare', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Manufacturing Automation', 'Ford uses AI-driven predictive maintenance alerts, GM deploys AI-powered robotics that adapt to production schedule changes, and Toyota handles in-vehicle voice commands.', 'Manufacturing', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Retail Agents', 'Walmart operates multiple specialized agents—Marty for suppliers, Sparky for shoppers, and an Associate Agent—with AI inventory systems managing real-time stock during peak shopping.', 'Retail', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Public Sector AI', 'The U.S. Patent Office uses AI-powered search systems, Veterans Affairs automates medical imaging, and federal agencies doubled AI use cases from 571 to 1,110 between 2023-2024.', 'Public Sector', 'https://boomi.com/blog/10-agentic-ai-use-cases/'),
('Legal Document Automation', 'AI agents assist in drafting and assembling legal documents such as visa applications, streamlining processes for law firms and clients.', 'Legal', 'https://www.microsoft.com/en-us/microsoft-copilot/copilot-101/ai-agents-types-and-uses');
EOF