Skip to content
Back to Templates

Vercel Postgres pgvector Starter

A Next.js template that uses Vercel Postgres as the database, pgvector for vector similarity search + OpenAI's text embedding models.

DeployView Demo
opengraph-image

Vercel Postgres + Drizzle ORM + pgvector Next.js Starter

A Next.js template that uses Vercel Postgres as the database, Drizzle ORM as the ORM with pgvector to enable vector similarity search, and OpenAI's text-embedding-ada-002 model for embeddings.

Demo

https://postgres-pgvector.vercel.app/

How to Use

You can choose from one of the following two methods to use this repository:

One-Click Deploy

Deploy the example using Vercel:

Clone and Deploy

Execute create-next-app with pnpm to bootstrap the example:

pnpm create next-app --example https://github.com/vercel/examples/tree/main/storage/postgres-pgvector

Once that's done, copy the .env.example file in this directory to .env.local (which will be ignored by Git):

cp .env.example .env.local

Then open .env.local and set the environment variables to match the ones in your Vercel Storage Dashboard.

Next, run Next.js in development mode:

pnpm dev

Deploy it to the cloud with Vercel (Documentation).

Use Cases
StarterAI
Stack
Next.jsTailwind
Database
Vercel Postgres
Source

Related Templates

Postgres Next.js Starter

Simple Next.js template that uses a Postgres database.
Postgres Next.js Starter

Vercel Postgres + Prisma Next.js Starter

Simple Next.js template that uses Vercel Postgres as the database and Prisma as the ORM.
Vercel Postgres + Prisma Next.js Starter

Next.js OpenAI Doc Search Starter

Template for building your own custom ChatGPT style doc search powered by Next.js, OpenAI, and Supabase.
Next.js OpenAI Doc Search Starter