# Supabase API
> On-demand Postgres databases via Supabase Management API. All endpoints POST. Pay per request with x402/MPP. Wallet-based access control — you can only see and manage databases you created.

## Base URL
https://supabase-api.dev

## Auth
x402/MPP payment (USDC on Base, Solana, or Tempo). Your wallet identity determines which projects you can access.

---

## Projects — Database Provisioning

### Create a database ($1.00)
/api/supabase/projects/create — Provision a new Postgres database
Example: POST /api/supabase/projects/create { "name": "my-agent-db", "db_pass": "securepass123", "region": "us-east-1" }
Returns project ref and Postgres connection URL. The paying wallet becomes the owner.

### List your projects ($0.01)
/api/supabase/projects/list — List all projects owned by your wallet
Example: POST /api/supabase/projects/list {}

### Get project details ($0.01)
/api/supabase/projects/get — Get full project details including status, region, and endpoints
Example: POST /api/supabase/projects/get { "ref": "abcdefghijklmnop" }

### Pause a project ($0.01)
/api/supabase/projects/pause — Pause a running project (stops compute, preserves data)
Example: POST /api/supabase/projects/pause { "ref": "abcdefghijklmnop" }

### Restore a project ($0.01)
/api/supabase/projects/restore — Restore a paused project
Example: POST /api/supabase/projects/restore { "ref": "abcdefghijklmnop" }

### Delete a project ($0.05)
/api/supabase/projects/delete — Permanently delete a project and its data
Example: POST /api/supabase/projects/delete { "ref": "abcdefghijklmnop" }

### Project health ($0.01)
/api/supabase/projects/health — Check service health for a project
Example: POST /api/supabase/projects/health { "ref": "abcdefghijklmnop" }

---

## Database — Query & Types

### Run SQL query ($0.02)
/api/supabase/database/query — Execute a SQL query against a project's database
Example: POST /api/supabase/database/query { "ref": "abcdefghijklmnop", "query": "SELECT * FROM users LIMIT 10" }

### Generate TypeScript types ($0.01)
/api/supabase/database/types — Generate TypeScript types from database schema
Example: POST /api/supabase/database/types { "ref": "abcdefghijklmnop" }

---

## Lifecycle

1. Agent calls POST /api/supabase/projects/create (paid) — gets a Postgres connection URL.
2. Agent queries the database via POST /api/supabase/database/query or directly via the connection URL.
3. When done, pause with POST /api/supabase/projects/pause to stop compute costs.
4. Resume anytime with POST /api/supabase/projects/restore.

## Access Control
All project operations are scoped to the wallet that created the project. You cannot see, query, pause, or delete projects owned by other wallets.