Cloud Db Sql

Execute SQL query on a database

Prerequisites

• Authenticated with agentuity auth login
• Organization context required (--org-id or default org)

Usage

agentuity cloud db sql <name> <query>

Arguments

Examples

Execute SQL query:

bunx @agentuity/cli cloud db sql my-database "SELECT * FROM users LIMIT 10"

Execute query with JSON output:

bunx @agentuity/cli cloud db exec my-database "SELECT COUNT(*) FROM orders" --json

Query with filter:

bunx @agentuity/cli cloud db query my-database "SELECT * FROM products WHERE price > 100"

Output

Returns JSON object:

{
  "rows": "array",
  "rowCount": "number",
  "truncated": "boolean"
}