mcps

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.

20 minutes intermediate 2 connectors for Founders and analysts who want answers without writing SQL

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

Do this, in order

  1. 1

    Connect your database

    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

    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

    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

    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.