All Templates / Storage
Open-source vector similarity search for Postgres
Postgres with the pgvector extension installed. TCP proxying is configured to allow accessing the database from anywhere.
DATABASE_URL variable from your service to connect to the database in your tool of choice (e.g.
You can connect to your database using the proxied domain and port found on the service settings page. The password can be found on the Variables page.
Once connected, test that pgvector is setup with the following SQL.
CREATE EXTENSION vector; CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)); INSERT INTO items (embedding) VALUES ('[1,2,3]'), ('[4,5,6]'); SELECT * FROM items ORDER BY embedding <-> '[3,1,2]' LIMIT 5;