mcps
S P

Recipe

Analysts exploring data with Supabase + PostgreSQL MCP

Skip the SQL client. Ask product questions in plain English; get charts, insights, and ad-hoc reports.

for Founders and analysts who want answers without writing SQL

Hand-checked recipe · curated by Ilya Gindin

20 minutes

to run

intermediate

difficulty

2

connectors

What you'll need

Supabase Read-only access to your Supabase project's tables and views.
Optional
PostgreSQL Direct PostgreSQL connection for non-Supabase databases.
Optional

This recipe runs in 4 steps

  1. 1

    Connect your database

    Say to your AI

    Install Supabase MCP or PostgreSQL MCP with your connection details.

    You'll get: Claude confirms it can list tables in your database.

  2. 2

    Explore the schema

    Say to your AI

    Describe the structure of my database — what tables do I have and how are they related?

    You'll get: An overview of tables, primary keys, and foreign-key relationships, grouped by domain.

  3. 3

    Ask business questions

    Say to your AI

    How many users signed up this week, and how does that compare to last week? Show a day-by-day breakdown.

    You'll get: A small table with daily counts and a one-line interpretation of the change.

  4. 4

    Get AI-written reports

    Say to your AI

    Write me a weekly business metrics summary based on my users and orders tables.

    You'll get: A short Markdown report with metrics, deltas, and one-paragraph commentary.

You're done when

Database insights without SQL knowledge — perfect for founders and analysts shipping reports without engineering help.

Why this workflow exists

The gap between “I have a question about my product” and “I have a query that answers it” is usually a person, a Slack message, and a wait. Database MCP collapses that to one chat turn for the questions that don’t need a real analyst.

Use either Supabase MCP (managed projects) or PostgreSQL MCP (anything else). Both work the same way from the user’s perspective.

If something breaks

Queries time out on large tables
Fix: Ask Claude to add LIMIT or to filter on indexed columns. For Supabase, use the read replica connection string.
Permission denied on a table
Fix: Most MCP database servers connect as a single role. Make sure the role has SELECT on the schemas you want to query.