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 { DEFAULT_SQL_INSERT_DIALECT, DEFAULT_SQL_INSERT_MODE, type SqlInsertDialect, type SqlInsertMode } from "./sqlInsertMode";
export interface DatabaseExportSavedOptions {
includeStructure: boolean;
includeData: boolean;
insertDialect: SqlInsertDialect;
insertMode: SqlInsertMode;
includeObjects: boolean;
includeCreateDatabase: boolean;
dropTableIfExists: boolean;
omitAutoIncrement: boolean;
preserveOriginalLanguage: boolean;
splitSqlOutput: boolean;
splitSqlPartMaxMb: number;
}
export const MIN_SPLIT_SQL_PART_MB = 1;
export const MAX_SPLIT_SQL_PART_MB = 4096;
export const DEFAULT_DATABASE_EXPORT_OPTIONS: DatabaseExportSavedOptions = {
includeStructure: true,
includeData: true,
insertDialect: DEFAULT_SQL_INSERT_DIALECT,
insertMode: DEFAULT_SQL_INSERT_MODE,
includeObjects: true,
includeCreateDatabase: false,
dropTableIfExists: false,
omitAutoIncrement: false,
preserveOriginalLanguage: false,
splitSqlOutput: false,
splitSqlPartMaxMb: 100,
};
export const DATABASE_EXPORT_OPTIONS_STORAGE_KEY = "dbx-database-export-last-options-v1";
export function loadSavedDatabaseExportOptions(storage?: Pick<Storage, "getItem">): DatabaseExportSavedOptions {
try {
const store = storage ?? (typeof localStorage !== "undefined" ? localStorage : undefined);
if (!store) return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };
const raw = store.getItem(DATABASE_EXPORT_OPTIONS_STORAGE_KEY);
if (!raw) return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };
const parsed = JSON.parse(raw);
if (!parsed || typeof parsed !== "object") return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };
return {
includeStructure: typeof parsed.includeStructure === "boolean" ? parsed.includeStructure : DEFAULT_DATABASE_EXPORT_OPTIONS.includeStructure,
includeData: typeof parsed.includeData === "boolean" ? parsed.includeData : DEFAULT_DATABASE_EXPORT_OPTIONS.includeData,
insertDialect: parsed.insertDialect === "standard" ? "standard" : DEFAULT_DATABASE_EXPORT_OPTIONS.insertDialect,
insertMode: parsed.insertMode === "single" ? "single" : DEFAULT_DATABASE_EXPORT_OPTIONS.insertMode,
includeObjects: typeof parsed.includeObjects === "boolean" ? parsed.includeObjects : DEFAULT_DATABASE_EXPORT_OPTIONS.includeObjects,
includeCreateDatabase: typeof parsed.includeCreateDatabase === "boolean" ? parsed.includeCreateDatabase : DEFAULT_DATABASE_EXPORT_OPTIONS.includeCreateDatabase,
dropTableIfExists: typeof parsed.dropTableIfExists === "boolean" ? parsed.dropTableIfExists : DEFAULT_DATABASE_EXPORT_OPTIONS.dropTableIfExists,
omitAutoIncrement: typeof parsed.omitAutoIncrement === "boolean" ? parsed.omitAutoIncrement : DEFAULT_DATABASE_EXPORT_OPTIONS.omitAutoIncrement,
preserveOriginalLanguage: typeof parsed.preserveOriginalLanguage === "boolean" ? parsed.preserveOriginalLanguage : DEFAULT_DATABASE_EXPORT_OPTIONS.preserveOriginalLanguage,
splitSqlOutput: typeof parsed.splitSqlOutput === "boolean" ? parsed.splitSqlOutput : DEFAULT_DATABASE_EXPORT_OPTIONS.splitSqlOutput,
splitSqlPartMaxMb: typeof parsed.splitSqlPartMaxMb === "number" && Number.isFinite(parsed.splitSqlPartMaxMb) ? Math.min(MAX_SPLIT_SQL_PART_MB, Math.max(MIN_SPLIT_SQL_PART_MB, Math.round(parsed.splitSqlPartMaxMb))) : DEFAULT_DATABASE_EXPORT_OPTIONS.splitSqlPartMaxMb,
};
} catch {
return { ...DEFAULT_DATABASE_EXPORT_OPTIONS };
}
}
export function saveDatabaseExportOptions(options: Partial<DatabaseExportSavedOptions>, storage?: Pick<Storage, "setItem" | "getItem">): void {
try {
const store = storage ?? (typeof localStorage !== "undefined" ? localStorage : undefined);
if (!store) return;
const current = loadSavedDatabaseExportOptions(store);
const updated: DatabaseExportSavedOptions = {
...current,
...options,
};
store.setItem(DATABASE_EXPORT_OPTIONS_STORAGE_KEY, JSON.stringify(updated));
} catch {
// Ignore storage write failures (quota exceeded, private browsing, etc.)
}
}
export function sortDatabaseTableNames(names: string[]): string[] {
// Pin the collation so the order does not shift with the OS locale.
return [...names].sort((a, b) => a.localeCompare(b, "en", { sensitivity: "base" }));
}
/** Use the selected table as the suggested filename when exporting one table. */
export function databaseExportFileStem(database: string, selectedTables: readonly string[]): string {
return selectedTables.length === 1 ? selectedTables[0]! : database;
}