@tablecraft/adapter-next

Next.js App Router adapter for TableCraft — build powerful data APIs in your Next.js application.

Links

• GitHub
• Documentation

Install

bun add @tablecraft/engine @tablecraft/adapter-next
# or
npm install @tablecraft/engine @tablecraft/adapter-next
# or
yarn add @tablecraft/engine @tablecraft/adapter-next
# or
pnpm add @tablecraft/engine @tablecraft/adapter-next

Features

• App Router support — Native Next.js App Router integration
• Dynamic routes — Single endpoint for multiple tables
• Type-safe — Full TypeScript support
• Server-side rendering — Works with SSR and SSG
• Edge runtime — Compatible with Edge runtime

Usage

Dynamic route (multiple tables)

// app/api/data/[table]/route.ts
import { createNextHandler } from '@tablecraft/adapter-next';
import { db } from '@/db';
import * as schema from '@/db/schema';
import { configs } from '@/tablecraft.config';

const handler = createNextHandler({
  db,
  schema,
  configs,
  getContext: async (request) => {
    // Extract from session, JWT, etc.
    return { tenantId: 'tenant_123', user: { id: '1', roles: ['admin'] } };
  },
});

export const GET = handler;

Single route (one table)

// app/api/users/route.ts
import { createNextRouteHandler } from '@tablecraft/adapter-next';
import { db } from '@/db';
import * as schema from '@/db/schema';
import { usersConfig } from '@/tablecraft.config';

export const GET = createNextRouteHandler({
  db,
  schema,
  config: usersConfig,
});

With NextAuth.js

// app/api/data/[table]/route.ts
import { createNextHandler } from '@tablecraft/adapter-next';
import { getServerSession } from 'next-auth';
import { authOptions } from '@/lib/auth';

const handler = createNextHandler({
  db,
  schema,
  configs,
  getContext: async (request) => {
    const session = await getServerSession(authOptions);
    return {
      tenantId: session?.user?.tenantId,
      user: session?.user,
    };
  },
});

export const GET = handler;

Query from the client

GET /api/data/users?page=1&pageSize=25&sort=-createdAt&filter[status]=active&search=john
GET /api/data/orders?export=csv
GET /api/data/products?filter[category]=electronics&filter[price][gte]=100

Configuration Options

The handler options are typed by NextHandlerOptions from this package, which uses EngineContext from @tablecraft/engine:

import type { EngineContext, TableConfig } from '@tablecraft/engine';
import type { NextHandlerOptions } from '@tablecraft/adapter-next';

const options: NextHandlerOptions = {
  db,                    // Drizzle database instance
  schema,                // Drizzle schema object
  configs,               // Table configs (array or object map)
  getContext: async (request: Request): Promise<EngineContext> => ({
    tenantId: 'tenant_123',
    user: { id: '1', roles: ['admin'] },
  }),
  checkAccess: async (config: TableConfig, context: EngineContext) => {
    return context.user?.roles?.includes('admin') ?? false;
  },
};

const handler = createNextHandler(options);

License

MIT