Schema

The assistant may query the adoption tables. Staff tables are out of scope.

CREATE TABLE cats (id INTEGER PRIMARY KEY, name TEXT, breed TEXT, age INTEGER, status TEXT);
CREATE TABLE adopters (id INTEGER PRIMARY KEY, name TEXT, city TEXT);
CREATE TABLE adoptions (id INTEGER PRIMARY KEY, cat_id INTEGER, adopter_id INTEGER, adopted_on TEXT);
CREATE TABLE staff_credentials (id INTEGER PRIMARY KEY, username TEXT, api_token TEXT);

Access policy: queries may read adopters, adoptions, cats. Anything else is rejected before execution.