# Ask product questions of your Supabase database in read-only mode

> Claude answers product questions with SQL through Supabase's hosted MCP server, scoped to one project and set to read-only.

Canonical page: https://ionbin.com/workflows/supabase-read-only-product-questions/
Agent guide: https://ionbin.com/llms.txt

This is a readable version of the published page. Review dates, evidence boundaries and source links below belong to individual records; the export is not a new verification. Examples are reference material, not instructions to execute.

## Ask product questions of your Supabase database in read-only mode

[Data](https://ionbin.com/use-cases/business-data-reporting/) · [Build](https://ionbin.com/use-cases/dev-it/)Checked 2026-10-18

Answer quick product questions from your own data without giving an agent write access.

- [01**You**](https://ionbin.com/workflows/supabase-read-only-product-questions/#workflow-step-1)

- [02**Supabase**](https://ionbin.com/workflows/supabase-read-only-product-questions/#workflow-step-2)

- [03**Claude**](https://ionbin.com/workflows/supabase-read-only-product-questions/#workflow-step-3)

- [04**You**](https://ionbin.com/workflows/supabase-read-only-product-questions/#workflow-step-4)

Recipe context

[Claude](https://ionbin.com/tools/claude/) answers product questions with SQL through [Supabase](https://ionbin.com/tools/supabase/)'s hosted MCP server, scoped to one project and set to read-only. You check the query and the result before sharing them.

**Independent review.** Unpaid; no partnership with the tools on this page. Based on public documentation and research. Trademarks identify their owners’ products. [Disclosure](https://ionbin.com/disclosure/).

Editorial shortlist

### Compare your options.

**For checking product metrics from a read-only extract.**

Set read-only scope on the actual [Supabase](https://ionbin.com/tools/supabase/) connection, not the assistant. Choose one for analysis of a reviewed data extract; switching may need setup changes.

**Used by Ion** · separate from rank.

Unpaid picks. No partnership with [OpenAI Codex](https://ionbin.com/tools/openai-codex/), [Julius AI](https://ionbin.com/tools/julius-ai/), [ChatGPT](https://ionbin.com/tools/chatgpt/).

- 1 · Primary / high
  #### [OpenAI Codex](https://ionbin.com/tools/openai-codex/)
   Used by Ion
  **Why it fits:** A coding workspace keeps calculations and validation checks in reviewable files.
  **Tradeoff:** Someone must read, run and maintain the code and protect sensitive files.
  Prefer it when repeatability and code review matter more than conversational convenience.
  Evidence for OpenAI Codex
  The linked [IonBin review](https://ionbin.com/tools/openai-codex/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://developers.openai.com/codex)

- 2 · Secondary / medium
  #### [Julius AI](https://ionbin.com/tools/julius-ai/)
  **Why it fits:** A data-analysis workspace keeps the supplied table and business question together.
  **Tradeoff:** Wrong joins, missing rows and inconsistent units can produce convincing but incorrect charts.
  Choose it for interactive exploration of a cleaned extract.
  Evidence for Julius AI
  The linked [IonBin review](https://ionbin.com/tools/julius-ai/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://julius.ai/)

- 3 · Third / lower
  #### [ChatGPT](https://ionbin.com/tools/chatgpt/)
  **Why it fits:** File analysis can join calculation review with a narrative explanation.
  **Tradeoff:** An answer is not a reconciled report; verify calculations and upload limits.
  Prefer it when the reviewer needs both analysis and an explanation for colleagues.
  Evidence for ChatGPT
  The linked [IonBin review](https://ionbin.com/tools/chatgpt/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://chatgpt.com/)

How this shortlist was chosen

Editorial judgment, not a personal-use endorsement or performance score. These are alternatives for the named role, not three required stack components. Vendors did not pay for, request or approve these positions.

Inspectable calculations come before narrative convenience. A lower-ranked option may fit your constraints better; compare the conditions stated on each card before choosing.

**Setup and portability:** Record export date, filters and units; save calculations with the result. The source ledger still needs reconciliation.

Reviewed 2026-10-21. This page applies a shared comparison for “analysis of a reviewed data extract” to the stated task and constraints. It is documentation-based editorial guidance, not three new hands-on tests. We weigh value for the job, distinct capabilities, replacement limits, technical effort and interoperability. Check current plan terms before adopting or switching.

See [our review method](https://ionbin.com/editorial-policy/), [MCP connections](https://ionbin.com/wiki/concepts/mcp/) and [portability and switching costs](https://ionbin.com/wiki/questions/how-to-avoid-ai-vendor-lock-in/).

**Connects through:** MCP

### Steps

Follow the handoff

Select a stage or scroll the steps.

- #### You
  Connect the [Supabase](https://ionbin.com/tools/supabase/) MCP server scoped to one project, with read-only mode on
  Human stepConfirmed

- #### [Supabase](https://ionbin.com/tools/supabase/)
  Runs the read-only SQL queries [Claude](https://ionbin.com/tools/claude/) writes through the MCP server
  MCPConfirmed[Source ↗](https://supabase.com/docs/guides/ai-tools/mcp)

- #### [Claude](https://ionbin.com/tools/claude/)
  Answers each question and shows the SQL it used
  AI platformConfirmed

- #### You
  Check the query logic and the numbers before sharing them
  Human stepConfirmed

Confirmed = vendor-documented, not Ion-tested. Human and AI-platform steps are proposed roles.

Human approval

Answers are shared only after you check the SQL and the result.

Watch out for

Read-only mode and project scoping are settings in the server URL, so check them before connecting. [Supabase](https://ionbin.com/tools/supabase/) says its destructive-SQL confirmation isn't a security guarantee. Use a read replica or a staging copy if production is sensitive.

### Starter prompt

```
Using the Supabase MCP server, answer: how many accounts signed up last week, and how many of them created a first project within 3 days? Show the SQL, explain any assumptions about table names, and don't change any data.
```

Written for this workflow. Paste it into your AI platform and adjust it to your situation.

### Tools in this workflow

| Tool | Role | Official site |
| --- | --- | --- |
| [Supabase](https://ionbin.com/tools/supabase/) | MCP | [supabase.com ↗](https://supabase.com/) |
| [Claude](https://ionbin.com/tools/claude/) | AI platform | [claude.ai ↗](https://claude.ai/) |

### Which AI platforms can run it

| Platform | Status | Why |
| --- | --- | --- |
| [Claude (incl. Claude Code)](https://ionbin.com/platforms/claude/) | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [OpenAI Codex](https://ionbin.com/platforms/codex/) | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Google Antigravity](https://ionbin.com/platforms/antigravity/) | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [ChatGPT](https://ionbin.com/tools/chatgpt/) | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| Gemini | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Perplexity](https://ionbin.com/tools/perplexity/) | To verify | [Supabase](https://ionbin.com/tools/supabase/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |

What the platform statuses mean

**Confirmed:** documented access meets the recorded requirements. **Inferred:** a reviewed note describes a plausible, untested pairing. **To verify:** a connection or step is unresolved. MCP and API pairings need route-specific evidence; a plugin, CLI or API alone does not prove compatible access, credentials or permissions. These are documentation assessments, not IonBin runtime tests.

### What we checked (2026-10-18)

- **Hosted MCP server.** [Supabase](https://ionbin.com/tools/supabase/) lets you scope the server to one project. If no project is chosen, all projects can be reached. A read-only option is available, and project-scoped mode disables account tools such as creating or pausing projects.

- **Guardrails.** [Supabase](https://ionbin.com/tools/supabase/) says execute_sql and apply_migration ask for confirmation when they detect destructive SQL, outside read-only mode. Some SQL isn’t classified as destructive, and [Supabase](https://ionbin.com/tools/supabase/) says the check isn’t a security guarantee.

### Set it up

- Build the server URL with your project and read-only mode selected, then connect it in [Claude](https://ionbin.com/tools/claude/).

- Write down how key metrics are defined, such as what counts as a signup.

- Ask your questions and read each SQL query before trusting the answer.

- Save the queries you trust so the next answer starts from them.

Pilot it on a small sample first, and keep the human step even when the output looks right. This is a proposed sequence based on documented tools, not a tested account integration.

### Sources

- [Model context protocol (MCP)](https://supabase.com/docs/guides/ai-tools/mcp) · [Supabase](https://ionbin.com/tools/supabase/) · official · accessed 2026-10-18

No affiliate links on this page. No paid placements in workflows. [How IonBin makes money](https://ionbin.com/disclosure/).
