client-manager

What problem does it solve?

This Skill centralizes and automates CRUD operations for campaigns, posts, projects, and user preferences stored with Prisma and PostgreSQL, removing manual database work and ensuring consistent validation, relations, and audit logging.

Core Features & Use Cases

• Campaign & Post Management: Create, read, update, delete, list, bulk-create, schedule, and publish campaigns and posts with platform and status validation.
• Analytics & Billing Tracking: Store per-post and campaign analytics JSON, aggregate metrics by platform and date range, and log ApiUsage entries for cost and token accounting.
• Data Integrity & Validation: Enforce required fields, enum constraints, foreign key checks, cascading deletes, and pagination for list endpoints.
• Use Case: A social media manager can bulk-create scheduled posts for a campaign, update content, and later aggregate engagement metrics across platforms for reporting.

Quick Start

Create a new campaign by saying: create campaign named Summer Sale on instagram with description Seasonal promotion and assign it to my account.