bt sql

Run SQL queries against Braintrust. In a terminal, bt sql opens an interactive editor with query history. Pass a query directly or pipe from stdin for scripting.

bt sql                                                          # Interactive terminal UI editor
bt sql "SELECT * FROM project_logs('my-project') LIMIT 10"      # Inline query
cat query.sql | bt sql                                          # Pipe from file
bt sql --non-interactive "SELECT count(*) FROM project_logs('my-project')"

Most SQL data-source functions also accept an object name in place of its ID. See Querying by name.

Interactive controls

Key	Action
`↑` / `↓`	Navigate query history
`Enter`	Execute query
`Ctrl+c`	Clear input
`Ctrl+l`	Clear output
`Ctrl+d` / `Esc`	Exit

Query syntax

A FROM clause is required (project_logs(...), experiment(...), dataset(...))
Prefer filtering with WHERE; use HAVING only after aggregation
Joins, subqueries, unions, and window functions are not supported
Use explicit column aliases and type casts for clarity
Paginate large results with OFFSET '<cursor_token>'

For tips on query performance and common pitfalls, see SQL best practices.

bt eval

bt sync

⌘I

API

CLI

SQL

Interactive controls

Query syntax

​Interactive controls

​Query syntax

Interactive controls

Query syntax