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 { QueryTab } from "@/types/database";
import type { TabResultSnapshot } from "@/lib/tabs/tabResultCache";
export function queryResultLifecycleSnapshot(): TabResultSnapshot {
const first = {
columns: ["id", "name"],
rows: [[1, "Ada"]],
affected_rows: 0,
execution_time_ms: 4,
sourceStatement: "SELECT id, name FROM users",
};
const second = {
columns: ["count"],
rows: [[1]],
affected_rows: 0,
execution_time_ms: 2,
sourceStatement: "SELECT COUNT(*) FROM users",
};
const resultRuns: NonNullable<QueryTab["resultRuns"]> = [
{
id: "run-1",
sequence: 1,
result: first,
results: [first, second],
activeResultIndex: 0,
resultLocalSortOriginalRows: [[1, "Ada"]],
resultBaseSql: "SELECT id, name FROM users",
resultPageSql: "SELECT id, name FROM users LIMIT 100 OFFSET 200",
resultPageLimit: 100,
resultPageOffset: 200,
tableMeta: {
schema: "public",
tableName: "users",
tableType: "TABLE",
columns: [{ name: "id", data_type: "integer", nullable: false }],
primaryKeys: ["id"],
},
},
];
return {
result: first,
results: [first, second],
activeResultIndex: 0,
resultLocalSortOriginalRows: [[1, "Ada"]],
resultRuns,
activeResultRunId: "run-1",
queryAnalysis: { tableName: "users", schema: "public", allowInsert: true, allowInsertDelete: true },
querySourceColumns: ["id", "name"],
tableMeta: resultRuns[0].tableMeta,
resultPageSql: "SELECT id, name FROM users LIMIT 100 OFFSET 200",
resultPageLimit: 100,
resultPageOffset: 200,
resultCountSql: "SELECT COUNT(*) FROM users",
resultTotalRowCount: 301,
cachedAt: 1,
};
}