If your project is growing and you want to make sure it doesn't break
here's a list of resources you can use to avoid scaling issues. You can feed these into LLMs to help you find optimizations.

Start by checking the size of your DB today and estimate when you'll run into issues based on your growth rate.

After that, make sure you have index advisor on and use the Query Performance page to optimize your heavy queries.

Resources

https://supabase.com/docs/guides/deployment/going-into-prod

https://supabase.com/docs/guides/database/connection-management

https://supabase.com/docs/guides/platform/read-replicas

https://supabase.com/docs/guides/database/query-optimization

https://supabase.com/docs/guides/database/inspect

https://supabase.com/docs/guides/database/debugging-performance

https://supabase.com/docs/guides/database/extensions/index_advisor

https://supabase.com/docs/guides/troubleshooting/rls-performance-and-best-practices-Z5Jjwv

https://supabase.com/docs/guides/platform/performance