Database Query

Execute SQL against PostgreSQL or MySQL via CLI.

Environment Variables

• DATABASE_URL - PostgreSQL connection string (e.g. postgres://user:pass@host:5432/db)
• MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE - MySQL connection params

PostgreSQL

psql "$DATABASE_URL" -c "SELECT id, name FROM users LIMIT 10;"

CSV output:

psql "$DATABASE_URL" --csv -c "SELECT * FROM orders WHERE created_at > now() - interval '7 days';"