LLM instructions

Use I Need A Database as the app's JSON database.

Read this implementation guide first:
https://ineedadatabase.com/docs/llms

Important facts:
- Base URL: https://ineedadatabase.com
- API prefix: /api/v1
- Project id placeholder: proj_123
- API key placeholder: inadb_...
- Store the API key only as a server-side secret. Do not expose it in browser code.
- Do not call the API directly from frontend JavaScript. Proxy through a server route, serverless function, worker, or backend service.
- Use collections, not tables.
- Store JSON documents as sent. Do not invent schemas, migrations, joins, or foreign keys.
- When creating documents, send document fields directly. Do not wrap them in { "data": ... }.
- List responses are objects: { "items": [...], "next_cursor": null }. They are not bare arrays.

Task:
1. Add server-side helpers for creating, reading, updating, deleting, filtering, and paginating documents.
2. Read INEEDADATABASE_PROJECT_ID and INEEDADATABASE_API_KEY from environment variables.
3. Use Authorization: Bearer <api key> and Content-Type: application/json.
4. Create collections if needed before writing documents.
5. Model relationships with id fields such as user_id, project_id, or order_id inside documents.
6. Use query parameters for filters, sort, limit, and cursor pagination.
7. Keep the integration small and conventional. If something requires auth by end user, field-level permissions, joins, or direct browser access, explain that this is not supported yet and keep the API calls on the server.

POST /api/v1/projects/proj_123/collections/recipes/documents
Content-Type: application/json

{
  "title": "Pasta",
  "servings": 4,
  "tags": ["dinner", "quick"]
}

{
  "id": "A1b2C3d4",
  "created_at": "2026-05-08T12:00:00Z",
  "updated_at": "2026-05-08T12:00:00Z",
  "revision": "rev_E5f6G7h8",
  "data": {
    "title": "Pasta",
    "servings": 4,
    "tags": ["dinner", "quick"]
  }
}

{
  "items": [
    {
      "id": "A1b2C3d4",
      "created_at": "2026-05-08T12:00:00Z",
      "updated_at": "2026-05-08T12:00:00Z",
      "revision": "rev_E5f6G7h8",
      "data": {
        "title": "Pasta",
        "servings": 4
      }
    }
  ],
  "next_cursor": null
}

const payload = await response.json();
const documents = payload.items;
const nextCursor = payload.next_cursor;

Authorization: Bearer inadb_...
Content-Type: application/json

export async function GET() {
  const baseUrl = "https://ineedadatabase.com";
  const projectId = process.env.INEEDADATABASE_PROJECT_ID;
  const apiKey = process.env.INEEDADATABASE_API_KEY;

  const response = await fetch(
    `${baseUrl}/api/v1/projects/${projectId}/collections/recipes/documents`,
    {
      headers: {
        Authorization: `Bearer ${apiKey}`
      }
    }
  );

  return Response.json(await response.json(), { status: response.status });
}

GET /api/v1/projects/proj_123/collections/recipes/documents?servings=4
GET /api/v1/projects/proj_123/collections/recipes/documents?rating_gte=4
GET /api/v1/projects/proj_123/collections/recipes/documents?title_contains=pasta
GET /api/v1/projects/proj_123/collections/recipes/documents?tags_contains=quick
GET /api/v1/projects/proj_123/collections/orders/[email protected]
GET /api/v1/projects/proj_123/collections/recipes/documents?sort=-created_at&limit=50
GET /api/v1/projects/proj_123/collections/recipes/documents?limit=50&cursor=abc123

POST /api/v1/projects/proj_123/collections/tasks/documents

{
  "title": "Send invoice",
  "user_id": "user_123",
  "status": "open"
}

GET /api/v1/projects/proj_123/collections/tasks/documents?user_id=user_123