The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { ChevronRightIcon, FileTextIcon, Loader2Icon, SquareCodeIcon } from 'lucide-react'
import {
cn,
Collapsible,
CollapsibleContent,
CollapsibleTrigger,
Tooltip,
TooltipContent,
TooltipTrigger,
} from 'ui'
import { CodeBlock } from 'ui-patterns/CodeBlock'
import {
getCellCodeBlockLanguage,
getCellLabel,
getCellMonacoLanguage,
getCellSourceText,
getEntryMetadata,
type NotebookDatabaseContext,
} from './AssistantNotebookPreview.utils'
import { ExplorerQueryResults } from '@/components/interfaces/Explorer/ExplorerQuery'
import { QueryResultFooter } from '@/components/interfaces/Explorer/QueryEditor/QueryResultFooter'
import { QueryResultRenderer } from '@/components/interfaces/Explorer/QueryEditor/QueryResultRenderer'
import type { QueryResult } from '@/components/interfaces/Explorer/types'
import { DiffEditor } from '@/components/ui/DiffEditor'
import type { NotebookCellDiffEntry } from '@/data/content/notebooks/notebook-operations'
import type { AgentCell, CellWire } from '@/data/content/notebooks/notebook-schema'
export interface AssistantNotebookPreviewCellProps {
entry: NotebookCellDiffEntry
isExpanded: boolean
onExpandedChange: (isExpanded: boolean) => void
/** Create and run previews omit per-row change glyphs. */
mode: 'create' | 'update' | 'run'
result?: QueryResult
databaseContext: NotebookDatabaseContext
}
/**
* A single-character gutter marker per change type The glyph is decorative —
* `changeLabel` carries the same information into the row's accessible name and its tooltip.
*/
const CHANGE_MARKERS = {
added: { glyph: '+', changeLabel: 'Added', className: 'text-brand-600' },
removed: { glyph: '−', changeLabel: 'Removed', className: 'text-destructive' },
replaced: { glyph: '~', changeLabel: 'Replaced', className: 'text-warning-600' },
moved: { glyph: '↕', changeLabel: 'Moved', className: 'text-foreground-lighter' },
unchanged: { glyph: '', changeLabel: 'Unchanged', className: '' },
} as const
type ChangeMarker = (typeof CHANGE_MARKERS)[keyof typeof CHANGE_MARKERS]
/** The cell a row is labelled by — for a replacement, the proposed cell rather than the current one. */
function getEntryCell(entry: NotebookCellDiffEntry): CellWire | AgentCell {
return entry._tag === 'replaced' ? entry.after : entry.cell
}
/** One row of the diff card: a header line that collapses to a single row, plus its content. */
export const AssistantNotebookPreviewCell = ({
entry,
isExpanded,
onExpandedChange,
mode,
result,
databaseContext,
}: AssistantNotebookPreviewCellProps) => {
const marker = CHANGE_MARKERS[entry._tag]
const isRemoved = entry._tag === 'removed'
const cell = getEntryCell(entry)
const label = getCellLabel(cell)
const metadata = getEntryMetadata(entry, databaseContext)
return (
<Collapsible open={isExpanded} onOpenChange={onExpandedChange}>
<CollapsibleTrigger
aria-label={`${marker.changeLabel} ${label}`}
className="group flex w-full items-center gap-2 bg-muted px-3 py-2 text-left transition-colors hover:bg-accent"
>
{mode === 'update' && <ChangeGlyph marker={marker} />}
<ChevronRightIcon
size={12}
className="shrink-0 text-foreground-lighter transition-transform group-data-[state=open]:rotate-90"
/>
<CellTypeIcon cell={cell} />
<span
className={cn(
'min-w-0 flex-1 truncate text-sm text-foreground',
isRemoved && 'text-foreground-lighter line-through'
)}
>
{label}
</span>
{metadata.status !== 'hidden' ? (
<span className="min-w-0 max-w-[45%] shrink truncate text-sm text-muted-foreground">
{metadata.status === 'loading' ? (
<span className="flex items-center gap-1.5">
<span className="animate-spin">
<Loader2Icon aria-hidden size={12} />
</span>
Loading database…
</span>
) : (
metadata.text
)}
</span>
) : null}
</CollapsibleTrigger>
<CollapsibleContent>
<div className="border-t">
<CellBody entry={entry} />
</div>
</CollapsibleContent>
{result !== undefined && cell._tag !== 'markdown_cell' && (
<QueryCellResult cell={cell} result={result} />
)}
</Collapsible>
)
}
const QueryCellResult = ({
cell,
result,
}: {
cell: Extract<CellWire | AgentCell, { _tag: 'database_cell' | 'log_cell' }>
result: QueryResult
}) => {
const rowCount = result.rows?.length ?? 0
const rowLimit = cell._tag === 'database_cell' ? cell.row_limit : undefined
return (
<>
<ExplorerQueryResults
className={cn(
'border-t',
rowCount === 0 ? 'min-h-20 items-center justify-center' : 'h-56 overflow-x-auto'
)}
>
<QueryResultRenderer view={cell.view ?? 'table'} result={result} chart={cell.chart} />
</ExplorerQueryResults>
<QueryResultFooter
results={result.rows}
count={rowCount}
rowLimit={rowLimit}
fileName={cell.title}
/>
</>
)
}
/**
* The gutter glyph, with a tooltip naming the change type it stands for. The glyph stays
* `aria-hidden` — the row's `aria-label` already carries the same word — so the tooltip is a
* pointer affordance rather than a second announcement.
*/
const ChangeGlyph = ({ marker }: { marker: ChangeMarker }) => {
const className = cn('w-3 shrink-0 text-center font-mono text-xs leading-none', marker.className)
// An unchanged cell has no glyph, so there is nothing to explain — render the spacer alone.
if (!marker.glyph) return <span aria-hidden className={className} />
return (
<Tooltip>
<TooltipTrigger asChild>
<span aria-hidden className={className}>
{marker.glyph}
</span>
</TooltipTrigger>
<TooltipContent side="left">{marker.changeLabel}</TooltipContent>
</Tooltip>
)
}
/** Same icons the notebook tab uses for query vs markdown cells. */
const CellTypeIcon = ({ cell }: { cell: CellWire | AgentCell }) => {
const Icon = cell._tag === 'markdown_cell' ? FileTextIcon : SquareCodeIcon
return <Icon aria-hidden size={14} className="shrink-0 text-foreground-muted" />
}
const CellBody = ({ entry }: { entry: NotebookCellDiffEntry }) =>
entry._tag === 'replaced' ? (
<ReplacedCellBody before={entry.before} after={entry.after} />
) : (
<CellSource cell={entry.cell} />
)
const ReplacedCellBody = ({ before, after }: { before: CellWire; after: AgentCell }) => (
<DiffEditor
original={getCellSourceText(before)}
modified={getCellSourceText(after)}
language={getCellMonacoLanguage(after)}
height={240}
/>
)
/**
* The cell's source, always rendered as literal text via `CodeBlock` — agent-authored markdown
* must never be interpreted into real DOM nodes.
*/
const CellSource = ({ cell }: { cell: CellWire | AgentCell }) => (
<CodeBlock
hideCopy
hideLineNumbers
language={getCellCodeBlockLanguage(cell)}
value={getCellSourceText(cell)}
wrapLongLines
className="wrap-break-word rounded-none border-0 px-3! py-2! text-xs"
wrapperClassName="max-w-none"
/>
)