// STRYKE-POSTGRES — POSTGRESQL CLIENT FOR STRYKE // OPT-IN PACKAGE

stryke package · CLI launcher postgres · Rust helper stryke-postgres-helper · opt-in (kept out of stryke core)

Report GitHub Issues
// Color scheme

>_STRYKE-POSTGRES

Postgres without the ORM. PostgreSQL client for stryke. Opt-in package, kept out of the stryke core binary. NDJSON-by-default output; bind parameters supported.

Install

# build the helper binary, install as a stryke package
cd ~/projects/stryke-postgres
cargo build --release
s pkg install -g .

# one-liner
make install

# verify
postgres --help

After install, postgres --help works from anywhere on PATH (assuming ~/.stryke/bin/ is on PATH). The stryke library is auto-discoverable to any project that depends on the package via [deps] postgres = { path = "..." } or, when published, by name.

CLI: postgres

query rowspostgres query 'SELECT id, email FROM users LIMIT 10'
bind parameterspostgres query 'SELECT * FROM events WHERE day = $1' --bind 2026-05-24
execute DDLpostgres exec 'CREATE INDEX idx_events_day ON events(day)'
import NDJSONcat events.ndjson | postgres insert events
show schemapostgres describe users

The full flag matrix lives in the README "CLI" section.

Why a package, not a builtin

Sync postgres crate. Designed for shell pipelines + scripts, not as an ORM layer.

The stryke side is a thin NDJSON-pipe wrapper; the heavy code lives in the stryke-postgres-helper sidecar binary and is loaded on demand. Core stryke is never linked against this package's deps.

Helper protocol

The stryke-postgres-helper sidecar speaks newline-delimited JSON over stdin/stdout. The stryke library shells out per call and pipes structured data both ways. This keeps stryke startup small while making the package's surface area available on demand.

# manual invocation (debugging only)
echo '{"op":"version"}' | stryke-postgres-helper

Layout

stryke-postgres/
├── Cargo.toml             # bin = stryke-postgres-helper (publish = false)
├── src/
│   └── main.rs           # helper binary entry point
├── lib/                   # stryke .stk wrapper(s)
├── stryke.toml            # stryke package manifest
├── t/                     # zunit-style tests
├── examples/              # runnable .stk examples
├── Makefile               # `make install` builds + installs
└── docs/                  # this site (GitHub Pages)

Sibling packages

Part of the stryke connector family. Browse the others via the MenkeTechnologiesMeta umbrella repo (Tier 2):