Supabase Database Credentials - Quick Reference

Status: Active Last Updated: 2025-11-10 Related Docs: Supabase Setup, Database Schema Code Location: N/A (Reference data)

For use during Supabase configuration

Your Supabase Databases

Staging Database

• Name: epgoat-events-staging
• UUID: cc27ed8b-6149-4e73-af19-50716cc7936c
• Size: 2.15 MB (2,150,400 bytes)
• Tables: 28 tables
• Use for: Development and testing

Production Database

• Name: epgoat-events-prod
• UUID: 7abdb16c-1283-4bb9-a1df-f54dccee3c5c
• Size: 12 KB (12,288 bytes)
• Tables: 0 tables (not yet populated)
• Use for: Production EPG generation

Database Connection Details

See Supabase Setup for full connection instructions.

Connection Strings

• Staging: See .env file for SUPABASE_URL and SUPABASE_KEY
• Production: Managed via environment variables in production

Current Data Snapshot

Staging Database: - 2,782 total events - Date range: 2025-10-30 to 2025-11-13 - Sports covered: American Football, Baseball, Basketball, Fighting, Ice Hockey, Golf, etc.

Production Database: - Empty (0 events) - Ready to populate when production pipeline runs

Quick Start URLs

1. Supabase Dashboard:
2. https://supabase.com/dashboard

3. Project: epgoat-events

4. Database Tools:

5. SQL Editor: Supabase Dashboard → SQL Editor
6. Table Editor: Supabase Dashboard → Table Editor

Sample Queries to Try

Once deployed, test with these queries:

1. View Today's Events

SELECT * FROM events
WHERE event_date = date('now')
LIMIT 100

2. Count Events by Sport

SELECT sport, COUNT(*) as count
FROM events
GROUP BY sport
ORDER BY count DESC

3. Recent Events (Last 7 Days)

SELECT event_date, sport, event_name
FROM events
WHERE event_date >= date('now', '-7 days')
ORDER BY event_date DESC
LIMIT 50

4. Example Use Cases

• View today's sports events
• Count events by sport or date
• Search for specific teams or events

Ready to go? See Supabase Setup for full setup instructions.