> ## Documentation Index
> Fetch the complete documentation index at: https://docs.archal.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Supabase clone

> Test Supabase agents against a stateful clone with real PGlite SQL execution, edge functions, project branching, and organization management.

Clone ID: `supabase`

Covers orgs, projects, database operations, edge functions, and branching. Uses PGlite (embedded Postgres) instead of an in-memory state engine, so SQL execution is real.

## Start here

| Question     | Answer                                                                                                                   |
| ------------ | ------------------------------------------------------------------------------------------------------------------------ |
| Best for     | Agents that run SQL, apply migrations, inspect tables, deploy edge functions, or manage project branches.                |
| Connect with | Route mode for Supabase API domains, direct REST base URLs from `archal clone start supabase`, or MCP tools.             |
| Known limits | SQL execution is real inside PGlite, but hosted infrastructure side effects are simulated.                               |
| Seeds        | Common seeds: `small-project`, `saas-starter`, `ecommerce`, `edge-cases`, `empty`. See [Seeds](/guides/seeds) for usage. |

## Available tools

### Documentation

| Tool          | Description                                     |
| ------------- | ----------------------------------------------- |
| `search_docs` | Search the Supabase documentation using GraphQL |

### Organizations & Projects

| Tool                 | Description                                                  |
| -------------------- | ------------------------------------------------------------ |
| `list_organizations` | Lists all organizations the user is a member of              |
| `get_organization`   | Gets details for an organization including subscription plan |
| `list_projects`      | Lists all Supabase projects for the user                     |
| `get_project`        | Gets details for a Supabase project                          |
| `create_project`     | Creates a new Supabase project                               |
| `pause_project`      | Pauses a Supabase project                                    |
| `restore_project`    | Restores a paused Supabase project                           |

### Cost Management

| Tool           | Description                                         |
| -------------- | --------------------------------------------------- |
| `get_cost`     | Gets the cost of creating a new project or branch   |
| `confirm_cost` | Ask the user to confirm their understanding of cost |

### Database

| Tool                        | Description                                          |
| --------------------------- | ---------------------------------------------------- |
| `execute_sql`               | Executes raw SQL in the Postgres database            |
| `list_tables`               | Lists all tables in one or more schemas              |
| `list_extensions`           | Lists all extensions in the database                 |
| `apply_migration`           | Applies a migration to the database (DDL operations) |
| `list_migrations`           | Lists all migrations in the database                 |
| `generate_typescript_types` | Generates TypeScript types for a project             |

### Keys & URLs

| Tool                   | Description                                 |
| ---------------------- | ------------------------------------------- |
| `get_project_url`      | Gets the API URL for a project              |
| `get_publishable_keys` | Gets all publishable API keys for a project |

### Monitoring

| Tool           | Description                                        |
| -------------- | -------------------------------------------------- |
| `get_logs`     | Gets logs for a Supabase project by service type   |
| `get_advisors` | Gets advisory notices for security and performance |

### Edge Functions

| Tool                   | Description                                  |
| ---------------------- | -------------------------------------------- |
| `list_edge_functions`  | Lists all Edge Functions in a project        |
| `get_edge_function`    | Retrieves file contents for an Edge Function |
| `deploy_edge_function` | Deploys an Edge Function to a project        |

### Branches

| Tool            | Description                                                      |
| --------------- | ---------------------------------------------------------------- |
| `create_branch` | Creates a development branch on a project                        |
| `list_branches` | Lists all development branches                                   |
| `delete_branch` | Deletes a development branch                                     |
| `merge_branch`  | Merges migrations and edge functions from a branch to production |
| `reset_branch`  | Resets migrations of a development branch                        |
| `rebase_branch` | Rebases a development branch on production                       |