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

# Supabase

> Generate embeddings with Prisma AIRS AI Gateway and store them in Supabase pgvector

Supabase provides Postgres with pgvector for AI applications. With the AI Gateway, generate embeddings using 3,000+ models and store them in Supabase for efficient retrieval.

## Prerequisites

* Supabase project API key
* [AI Gateway API key](https://stratacloudmanager.paloaltonetworks.com/)

## Setup

### 1. Install Dependencies

```sh theme={"system"}
pip install supabase
```

### 2. Prepare Database

<Steps>
  <Step title="Create Supabase Project">
    Go to [Supabase](https://supabase.com/dashboard/sign-in) and create a new project.
  </Step>

  <Step title="Enable pgvector">
    In **Database → Extensions**, enable `pgvector`. Or run:

    ```sql theme={"system"}
    create extension vector;
    ```
  </Step>

  <Step title="Create Documents Table">
    Create a table for documents and embeddings. OpenAI's `text-embedding-ada-002` outputs 1536 dimensions:

    ```sql theme={"system"}
    create table documents (
      id bigserial primary key,
      content text,
      embedding vector(1536)
    );
    ```
  </Step>
</Steps>

### 3. Configure Clients

## Generate & Store Embeddings

```python theme={"system"}
# Generate embedding
response = client.embeddings.create(
    model="text-embedding-ada-002",
    input="The food was delicious and the waiter..."
)

embedding = response.data[0].embedding

# Store in Supabase
result = supabase.table('documents').insert({
    "content": "The food was delicious and the waiter...",
    "embedding": embedding
}).execute()
```

## Switch Providers

Change the provider to use different embedding models:

<Note>
  Cohere's `embed-english-v3.0` outputs 1024 dimensions. Create a separate table with `vector(1024)` for Cohere embeddings.
</Note>

## Next Steps

<CardGroup cols={2}>
  <Card title="Model Catalog" icon="list" href="/docs/aigw/product/model-catalog">
    Set up embedding providers
  </Card>

  <Card title="Supported Providers" icon="plug" href="/docs/aigw/integrations/llms">
    See all 3,000+ supported models
  </Card>
</CardGroup>


## Related topics

- [Overview](/docs/aigw/integrations/libraries.md)