Stripe provides https://stripe.com/sigma which allows users to write their own SQL. If you had a multi-tenant Postgres DB, how would you build a system such as Stripe Sigma? Where each tenant can only query their own data obviously. Thanks for any recommendations! More notes that could be helpful: - dozens of tables. - Source: Hacker News / 10 months ago

We're currently grappling with trying to build a system similar to https://stripe.com/sigma with a single multi-tenant Postgres db as the source and an SQLite read replica per tenant. Currently we re-generate the world every night. We need fine-grained control over the SQLite schema (it's a public api we let users write sql against). Any related projects would be great to point me towards! - Source: Hacker News / 10 months ago

Https://stripe.com/sigma lets you create custom reports (but on extra costs) and schedule them. Source: almost 2 years ago

Stripe Sigma allows you to build custom queries using SQL and comes up with some very helpful report templates with some important exceptions like Monthly Recurring Revenue (MRR). - Source: dev.to / over 2 years ago

Hi we want to decrease our cost of saas tools and thinking of buying saas manmagement platform. Short list is zylo and torri. https://zylo.com. - Source: Hacker News / about 1 year ago

Something similar to this already exists. Source: almost 2 years ago

It's also called "SaaS management" or "software asset management" e.g. zylo.com bettercloud.com or blissfully.com. Source: over 2 years ago

I'm coming from the perspective of a smaller-medium sized business, so something really comprehensive/expensive like Zylo or Bettercloud might be overkill or simply not affordable unless you are enterprise-sized. For bigger companies though, it's the perfect solution and there are a lot of helpful features for big orgs. Source: over 2 years ago