db - floo

floo db has two commands: query runs SQL against an app’s managed Postgres, and schema prints its schema. Preview database branches are listed by floo previews resources. pgvector is available but not enabled by default. Add CREATE EXTENSION IF NOT EXISTS vector; to your first migration. See Postgres → Vector search with pgvector. Migrations run on each deploy: see Run migrations through migrate_command. Backups and restores: see Postgres → Backups.

query

Run SQL against an app’s managed database.

floo db query --app my-app "SELECT id, email FROM users LIMIT 5"
floo db query --app my-app "SELECT COUNT(*) FROM orders" --env prod
floo db query --app my-app "SELECT * FROM logs" --limit 50

Flags

Flag	Default	Description
`--app`, `-a`	inferred from config	App name or ID
`--env`	`dev`	Target environment: `dev` or `prod`
`--limit`	`1000`	Maximum rows to return
`--preflight`	off	Print the SQL and target without running it

schema

Print an app’s current database schema.

floo db schema --app my-app

Managed Services: declare Postgres in floo.app.toml
floo env: read managed URLs like DATABASE_URL directly
Postgres: the end-to-end managed Postgres model
Preview Environments: supported preview data modes and branch reset behavior

CLI

Config and runtime

Errors

API

db

query

Flags

schema

​query

​Flags

​schema

​Related

query

Flags

schema

Related