Can AI agents use psql?

- id: create-table
  intent: "Using psql, create a table called 'users' with columns: id (serial
    primary key), name (varchar 100, not null), email (varchar 255, unique), and
    created_at (timestamp with default now()). Then verify the table exists by
    listing the table structure."
  assert:
    - ran: psql.*CREATE TABLE|psql.*create table
    - ran: psql.*\\d|psql.*\\dt
  setup:
    - sudo -u postgres createdb bench_test 2>/dev/null || true
  max_turns: 5
  difficulty: medium
  category: schema
- id: insert-and-query
  intent: "Using psql, create a table called 'products' with columns id (serial),
    name (text), and price (numeric). Insert three products: 'Widget' at 9.99,
    'Gadget' at 24.50, and 'Gizmo' at 14.75. Then query all products ordered by
    price descending and save the output to query-result.txt."
  assert:
    - ran: psql.*INSERT|psql.*insert
    - ran: psql.*SELECT|psql.*select
    - file_exists: query-result.txt
  setup:
    - sudo -u postgres createdb bench_test2 2>/dev/null || true
  max_turns: 6
  difficulty: medium
  category: query
- id: export-csv
  intent: Using psql, create a table 'scores' with columns name (text) and points
    (int). Insert 5 rows of sample data. Export the table to a CSV file called
    scores.csv using the COPY command or \copy.
  assert:
    - ran: psql
    - file_exists: scores.csv
  setup:
    - sudo -u postgres createdb bench_test3 2>/dev/null || true
  max_turns: 6
  difficulty: medium
  category: export
- id: create-sql-script
  intent: Create a SQL script file called 'setup.sql' that creates a 'tasks' table
    (id serial, title text not null, done boolean default false) and inserts 3
    sample tasks. Then execute the script using psql.
  assert:
    - file_exists: setup.sql
    - file_contains:
        path: setup.sql
        text: CREATE TABLE
    - ran: psql.*setup.sql|psql.*-f
  setup:
    - sudo -u postgres createdb bench_test4 2>/dev/null || true
  max_turns: 5
  difficulty: easy
  category: workflow