Mothership SDK Testing Guide
Complete setup and testing for Supabase-powered game integration
Purpose: This guide helps you test the Mothership SDK as if you were an external game developer. You'll set up your own Supabase instance, create API credentials, and verify the integration works securely.
1. Run SQL Migration
Open your Supabase dashboard → snappy-english-prod
Go to SQL Editor (left sidebar)
Click 'New query'
Copy the SQL from components/docs/SUPABASE_GAME_MIGRATION.sql
Paste and click 'Run'
Verify: You should see constraint and index counts > 0
-- Verification Query
SELECT
'TransactionHistory' as table_name,
COUNT(*) as constraint_count
FROM information_schema.table_constraints
WHERE table_name = 'TransactionHistory'
AND constraint_name = 'unique_level_completion'
UNION ALL
SELECT
'Indexes' as table_name,
COUNT(*) as index_count
FROM pg_indexes
WHERE tablename = 'TransactionHistory';2. Create Your Developer Credentials
3. Test the API Endpoint
4. Verify Data in Supabase
5. Test Security Features
Ready for Production
Once you've completed all steps successfully, external game developers can:
- Register their games through GameDeveloperOnboarding page
- Get their own game_id and secret_key
- Integrate the Mothership SDK into their games
- Earn pearls for their players through secure API calls
Your Snappy Idioms ecosystem is now ready to scale with third-party game developers! 🎮