db

togo-framework/db

Part of the togo framework.

Install

togo-framework/db The togo-postgres database stack — Postgres with batteries included. part of the togo-framework

---

togo new --db togo-postgres provisions this stack. It is built on pgduckdb/pgduckdb:17 (PostgreSQL 17, Debian 12 bookworm) and ships:

Extension	Version	Notes
pg_duckdb	1.1.1	Real DuckDB embedded in Postgres — columnar analytics, Parquet/CSV/JSON reading
pg_search	0.24.1	ParadeDB BM25 full-text search
pgvector	0.8.3	Vector similarity search for RAG
pg_cron	1.6.7	Scheduled jobs
pg_partman	5.4.3	Partition management

Published as a public image:

ghcr.io/togo-framework/db:latest

Supabase compatibility

The image creates the Supabase service roles on first init (initdb/02-supabase-roles.sql): supabase_admin, authenticator, anon, authenticated, service_role, supabase_auth_admin, supabase_storage_admin — plus auth and storage schemas.

This means GoTrue, Supabase Storage, and Realtime can connect to this image without requiring supabase/postgres as the base.

Note: pgsodium, pg_graphql, and wrappers (Supabase-specific extensions) are not included because they are not available as standard packages for the pgduckdb/bookworm base. If you need those, use the supabase/postgres image instead and accept losing pg_duckdb.

Use it

Or just the image (must set shared_preload_libraries):

Required shared_preload_libraries

These extensions require preloading at server start:

pg_cron,pg_duckdb,pg_search

Set this in your docker compose command: or a custom postgresql.conf.

Smoke tests

---

💎 Premium sponsors

togo is proudly sponsored by ID8 Media and One Studio.

      

---

Premium sponsors

Support togo — become a sponsor.