name	Vercel Postgres + Prisma + pgvector Next.js Starter
slug	postgres-pgvector
description	A Next.js template that uses Vercel Postgres as the database, Prisma as the ORM with pgvector to enable vector similarity search, and OpenAI's text-embedding-ada-002 model for embeddings.
framework	Next.js
useCase	Starter
css	Tailwind
database	Vercel Postgres
deployUrl	https://vercel.com/new/clone?repository-url=https%3A%2F%2Fgithub.com%2Fvercel%2Fexamples%2Ftree%2Fmain%2Fstorage%2Fpostgres-pgvector&env=OPENAI_API_KEY&envDescription=Get+your+OpenAI+API+key+here%3A&envLink=https%3A%2F%2Fplatform.openai.com%2Faccount%2Fapi-keys&project-name=postgres-pgvector&repository-name=postgres-pgvector&demo-title=Vercel+Postgres+%2B+Prisma+%2B+pgvector+Next.js+Starter&demo-description=A+Next.js+template+that+uses+Vercel+Postgres+as+the+database%2C+Prisma+as+the+ORM+with+pgvector+to+enable+vector+similarity+search%2C+and+OpenAI%E2%80%99s+models+for+text+embeddings.&demo-url=https%3A%2F%2Fpostgres-pgvector.vercel.app&demo-image=https%3A%2F%2Fpostgres-pgvector.vercel.app%2Fopengraph-image.png&stores=%5B%7B%22type%22%3A%22kv%22%7D%2C%7B%22type%22%3A%22postgres%22%7D%5D
demoUrl	https://postgres-pgvector.vercel.app/
relatedTemplates	postgres-starter postgres-kysely postgres-drizzle

Vercel Postgres + Prisma + pgvector Next.js Starter

A Next.js template that uses Vercel Postgres as the database, Prisma 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).