postgresdk

What it is

postgresdk is a CLI + library that introspects your PostgreSQL schema and generates two things:

• A Hono API server — typed routes, Zod validation, auth middleware, soft/hard delete, vector & trigram search.
• A TypeScript client SDK — typed CRUD, eager-loading includes, atomic transactions, type-safe where filtering, and pagination.

Regenerate any time your schema changes. No hand-written glue, no drift.

Code is the source of truth

The reference docs are generated from postgresdk’s own source — the CLI, the Config type, and the WHERE operators — so they can’t go stale.

Built for agents

Every page is available as plain Markdown, plus /llms.txt, /llms-full.txt, and /llms-small.txt for downstream agents to read verbatim.

See real output

The Generated API example is a real CONTRACT.md produced by running postgresdk against a fixture schema.

Typed end to end

Nested includes infer their own return types. where operators reject the wrong column types at compile time.

For LLMs & agent skills

This site is designed to be consumed by agents that build skills on top of postgresdk. The llms.txt files are generated at build time:

• /llms.txt — index + project summary
• /llms-full.txt — the entire docs as one file
• /llms-small.txt — a trimmed bundle for smaller context windows