Pricing

Rating

Developer

Actor stats

Categories

Share

🚀 Supabase Automation Toolkit

Powerful automation tools for Supabase - Automate database operations, user management, storage cleanup, and data exports with a simple, pay-per-use Actor.

👁 Apify Store
👁 License: MIT
👁 TypeScript

✨ Features

• 📊 Data Export: Export tables to CSV, JSON, or Excel formats
• 🔍 Advanced Queries: Filter, sort, and aggregate your data
• 👥 User Management: Bulk user operations (cleanup, export, updates)
• 🗑️ Storage Cleanup: Delete old files, unused assets, batch operations
• 📦 Automated Backups: Schedule regular database backups
• 📈 Analytics Reports: Generate custom reports from your data
• ⏰ Scheduled Runs: Set up recurring automation tasks
• 🔒 Secure: Uses your Supabase credentials with RLS support

🎯 Use Cases

1. 📊 Daily Data Exports

Export your users table to CSV every night for analytics:

{
"task":"export_data",
"table":"users",
"format":"csv",
"filters":{
"created_at":"last_24_hours"
}
}

2. 🗑️ Clean Up Old Data

Remove inactive users automatically:

{
"task":"cleanup_users",
"inactiveDays":90,
"confirmDelete":true
}

3. 📦 Backup Database

Create daily backups of critical tables:

{
"task":"backup_tables",
"tables":["users","orders","products"],
"destination":"storage"
}

4. 📈 Generate Reports

Create weekly analytics reports:

{
"task":"generate_report",
"reportType":"user_growth",
"period":"last_7_days"
}

5. 🧹 Storage Maintenance

Clean up unused files older than 30 days:

{
"task":"cleanup_storage",
"bucket":"avatars",
"olderThanDays":30
}

🚀 Quick Start

Prerequisites

• A Supabase project (Create one free)
• Apify account (Sign up free)

1. Get Your Supabase Credentials

From your Supabase Dashboard:

# Project Settings > API
SUPABASE_URL=https://xxx.supabase.co
SUPABASE_KEY=your-anon-or-service-role-key

Note: Use service role key for admin operations (user management, bypassing RLS).

📖 Available Tasks

🗄️ Data Tasks

export_data

Export table data to various formats (CSV, JSON, Excel).

Input:

{
"task":"export_data",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"table":"users",
"format":"csv",
"columns":["id","email","created_at"],
"filters":{
"created_at":"last_7_days",
"status":"active"
},
"limit":10000
}

Output: Dataset with exported records

query_data

Execute custom queries with advanced filtering.

Input:

{
"task":"query_data",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"table":"orders",
"select":"*, users(email)",
"filters":[
{"column":"total","operator":"gt","value":100},
{"column":"status","operator":"eq","value":"completed"}
],
"orderBy":"created_at",
"orderDirection":"desc"
}

👥 User Management Tasks

export_users

Export all users with their metadata.

Input:

{
"task":"export_users",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-service-role-key",
"format":"csv",
"includeMetadata":true
}

cleanup_users

Remove inactive or unverified users.

Input:

{
"task":"cleanup_users",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-service-role-key",
"criteria":"unverified",
"olderThanDays":30,
"dryRun":true
}

Note: Set dryRun: false to actually delete users.

📦 Storage Tasks

cleanup_storage

Delete old or unused files from storage buckets.

Input:

{
"task":"cleanup_storage",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"bucket":"avatars",
"olderThanDays":90,
"pattern":"*.tmp",
"dryRun":true
}

list_storage

List all files in a bucket with metadata.

Input:

{
"task":"list_storage",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"bucket":"documents",
"path":"2024/",
"includeMetadata":true
}

🔍 Schema Tasks

analyze_schema

Get complete database schema information.

Input:

{
"task":"analyze_schema",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"includeSizes":true,
"includeIndexes":true
}

table_stats

Get statistics for specific tables.

Input:

{
"task":"table_stats",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"tables":["users","orders","products"]
}

📦 Backup Tasks

backup_database

Create full or partial database backups.

Input:

{
"task":"backup_database",
"supabaseUrl":"https://xxx.supabase.co",
"supabaseKey":"your-key",
"tables":["users","orders"],
"format":"json",
"compress":true
}

💰 Pricing

Simple pay-per-use pricing:

Example costs:

• Export 10,000 users = $0.10
• Daily backups (3 tables) = $0.30
• Clean 5,000 old files = $0.10
• Monthly automation ≈ $5-20

🔧 Advanced Configuration

Scheduling Runs

Set up recurring automation in Apify Console:

{
"schedule":{
"cron":"0 2 * * *",
"timezone":"UTC"
},
"task":"export_data",
"table":"users",
"format":"csv"
}

Common schedules:

• Daily at 2 AM: 0 2 * * *
• Every hour: 0 * * * *
• Weekly (Monday 9 AM): 0 9 * * 1
• Monthly (1st day): 0 0 1 * *

Output Options

Save to Dataset:

{
"outputTo":"dataset"
}

Save to Key-Value Store:

{
"outputTo":"kvstore",
"key":"backup-2025-01-01"
}

Webhook Notification:

{
"webhook":"https://your-app.com/webhook",
"notifyOnComplete":true
}

🛡️ Security Best Practices

1. Use Service Role Key for Admin Tasks

{
"supabaseKey":"your-service-role-key"
}

2. Enable Dry Run First

{
"task":"cleanup_users",
"dryRun":true
}

3. Set Up Alerts

• Monitor failed runs
• Track unusual activity
• Set spending limits

4. Use Read-Only Keys When Possible

For exports and analytics, use anon key with RLS policies.

📊 Output Examples

CSV Export

id,email,created_at,status
1,user1@example.com,2025-01-01,active
2,user2@example.com,2025-01-02,active

JSON Export

{
"success":true,
"recordsExported":150,
"table":"users",
"executedAt":"2025-01-01T10:00:00Z",
"data":[...]
}

Analytics Report

{
"reportType":"user_growth",
"period":"last_7_days",
"metrics":{
"newUsers":45,
"activeUsers":320,
"churnRate":2.3
}
}

🐛 Troubleshooting

Common Issues

1. "Permission denied"

• Use service role key for admin operations
• Check RLS policies on tables

2. "Table not found"

• Verify table name spelling
• Check schema (default is public)

3. "Rate limit exceeded"

• Reduce batch size
• Add delays between operations

4. "Connection timeout"

• Check Supabase project status
• Verify network connectivity

🔄 Migration from Other Tools

From Manual Scripts

// Before: Manual script
const{ data }=await supabase.from('users').select('*');
fs.writeFileSync('users.csv',convertToCSV(data));
// After: Apify Actor
{
"task":"export_data",
"table":"users",
"format":"csv"
}

From Cron Jobs

# Before: Crontab
02 * * * node backup-script.js
# After: Apify Schedule
Schedule Actor run daily at 2 AM

🤝 Support & Community

• 📧 Email: support@your-domain.com
• 💬 Discord: Join Apify Community
• 🐛 Issues: Report bugs via Apify Console
• 📖 Docs: Full Documentation

🎓 Tutorials

Tutorial 1: Daily User Export

1. Create Actor run
2. Configure task: export_data
3. Set schedule: Daily 2 AM
4. Connect to Google Sheets (optional)

Tutorial 2: Cleanup Old Data

1. Test with dryRun: true
2. Review what would be deleted
3. Run with dryRun: false
4. Schedule monthly

Tutorial 3: Automated Backups

1. Select tables to backup
2. Choose format (JSON/CSV)
3. Enable compression
4. Schedule weekly runs

🔄 Changelog

Version 1.0.0 (2025-01-01)

• ✨ Initial release
• 📊 Data export (CSV, JSON, Excel)
• 👥 User management automation
• 🗑️ Storage cleanup tools
• 📦 Database backup features
• 📈 Schema analysis
• ⏰ Schedule support

📄 License

MIT License - see LICENSE file for details.

🌟 Show Your Support

If this Actor helps you, please:

• ⭐ Star on Apify Store
• 📣 Share with your network
• 💬 Leave feedback and suggestions
• 🐛 Report issues to help us improve

🙏 Built With

• Apify SDK - Actor framework
• Supabase JS - Database client
• TypeScript - Type safety

Built by Ali Dhiba with ❤️ for the automation community

Automate your Supabase workflows and save hours every week 🚀