Template · Databases

Postgres + pgvector

PostgreSQL 17 with the pgvector extension for embeddings and similarity search.

Opens the dashboard with this template pre-selected. Sign in with GitHub if you are new; the free tier needs no card.

What gets deployed

One service in the environment you pick, on the private network of the project.

pgvector/pgvector:pg17. Run CREATE EXTENSION vector; in your database to enable the vector type.

Enable the extension once: CREATE EXTENSION IF NOT EXISTS vector;

Image: pgvector/pgvector:pg17

Generated secrets never leave the platform; references are resolved on the private network. Anything marked required is asked for at deploy time.

Name	Value
POSTGRES_USER	postgresSuperuser name
POSTGRES_PASSWORD	generated (password)Generated at deploy
POSTGRES_DB	appDatabase created on first start
PGDATA	/var/lib/postgresql/data/pgdata
DATABASE_URL	postgresql://${{self.POSTGRES_USER}}:${{self.POSTGRES_PASSWORD}}@${{self.SKIFFLY_PRIVATE_DOMAIN}}:5432/${{self.POSTGRES_DB}}Connection string on the private network

Add a one-click deploy link to your repository or docs. Two variants: for light and dark backgrounds.

Markdown · Light background

[![Deploy on Skiffly](https://skiffly.dev/button.svg)](https://skiffly.dev/templates/pgvector)

Markdown · Dark background

[![Deploy on Skiffly](https://skiffly.dev/button-dark.svg)](https://skiffly.dev/templates/pgvector)

HTML

<a href="https://skiffly.dev/templates/pgvector"><img src="https://skiffly.dev/button.svg" alt="Deploy on Skiffly" height="32"></a>

Volumes, secrets and domain pre-wired. Runs on EU nodes, paid per minute from a prepaid balance.