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 { SavedSqlFile, SavedSqlFolder } from "@/types/database";
import type { SavedSqlExecutionTarget } from "@/lib/savedSql/savedSqlExecutionTarget";
export interface SavedSqlBatchTargetSelection {
connectionId: string;
database: string;
catalog?: string;
}
export interface SavedSqlBatchReassignment {
target: SavedSqlExecutionTarget;
folderId?: string;
}
function normalizedCatalog(catalog: string | null | undefined): string | undefined {
return catalog || undefined;
}
export function savedSqlBatchReassignment(file: SavedSqlFile, folder: SavedSqlFolder | undefined, selection: SavedSqlBatchTargetSelection): SavedSqlBatchReassignment {
const catalog = normalizedCatalog(selection.catalog);
const keepsNamespace = file.connectionId === selection.connectionId && normalizedCatalog(file.catalog) === catalog && file.database === selection.database;
return {
target: {
connectionId: selection.connectionId,
database: selection.database,
catalog,
schema: keepsNamespace ? file.schema : undefined,
},
folderId: folder?.id === file.folderId ? file.folderId : undefined,
};
}