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 { BackendErrorTranslate } from "@/i18n/backend-errors";
import type { ConnectionConfig, DatabaseType } from "@/types/database";
import { supportsMysqlAutoIncrement, type MysqlAutoIncrementSqlOptions } from "@/lib/database/dbAdminSql";
import type { EditableStructureColumn } from "@/lib/table/tableStructureEditorSql";
export interface MysqlAutoIncrementCounterDraft {
value: string | undefined;
originalValue: string | undefined;
}
export function mysqlAutoIncrementCounterDraft(value: string | null): MysqlAutoIncrementCounterDraft {
const current = value ?? undefined;
return { value: current, originalValue: current };
}
export function refreshMysqlAutoIncrementCounterDraft(serverValue: string | null, current: MysqlAutoIncrementCounterDraft, preserveDraft: boolean): MysqlAutoIncrementCounterDraft {
const server = mysqlAutoIncrementCounterDraft(serverValue);
if (!preserveDraft || current.value === current.originalValue) return server;
return { value: current.value, originalValue: server.originalValue };
}
export function canEditMysqlAutoIncrementCounter(connection: Pick<ConnectionConfig, "db_type" | "driver_profile"> | undefined, _isCreateMode: boolean, columns: readonly EditableStructureColumn[]): boolean {
if (!supportsMysqlAutoIncrement(connection)) return false;
return columns.some((column) => !column.markedForDrop && column.extra.autoIncrement === true);
}
export interface BuildMysqlAutoIncrementCounterStatementOptions extends Omit<MysqlAutoIncrementSqlOptions, "databaseType" | "value"> {
enabled: boolean;
databaseType: DatabaseType | undefined;
value: string | undefined;
originalValue: string | undefined;
buildSql: (options: MysqlAutoIncrementSqlOptions) => Promise<string>;
}
export async function buildMysqlAutoIncrementCounterStatement({ enabled, originalValue, buildSql, ...options }: BuildMysqlAutoIncrementCounterStatementOptions): Promise<string | undefined> {
const { databaseType, value } = options;
if (!enabled || databaseType === undefined || originalValue === undefined || value === undefined || value === originalValue) {
return undefined;
}
return buildSql({ ...options, databaseType, value });
}
/** Translate only recognized structure warnings; preserve other backend diagnostics. */
export function translateMysqlAutoIncrementWarning(t: BackendErrorTranslate, warning: string): string {
if (warning === "MySQL allows only one AUTO_INCREMENT column per table.") {
return t("structureEditor.mysqlAutoIncrementSingleColumn");
}
if (warning === "AUTO_INCREMENT requires an auto-increment column." || warning === "AUTO_INCREMENT requires a native MySQL auto-increment column.") {
return t("structureEditor.mysqlAutoIncrementRequiresNativeColumn");
}
const missingIndex = /^AUTO_INCREMENT column "([\s\S]*)" requires a supporting index \(first key column for InnoDB\)\.$/.exec(warning);
if (missingIndex) return t("structureEditor.mysqlAutoIncrementRequiresIndex", { column: missingIndex[1] });
return warning;
}