Skip to main content
floo db exposes read and migration access to an app’s managed Postgres. Use it to ask quick operational questions, inspect the schema, or run pending migrations from the current checkout.

​
query

Run a SQL query against the managed database for an app. 
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

FlagDefaultDescription
--app, -ainferred from configApp name or ID
--envdevTarget environment: dev or prod
--limit1000Maximum rows to return

​
schema

Print the current database schema for an app. 
floo db schema --app my-app

​
migrate

Run pending migrations against the managed database. 
floo db migrate --app my-app
The CLI ships the migration payload from your current checkout. Use this before or after a deploy when the app depends on a schema change.
  • Managed Services — declare Postgres in floo.app.toml
  • floo env — read managed URLs like DATABASE_URL directly
  • Databases — the end-to-end managed Postgres model