Manage Custom Data with the Simple AI SDK

const { records, total } = await client.data.query({
  tableName: 'customers',
  filters: [{ column: 'state', values: ['CA', 'NY'] }],
  text: 'ada lovelace', // optional free-text relevance search
  size: 25,
  from: 0,
});

type Customer = { email: string; plan: string };
const { records } = await client.data.query<Customer>({ tableName: 'customers' });

// Paginated listing from the relational store
const page = await client.data.list('customers', {
  page: 1,
  perPage: 50,
  orderBy: 'created_at',
  orderDirection: 'desc',
  filters: { state: 'CA' }, // column equality filters
});

const { record } = await client.data.get('customers', 42);
const created = await client.data.create('customers', { email: 'ada@example.com', plan: 'pro' });
const updated = await client.data.update('customers', 42, { plan: 'enterprise' });
await client.data.delete('customers', 42);
await client.data.deleteAll('customers'); // removes every record — irreversible

const { ingestBatchId } = await client.data.batchUpsert('customers', rows);

// Poll until the batch is applied
const status = await client.data.getBatch(ingestBatchId);
// status.status: 'queued' | 'processing' | 'succeeded' | 'failed'

const facets = await client.data.facets('customers');