Is there a way to get an n8n agent to call/chat with two separate supabase tables?

Sure, why not. You can connect many tools to AI Agent.