Skip to content

secondsky/claude-skills / plugins/tanstack-table/skills/tanstack-table

tanstack-table

Verified

TanStack Table v8 headless data tables with server-side features for Cloudflare Workers + D1. Use for pagination, filtering, sorting, virtualization, or encountering state management, TanStack Query coordination, URL sync errors.

templates/d1-database-example.tsx

View on GitHub
/**
 * Cloudflare D1 Database Integration Example
 *
 * Complete example of TanStack Table with Cloudflare Workers + D1 backend.
 * Includes: Server-side pagination, filtering, sorting with SQL queries.
 */

// ============================================
// CLOUDFLARE WORKERS API (functions/api/users.ts)
// ============================================

interface Env {
  DB: D1Database
}

export const onRequestGet: PagesFunction<Env> = async ({ request, env }) => {
  const url = new URL(request.url)

  // Parse query parameters
  const page = Number(url.searchParams.get('page')) || 0
  const pageSize = Number(url.searchParams.get('pageSize')) || 20
  const sortBy = url.searchParams.get('sortBy') || 'created_at'
  const sortOrder = url.searchParams.get('sortOrder') || 'desc'
  const search = url.searchParams.get('search') || ''

  const offset = page * pageSize

  try {
    // Build SQL query with filters
    let query = `
      SELECT id, name, email, role, created_at
      FROM users
    `
    const params: (string | number)[] = []

    // Add search filter
    if (search) {
      query += ` WHERE name LIKE ? OR email LIKE ?`
      params.push(`%${search}%`, `%${search}%`)
    }

    // Add sorting (validate to prevent SQL injection)
    const allowedSortColumns = ['id', 'name', 'email', 'role', 'created_at']
    const allowedSortOrders = ['asc', 'desc']
    if (allowedSortColumns.includes(sortBy) && allowedSortOrders.includes(sortOrder)) {
      query += ` ORDER BY ${sortBy} ${sortOrder.toUpperCase()}`
    } else {
      query += ` ORDER BY created_at DESC`
    }

    // Add pagination
    query += ` LIMIT ? OFFSET ?`
    params.push(pageSize, offset)

    // Execute query
    const { results } = await env.DB.prepare(query).bind(...params).all()

    // Get total count for pagination
    let countQuery = `SELECT COUNT(*) as total FROM users`
    const countParams: (string)[] = []
    if (search) {
      countQuery += ` WHERE name LIKE ? OR email LIKE ?`
      countParams.push(`%${search}%`, `%${search}%`)
    }
    const countResult = await env.DB.prepare(countQuery).bind(...countParams).first<{ total: number }>()
    const total = countResult?.total || 0

    return Response.json({
      data: results,
      pagination: {
        page,
        pageSize,
        total,
        pageCount: Math.ceil(total / pageSize),
      },
    })
  } catch (error) {
    console.error('Database error:', error)
    return Response.json(
      { error: 'Failed to fetch users' },
      { status: 500 }
    )
  }
}

// ============================================
// CLIENT-SIDE TABLE COMPONENT
// ============================================

import {
  useReactTable,
  getCoreRowModel,
  ColumnDef,
  PaginationState,
  SortingState,
  ColumnFiltersState,
  flexRender,
} from '@tanstack/react-table'
import { useQuery } from '@tanstack/react-query'
import { useState } from 'react'

interface User {
  id: string
  name: string
  email: string
  role: string
  created_at: string
}

interface UsersResponse {
  data: User[]
  pagination: {
    page: number
    pageSize: number
    total: number
    pageCount: number
  }
}

const columns: ColumnDef<User>[] = [
  {
    accessorKey: 'id',
    header: 'ID',
    enableSorting: true,
  },
  {
    accessorKey: 'name',
    header: 'Name',
    enableSorting: true,
  },
  {
    accessorKey: 'email',
    header: 'Email',
    enableSorting: true,
  },
  {
    accessorKey: 'role',
    header: 'Role',
    enableSorting: true,
  },
  {
    accessorKey: 'created_at',
    header: 'Created',
    enableSorting: true,
    cell: info => new Date(info.getValue() as string).toLocaleDateString(),
  },
]

export function D1DatabaseTable() {
  // Table state
  const [pagination, setPagination] = useState<PaginationState>({
    pageIndex: 0,
    pageSize: 20,
  })
  const [sorting, setSorting] = useState<SortingState>([])
  const [columnFilters, setColumnFilters] = useState<ColumnFiltersState>([])

  // Extract search from column filters
  const searchValue = columnFilters.find(f => f.id === 'search')?.value as string || ''

  // CRITICAL: Include ALL state in query key
  const { data, isLoading, isError } = useQuery<UsersResponse>({
    queryKey: ['users', pagination, sorting, searchValue],
    queryFn: async () => {
      const params = new URLSearchParams({
        page: pagination.pageIndex.toString(),
        pageSize: pagination.pageSize.toString(),
      })

      // Add sorting params
      if (sorting.length > 0) {
        params.append('sortBy', sorting[0].id)
        params.append('sortOrder', sorting[0].desc ? 'desc' : 'asc')
      }

      // Add search param
      if (searchValue) {
        params.append('search', searchValue)
      }

      const response = await fetch(`/api/users?${params}`)
      if (!response.ok) throw new Error('Failed to fetch')
      return response.json()
    },
    placeholderData: (previousData) => previousData,
  })

  const table = useReactTable({
    data: data?.data ?? [],
    columns,
    getCoreRowModel: getCoreRowModel(),
    // Server-side features
    manualPagination: true,
    manualSorting: true,
    manualFiltering: true,
    pageCount: data?.pagination.pageCount ?? 0,
    state: {
      pagination,
      sorting,
      columnFilters,
    },
    onPaginationChange: setPagination,
    onSortingChange: setSorting,
    onColumnFiltersChange: setColumnFilters,
  })

  return (
    <div className="p-4">
      <h2 className="text-2xl font-bold mb-4">Users (D1 Database)</h2>

      {/* Search Filter */}
      <div className="mb-4">
        <input
          type="text"
          placeholder="Search by name or email..."
          value={searchValue}
          onChange={e =>
            setColumnFilters([{ id: 'search', value: e.target.value }])
          }
          className="border rounded px-3 py-2 w-full max-w-md"
        />
      </div>

      {isLoading && <div>Loading...</div>}
      {isError && <div className="text-red-600">Error loading data</div>}

      {!isLoading && !isError && (
        <>
          <table className="w-full border-collapse">
            <thead>
              {table.getHeaderGroups().map(headerGroup => (
                <tr key={headerGroup.id}>
                  {headerGroup.headers.map(header => (
                    <th
                      key={header.id}
                      onClick={header.column.getToggleSortingHandler()}
                      className="border px-4 py-2 bg-gray-100 cursor-pointer hover:bg-gray-200"
                    >
                      <div className="flex items-center gap-2">
                        {flexRender(
                          header.column.columnDef.header,
                          header.getContext()
                        )}
                        {{
                          asc: ' 🔼',
                          desc: ' 🔽',
                        }[header.column.getIsSorted() as string] ?? null}
                      </div>
                    </th>
                  ))}
                </tr>
              ))}
            </thead>
            <tbody>
              {table.getRowModel().rows.map(row => (
                <tr key={row.id}>
                  {row.getVisibleCells().map(cell => (
                    <td key={cell.id} className="border px-4 py-2">
                      {flexRender(cell.column.columnDef.cell, cell.getContext())}
                    </td>
                  ))}
                </tr>
              ))}
            </tbody>
          </table>

          {/* Pagination */}
          <div className="mt-4 flex justify-between">
            <div>
              Page {pagination.pageIndex + 1} of {data?.pagination.pageCount ?? 0}
            </div>
            <div className="flex gap-2">
              <button
                onClick={() => table.previousPage()}
                disabled={!table.getCanPreviousPage()}
                className="px-3 py-1 border rounded disabled:opacity-50"
              >
                Previous
              </button>
              <button
                onClick={() => table.nextPage()}
                disabled={!table.getCanNextPage()}
                className="px-3 py-1 border rounded disabled:opacity-50"
              >
                Next
              </button>
            </div>
          </div>
        </>
      )}
    </div>
  )
}

// ============================================
// WRANGLER.JSONC CONFIGURATION
// ============================================

/*
{
  "name": "tanstack-table-d1-example",
  "compatibility_date": "2025-11-07",
  "pages_build_output_dir": "dist",
  "d1_databases": [
    {
      "binding": "DB",
      "database_name": "users-db",
      "database_id": "your-database-id"
    }
  ]
}
*/

// ============================================
// DATABASE SCHEMA (schema.sql)
// ============================================

/*
CREATE TABLE users (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT NOT NULL UNIQUE,
  role TEXT NOT NULL DEFAULT 'user',
  created_at TEXT NOT NULL DEFAULT (datetime('now'))
);

CREATE INDEX idx_users_name ON users(name);
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_users_created_at ON users(created_at);

-- Seed data
INSERT INTO users (id, name, email, role) VALUES
  ('1', 'Alice Smith', 'alice@example.com', 'admin'),
  ('2', 'Bob Johnson', 'bob@example.com', 'user'),
  ('3', 'Charlie Brown', 'charlie@example.com', 'editor');
*/
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 197kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall