SOLUTIONS · PRODUCT AND TECH
Your code, your data and your app reviews, in your AI
Code, database, Redash queries, store reviews, subscriptions, logs: each tool is connected once, without credentials for every member.
An incident, a metric that drops, a campaign to compare: the assistant cross-checks the sources and cites what it read.
Have payment errors gone up since last night? If so, which deployment lines up?
Yes: 214 failed payments since 9 pm, against about forty over the same period the day before. The rise starts at 9:08 pm, two minutes after the api-payments application was deployed. From that time, the logs show a timeout error towards the payment provider.
Sources consulted
- PostgreSQL · payments table · read
- Clever Cloud · api-payments · deployments and logs
ACCESS
Everyone only sees what concerns them
Chosen tables
A PostgreSQL database is opened table by table. The rest of the schema does not exist for the assistant.
Approved queries
On Redash, the assistant only reads the queries an administrator opened, with no free SQL.
Hosting without the console
Clever Cloud deployments, logs and metrics are read per application, with no access to the console or to secrets.
SETUP
Up and running in three steps
Connect the sources
An administrator connects PostgreSQL, Redash, Purchasely or Clever Cloud once. Credentials are encrypted and never shown to members.
Open them to each team
They pick the tables, queries and applications opened to each team. The rest is invisible to that team's assistant.
Ask the question
The member queries their sources from their assistant, for instance to read a database read-only, explain an MRR drop or understand a production incident.
CONNECTORS
The connected tools
GitHub
Search, file reads and Git history of the repositories open to each team, read-only; synced about every 10 minutes.
Open the pagePostgreSQL
Read-only SELECT queries on the tables opened to each team; allowed schema provided to the assistant; 200 rows and 60 seconds per query.
Open the pageGoogle Play
Search, listing and statistics of the Google Play reviews of the apps open to each team, read-only; refreshed every 6 hours.
Open the pagePurchasely
Revenue, subscribers, paywall conversion, flows, campaigns, A/B tests and surveys of the apps open to each team, queried live, read-only.
Open the pageClever Cloud
Applications, deployments, logs filtered by period and metrics; per authorised application, with no Clever Cloud account for the person asking.
Open the pageGitLab
Search, file reads and Git history of the gitlab.com projects open to each team, read-only; synced about every 10 minutes.
Open the pageClickHouse
Read-only SELECT queries on the ClickHouse tables opened to each team; 200 rows and 60 seconds per query.
Open the pageApp Store Connect
Search, listing and statistics of the App Store reviews of the apps open to each team, full history, read-only; refreshed every 6 hours.
Open the pageRedash
Results of approved Redash queries, guarded parameterized execution, no free-form SQL; a query opened to one team, the others invisible.
Open the pageGoogle Search Console
Clicks, impressions, CTR and positions by query, page, country or device; period comparison; URL inspection; sitemap status.
Open the pageBatch
Batch orchestrations (campaigns, recurring, triggered) on push, email, in-app and SMS; daily statistics on sends, opens, clicks and conversions.
Open the page
IN PRACTICE
Use cases, step by step
- Google Play
- App Store Connect
Understand negative reviews after an app update, with ChatGPT or Claude
Since version 4.2, our rating is dropping. What’s wrong, on Android and iPhone?
Read- PostgreSQL
Give your team read-only PostgreSQL access from ChatGPT or Claude
How many new subscribers this week, and how many cancellations?
Read- Purchasely
- Google Play
- App Store Connect
Explain a drop in in-app subscription MRR with ChatGPT or Claude
MRR dropped 6% in October. Where does the drop come from?
Read- Clever Cloud
Understand a Clever Cloud production incident with Claude or ChatGPT
Customers report payment errors since 9 am. What happened on the API?
Read- Purchasely
Read the results of a Purchasely paywall A/B test with ChatGPT or Claude
On the “Annual onboarding” A/B test, which variant wins, and does it hold on Android?
Read- Google Play
- App Store Connect
Prepare the monthly App Store and Google Play review summary with ChatGPT or Claude
Summarize October’s reviews for both our apps, compared with September.
Read- Google Search Console
Find the pages losing clicks in Search Console, with Claude or ChatGPT
Which pages lost the most clicks this month compared with last month, and why?
Read- Batch
Compare your Batch push and email campaigns with Claude or ChatGPT
Which push campaign performed best this month, and which one drove away the most subscribers?
Read
Questions
Frequently asked questions
Do we have to give credentials to every member?
No. An administrator connects the database, Redash or Clever Cloud once; members query what is opened to them, without credentials.
Can the assistant write to the database?
No. Only bounded SELECT queries run: 200 rows and 60 seconds per query, no writes.
What about the app’s subscriptions?
Purchasely connects with a read-only key: revenue, subscribers, paywall conversion and A/B tests are read per app, with no Purchasely account for each member.
What about source code?
GitHub and GitLab connect too: the assistant reads the synced repository, without cloning it, with the same rights per team.
