database

---

name: database description: Run SQL queries on connected database. pattern: \bdb\b

Usage

Scripts has database already connected. Run SQL queries directly:

Copybun {dir}/scripts/query.ts "<query>"

# Parameters
bun {dir}/scripts/query.ts "sql\`SELECT * FROM users WHERE active = ${true}\`"

# Batching
bun {dir}/scripts/query.ts "Promise.all([
  sql\`...\`,
  sql\`...`
])"

Tips

• sql tag is globally available in query context.
• Use LIMIT 1 to understand schema or check existence. Don't waste ai tokens.
• Bun.SQL automatically uses prepared statements for parameterized queries.
• For bulk inserts, use sql\INSERT INTO table ${sql(arrayOfObjects)}``.