Database Commands

tiktok-miner query-db [sql] [options]

-- Main creator profile table
SELECT * FROM "CreatorProfile" 
WHERE name LIKE '%TechGuru%' 
LIMIT 10;

-- TikTok metrics for a creator
SELECT * FROM "TiktokMetrics" 
WHERE username = 'techguru';

-- Instagram metrics
SELECT * FROM "InstagramMetrics"
WHERE username = 'techguru';

-- Historical metrics over time
SELECT * FROM "CreatorMetricsHistory"
WHERE "creatorProfileId" = '<creator-id>'
ORDER BY timestamp DESC
LIMIT 30;

tiktok-miner query-db "SELECT id, name, platform FROM \"CreatorProfile\" LIMIT 10"

tiktok-miner query-db "SELECT username, \"followerCount\", \"engagementRate\" FROM \"TiktokProfile\" ORDER BY \"followerCount\" DESC LIMIT 20"

tiktok-miner query-db "SELECT \"creatorProfileId\", \"hourlyLikes\", \"hourlyComments\", \"peakEngagementHour\" FROM \"EngagementAnalytics\" WHERE timestamp > NOW() - INTERVAL '7 days'"

tiktok-miner query-db "SELECT platform, \"costAmount\", \"costDate\" FROM \"CostAllocation\" WHERE \"costDate\" > NOW() - INTERVAL '30 days' ORDER BY \"costDate\" DESC"

SELECT 
  cp.name,
  cp."totalReach",
  cp."averageEngagementRate",
  cp."compositeEngagementScore"
FROM "CreatorProfile" cp
WHERE cp."averageEngagementRate" > 5.0
ORDER BY cp."compositeEngagementScore" DESC
LIMIT 20;

SELECT 
  platform,
  COUNT(*) as creator_count,
  AVG("followerCount") as avg_followers
FROM "CreatorProfile"
GROUP BY platform;

SELECT 
  name,
  platform,
  "totalReach",
  "createdAt"
FROM "CreatorProfile"
WHERE "createdAt" > NOW() - INTERVAL '7 days'
ORDER BY "createdAt" DESC;

SELECT 
  name,
  "budgetType",
  "totalAmount",
  "spentAmount",
  "remainingAmount",
  status
FROM "Budget"
WHERE status = 'ACTIVE';