Avanti Data Assistant

Avanti Fellows' own data, in Claude. For Avanti staff.

Ask a question about our students, programmes, results or fundraising in plain English. Claude finds the right tables, writes the SQL, runs it, and tells you which academic year the answer covers. No BigQuery account, nothing to install.

Add it to Claude

Do this on a computer - claude.ai in a browser, or the Claude desktop app. Connectors are set up there, not in the phone app. Which of the two routes below applies depends on whether your Claude account sits inside Avanti's workspace, not on which email address you use.

If your Claude account is in the Avanti workspace

Most people. It is already added for the whole organisation, so there is nothing to paste.

1

Connect

Go to Settings → Connectors, find Avanti Data Assistant in the list, and click Connect. Sign in with your Avanti Google account and approve.

Avanti Data Assistant Avanti Fellows Connect Google asks you to sign in and approve. Then open a new chat and ask: “what can you see?”
Click Connect, then sign in with your Avanti Google account
2

Ask it what it can see

Start a new chat and ask "what can you see?". It will introduce itself, list what it has access to, and explain how to ask well.

If you have an Avanti email but pay for Claude yourself

Some of us are on a personal Pro or Max account rather than the Avanti workspace. The connector will not appear in your list, so you add it once yourself. You still sign in with your Avanti Google account - that is what grants access, not where the subscription sits. Custom connectors are not available on Free.

1

Add it as a custom connector

Settings → Connectors, then + Add custom connector. Paste the address above and click Add. Leave everything under Advanced settings empty - the server registers Claude automatically, so there is no client ID or secret to enter.

Settings Profile Connectors Appearance Connectors Your existing connectors + Add custom connector
Settings → Connectors, then “Add custom connector”
2

Connect and sign in

Click Connect, then sign in with your Avanti Google account. A personal Google account is refused at this step, which is the most common way this goes wrong.

3

Ask it what it can see

New chat, "what can you see?", then a real question.

If the tools look out of date, reconnect. Your client caches each tool's description from when you connected. New tools appear on their own, but reworded ones do not - disconnect and reconnect in Settings → Connectors and they refresh.

What it is good at

Student dataEnrolment, attendance, test results, JEE and NEET outcomes, alumni
Public dataAdmission cutoffs, college and school registries, national household surveys
FundraisingOur funder pipeline and past applications, for the team that works on them
WritingAvanti's house voice, cleared figures, and the slide master, so a draft starts on brand

What it will refuse

It only runs read-only queries, and only against tables the data team has documented. Ask it for an undocumented table and it will say so and stop rather than guess at the columns. That refusal is the feature - a plausible answer off the wrong table is worse than no answer.

Every query is logged against the Google account that ran it. Access is limited to Avanti accounts; anyone else is refused at sign-in.