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 { getActivePinia } from "pinia";
import type { HistoryEntry } from "@/lib/backend/api";
import { classifySqlActivityKind, primarySqlOperation } from "@/lib/history/historyActivityKind";
import { useHistoryStore } from "@/stores/historyStore";
export interface RecordTableMutationHistoryOptions {
connectionId: string;
connectionName?: string;
database: string;
sql: string;
elapsedMs?: number;
success?: boolean;
error?: string;
target?: string;
affectedRows?: number;
}
export type TableMutationHistoryStore = {
add: (entry: Omit<HistoryEntry, "id" | "executed_at">) => Promise<void>;
};
export function getTableMutationHistoryStoreOrNull(): TableMutationHistoryStore | null {
try {
if (!getActivePinia()) return null;
return useHistoryStore();
} catch {
return null;
}
}
export async function recordTableMutationHistory(historyStore: TableMutationHistoryStore | undefined | null, options: RecordTableMutationHistoryOptions): Promise<void> {
if (!historyStore) return;
const sql = options.sql.trim();
if (!sql || !options.connectionId) return;
const success = options.success ?? true;
await historyStore.add({
connection_id: options.connectionId,
connection_name: options.connectionName || "",
database: options.database,
sql,
execution_time_ms: Math.max(0, options.elapsedMs ?? 0),
success,
error: options.error,
activity_kind: classifySqlActivityKind(sql),
operation: primarySqlOperation(sql),
target: options.target,
affected_rows: success ? options.affectedRows : undefined,
});
}