Projects & Data

delete(input: { project: string; table: string; id: string; }): Promise<{ deleted: number; }>;

get(input: { project: string; table: string; id: string; }): Promise<{ row: DataRow; }>;

insert(input: { project: string; table: string; values: DataRow; }): Promise<{ row: DataRow; }>;

list(input: { project: string; table: string; limit?: number; offset?: number; }): Promise<{ rows: DataRow[]; }>;

update(input: { project: string; table: string; id: string; values: DataRow; }): Promise<{ row: DataRow; }>;

Define a new table in the project's `data` schema (id/created_at/updated_at are added automatically).

createTable(input: { project: string; name: string; columns?: DataColumnDef[]; }): Promise<{ table: string; columns: DataColumnDef[]; }>;

listTables(input: { project: string; }): Promise<{ tables: string[]; }>;

create(input: { slug: string; name?: string; organizationId?: string; }): Promise<CreateProjectResult>;

Soft-deprovision: mark the project deleted + free its pool. The database is kept (recoverable); a hard drop is a separate admin step.

delete(input: { id?: string; slug?: string; }): Promise<{ project: ProjectInfo; deprovisioned: true; }>;

get(input: { id?: string; slug?: string; }): Promise<{ project: ProjectInfo; }>;

list(): Promise<{ projects: ProjectInfo[]; }>;