25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
import type { QueryResult } from "@/types/database";
/** The extra row proves availability but must never enter the displayed result. */
export function trimQueryPageProbe<T extends QueryResult>(result: T, pageLimit: number): T {
if (result.execution_error || result.server_message || result.columns.length === 0) return result;
const hasNextPage = result.rows.length > pageLimit;
return {
...result,
// A truncated response can prove more rows exist, but cannot prove exhaustion.
page_has_more: hasNextPage ? true : result.truncated === true || result.has_more === true ? undefined : false,
rows: result.rows.slice(0, pageLimit),
spatial_values: result.spatial_values?.slice(0, pageLimit),
large_value_cells: result.large_value_cells?.filter((cell) => cell.row_index < pageLimit),
raw_key_cells: result.raw_key_cells?.filter((cell) => cell.row_index < pageLimit),
// Keep discarded preview refs owned by the result until its normal cleanup.
large_value_refs: result.large_value_refs,
};
}
/** Remove only the trailing helper identified by the pagination plan. */
export function stripPaginationRowNumber(result: QueryResult, column: string | undefined): QueryResult {
const index = result.columns.length - 1;
if (!column || index < 0 || result.columns[index] !== column) return result;
return {
...result,
columns: result.columns.slice(0, index),
rows: result.rows.map((row) => row.slice(0, index)),
column_types: result.column_types?.slice(0, index),
column_sortables: result.column_sortables?.slice(0, index),
spatial_values: result.spatial_values?.map((row) => row.slice(0, index)),
spatial_columns: result.spatial_columns?.filter((column) => column.column_index < index),
large_value_cells: result.large_value_cells?.filter((cell) => cell.column_index < index),
raw_key_cells: result.raw_key_cells?.filter((cell) => cell.column_index < index),
hidden_column_indexes: result.hidden_column_indexes?.filter((columnIndex) => columnIndex < index),
};
}