ducklake-test
Start duckgres with DuckLake (S3-backed storage with PostgreSQL metadata) for local testing. Use when testing duckgres against DuckLake or reproducing Fivetran sync issues.
Source facts
- Repository
- PostHog/duckgres
- Last source activity
- February 9, 2026 at 21:27
- Detected SKILL.md language
- English
- Stars
- 186
- Forks
- 18
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- ducklake-test
- description
- Start duckgres with DuckLake (S3-backed storage with PostgreSQL metadata) for local testing. Use when testing duckgres against DuckLake or reproducing Fivetran sync issues.
Start duckgres with DuckLake configuration:
1. Start dependencies (PostgreSQL metadata store + MinIO object storage):
```bash
docker-compose up -d
```
2. Kill any existing duckgres process:
```bash
pkill -f duckgres || true
```
3. Ensure config file exists at `duckgres_local_test.yaml`:
```yaml
host: "0.0.0.0"
port: 35437
data_dir: "./data"
users:
postgres: "postgres"
extensions:
- ducklake
ducklake:
metadata_store: "postgres:host=localhost port=5433 user=ducklake password=ducklake dbname=ducklake"
object_store: "s3://ducklake/data/"
s3_provider: "config"
s3_endpoint: "localhost:9000"
s3_access_key: "minioadmin"
s3_secret_key: "minioadmin"
s3_region: "us-east-1"
s3_use_ssl: false
s3_url_style: "path"
```
4. Build and run duckgres:
```bash
go build -o duckgres . && ./duckgres --config duckgres_local_test.yaml
```
5. Connect with psql (in another terminal):
```bash
PGPASSWORD=postgres psql "host=127.0.0.1 port=35437 user=postgres sslmode=require"
```
To cleanup: `pkill -f duckgres && docker-compose down`
View on GitHub