Supabase MCP ⇄ Cursor IDE Studio

Supabase Cloud Platform

project_ref: pr-fintech-prod-8821

● Live Cloud Session

Production Database Cluster

PostgreSQL 15.6 • RLS Active • SSL Required

Active Tables

Primary Schema

public

MCP Server Status

Ready (SSE)

Table: public.credit_products (16 rows) RLS: ENABLED

This PostgreSQL table holds credit product records (id, category, icon, title, apr, min_credit_score, etc.). Once Cursor connects to MCP, the AI agent can introspect this schema autonomously!

Options

Read-only

Feature Groups All features except Storage enabled

Server URL

Client

Cursor ▾

Configure your MCP client to connect with your Supabase project

Installation Install in one click: Or add this configuration to .cursor/mcp.json :

{
  "mcpServers": {
    "supabase": {
      "url": "https://mcp.supabase.com/mcp?project_ref=pr-fintech-prod-8821"
    }
  }
}

Cursor IDE — AI Agent & Settings

Tools & MCP • Agent Composer

Tools

Browser

Browser Automation

Ready (Chrome detected)

Google Chrome ▾

Installed MCP Servers ● 1 Server Connected

supabase

20 tools enabled

Database table schema request

Now • Auto

can you show me the scheme of the tabes in the database

Thought 2s

✓ Ran list_tables:supabase Run Everything ▾

schemas [ "public" ]

Thought 1s

Here's the schema of the tables in your database:

1. credit_products

RLS: enabled
Primary key: id
Row count: 16

Column	Type	Nullable	Default / Notes
id	uuid	No	gen_random_uuid()
category	text	No	Check 'personal' \| 'business'
icon	text	No	'lucide:credit-card'
title	text	No	—
apr	numeric	No	—
min_credit_score	integer	No	600
created_at	timestamptz	No	now()

CLIENT ➔ MCP {"jsonrpc":"2.0","method":"initialize","params":{"protocolVersion":"2024-11-05","clientInfo":{"name":"Cursor","version":"0.46.2"}}}

MCP ➔ CLIENT {"jsonrpc":"2.0","result":{"protocolVersion":"2024-11-05","capabilities":{"tools":{"listChanged":true}},"serverInfo":{"name":"supabase-remote-mcp","version":"1.4.0"}}}

CLIENT ➔ MCP {"jsonrpc":"2.0","method":"tools/list","params":{}}

MCP ➔ CLIENT {"jsonrpc":"2.0","result":{"tools":[{"name":"list_tables"},{"name":"execute_sql"},{"name":"get_table_schema"},"...17 more"]}}

CLIENT ➔ MCP {"jsonrpc":"2.0","method":"tools/call","params":{"name":"list_tables","arguments":{"schemas":["public"]}}}

MCP ➔ CLIENT {"jsonrpc":"2.0","result":{"content":[{"type":"text","text":"[{\"name\":\"credit_products\",\"rls\":true,\"rows\":16}]"}]}}