[ckluis]

@yogi - will retool work for non-multi-tenant environments to aggregrate & create tools for the same data from XXX+ databases?

or more simply - can you connect a single "tool" to multiple databases?

[dvdhsu]

You can! If you watch the demo video (https://cdn.tryretool.com/videos/4_minute_demo_4827ae.mp4), you'll see that every query could potentially come from a different datasource. So for example in our GDPR data export tool, we pull in data from Stripe, Salesforce, and a postgres database: https://retool.com/templates/gdpr-data-export/

Also — probably our coolest feature (IMO): you can query anything via SQL, including APIs. So you could query Stripe, Salesforce, etc. via SQL, since all data in Retool is in JSON. AND you can actually join across them too. Imagine joining a Google Sheet with Stripe data with data from your database. It's great fun! https://docs.tryretool.com/docs/querying-via-sql

For example, here's how you query a JSON blob via SQL:

  select
    *
  from
    {{ [{ id: 1, apples: 3 }, { id: 3, apples: 20 }] }}
  where
    apples > 5

And here's how you join data from two separate APIs (that return JSON):

  select
    users.*, payments.*
  from
    {{ usersApi.data }} as users,
    {{ paymentsApi.data }} as payments
  where
    users.id = payments.user_id