Skip to main content
A Postgres database is auto-provisioned for apps that need one. Database management is done through the services command — there is no separate floo db command.

​
View database info

Use floo services info to see connection details for a managed database: 
floo services info postgres --app my-app

Service: postgres (managed)
  Status:   active
  Host:     floo-db-abc123.us-central1.cloudsql.com
  Port:     5432
  Database: floo_my-app-uuid

DATABASE_URL is injected as an environment variable.

​
JSON output

{
  "success": true,
  "data": {
    "name": "postgres",
    "type": "managed",
    "status": "active",
    "host": "floo-db-abc123.us-central1.cloudsql.com",
    "port": 5432,
    "database": "floo_my-app-uuid"
  }
}

​
Access the connection string

The DATABASE_URL env var is automatically set when a database is provisioned: 
floo env get DATABASE_URL --app my-app
See the databases guide for provisioning and usage details.