Memory your
model can query

// tool.ts — AI SDK 5.
// post() is fetch with the bearer key on it.
import { tool } from 'ai';
import { z } from 'zod';

const INGOT = 'http://localhost:3002/api/v1/acme';
const ingot = INGOT + '/ing_01H8Z…';

export const searchContacts = tool({
  description: 'Search the CRM by stage.',
  inputSchema: z.object({ stage: z.string() }),

  async execute({ stage }, { toolCallId }) {
    const result = await crm.contacts.search({ stage });

    const { receipt } = await post(ingot + '/add', {
      table: 'contacts',
      rows: '$.contacts[*]',
      columns: {
        id:      { from: '$.id',       type: 'VARCHAR' },
        company: { from: '$.org.name', type: 'VARCHAR' },
        arr:     { from: '$.deal.arr', type: 'DOUBLE' } },
      key: ['id'],
      externalId: toolCallId,
      receipt: 'full',
      result,
    });

    // The 412 contacts stay in the ingot. This
    // is what goes back in their place.
    return {
      rows: receipt.totalResults,
      table: receipt.table.name,
      query: receipt.query,
    };
  },
});

# the tool-result part, as the model reads it
{
  "rows": 412,
  "table": "contacts",
  "query": "SELECT * FROM contacts
            WHERE source_batch = 'batch_1508c8…'"
}

# about 180 tokens. The result it stands in
# for was 412 objects and about 48,000.

# the browser is handed the same small object,
# as the stream's tool-output-available part —
# it is one JSON either way, and this one fits

# next step — the model narrows it itself
POST /api/v1/acme/ing_01H8Z…/query
{
  "sql": "SELECT company, arr
          FROM contacts
          WHERE source_batch = 'batch_1508c8…'
            AND arr > 100000
          ORDER BY arr DESC
          LIMIT 20"
}

200 OK · 31ms
{
  "columns": ["company", "arr"],
  "rows": [{ "company": "Northwind", "arr": 184000 }, …],
  "truncated": false
}