CLI

Prebuilt binaries for macOS, Linux, and Windows on every release, with checksums. No runtime to install alongside it.

# Link a repository to a project and write .env.local
capydb link
capydb env pull

# Everything else follows from there
capydb --help

• -link and env pull - bind the repository to a project and keep environment variables in sync
• -psql, sql, and connection-string - open a shell against the cell, run a single query, or print the URL for another tool
• -logs - tail Postgres and platform logs live in the terminal
• -status - what the project is doing right now, including whether it is asleep
• -studio - open the SQL editor for the linked project

• -preview - create, list, reset, and delete preview databases from a branch
• -generate - TypeScript types, Zod schemas, or Drizzle definitions from the live schema
• -schema dump and schema diff - capture the schema, and see what changed between two of them
• -init drizzle - scaffold a working Drizzle setup with pooler-safe defaults already correct
• -extensions - enable and inspect the extension catalog per cell

• -migrate codemod - rewrite an existing codebase away from another provider's client
• -migrate rls - convert Supabase row-level security policies to vanilla PostgreSQL
• -migrate scan - find environment variables that point the same key at different databases
• -import - bring a database over, with --follow to stay in sync until you cut over
• -doctor - lint a project's configuration for the mistakes that cost an evening

• -orgs, apikeys, and audit - manage the workspace and see who did what
• -webhooks and alerts - wire platform events into your own systems
• -integrations - inspect and manage the platform integrations linked to a project
• -upgrade - move a project between Postgres major versions on your schedule

Every command takes non-interactive flags and returns structured output on request, so the same binary works in a terminal, in CI, and in the hands of an agent with a shell. Authentication is a scoped API key or a device-login flow the human approves in a browser.