@versedhand/common

Shared utilities for @versedhand/ MCP servers. PostgreSQL connection pooling, environment helpers, and path resolution.

Install

npm install @versedhand/common

API

Database

• getPool(config?) — Singleton PostgreSQL pool (defaults to env vars or LifeDB)
• query(sql, params?) — Execute query, return rows
• queryOne(sql, params?) — Execute query, return first row or null
• execute(sql, params?) — Execute non-SELECT, return command summary
• shutdown() — Close the pool

Environment variables: LIFEDB_HOST, LIFEDB_PORT, LIFEDB_USER, LIFEDB_PASSWORD, LIFEDB_NAME

Config

• requireEnv(name) — Get env var or throw
• env(name, default) — Get env var with default
• readFirstExisting(...paths) — Read first file that exists from candidate paths
• getObsBase() — Detect corpus base path (/mnt/d/obs, /srv/obs, or ~/obs)
• getProjectsBase() — Returns ~/projects

License

MIT