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
<script setup lang="ts">
import { computed, ref, useId, watch } from "vue";
import { useI18n } from "vue-i18n";
import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog";
import { Info } from "@lucide/vue";
import { Tooltip, TooltipContent, TooltipTrigger } from "@/components/ui/tooltip";
import { Button } from "@/components/ui/button";
import { parseTableColumnDefinitions } from "@/lib/table/tableColumnDefinitionPaste";
const props = defineProps<{ open: boolean; disabled: boolean; existingNames: string[] }>();
const emit = defineEmits<{ "update:open": [open: boolean]; import: [text: string] }>();
const { t } = useI18n();
const text = ref("");
const inputId = useId();
const inputRef = ref<HTMLTextAreaElement>();
const result = computed(() => parseTableColumnDefinitions(text.value, props.existingNames));
const canImport = computed(() => !props.disabled && result.value.columns.length > 0 && !result.value.diagnostics.length);
const example = "create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at',\nupdate_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at'";
watch(
() => props.open,
() => {
text.value = "";
},
);
function submit() {
if (canImport.value) emit("import", text.value);
}
function focusInput(event: Event) {
if (!inputRef.value || props.disabled) return;
event.preventDefault();
inputRef.value.focus({ preventScroll: true });
}
function onKeydown(event: KeyboardEvent) {
// Reka handles Escape at window level. Other keys stay inside the dialog so
// editor shortcuts (such as Ctrl/Cmd+S) cannot save the underlying table.
if (event.key !== "Escape") event.stopPropagation();
}
</script>
<template>
<Dialog :open="open" @update:open="emit('update:open', $event)">
<DialogContent class="flex max-h-[85vh] max-w-3xl flex-col" @keydown="onKeydown" @open-auto-focus="focusInput">
<DialogHeader>
<DialogTitle>{{ t("tableColumnPaste.title") }}</DialogTitle>
<DialogDescription>{{ t("tableColumnPaste.description") }}</DialogDescription>
</DialogHeader>
<div class="min-h-0 space-y-3 overflow-y-auto">
<div class="space-y-2 text-sm">
<div class="flex items-center gap-1.5">
<label :for="inputId">{{ t("tableColumnPaste.input") }}</label>
<Tooltip :delay-duration="200">
<TooltipTrigger as-child>
<button type="button" class="inline-flex size-6 items-center justify-center rounded text-muted-foreground hover:text-foreground focus-visible:outline-none focus-visible:ring-2 focus-visible:ring-ring" :aria-label="t('tableColumnPaste.helpTitle')">
<Info class="size-4" aria-hidden="true" />
</button>
</TooltipTrigger>
<TooltipContent side="bottom" align="start" class="block max-h-[60vh] w-[44rem] max-w-[calc(100vw-2rem)] overflow-y-auto whitespace-normal p-3 text-left leading-relaxed">
<p class="font-semibold">{{ t("tableColumnPaste.helpTitle") }}</p>
<ul class="mt-2 list-disc space-y-1 pl-5">
<li>{{ t("tableColumnPaste.helpSourceDdl") }}</li>
<li>{{ t("tableColumnPaste.helpSourceQuery") }}</li>
<li>{{ t("tableColumnPaste.helpSourceCopy") }}</li>
</ul>
<p class="mt-2">{{ t("tableColumnPaste.helpFormats") }}</p>
<p class="mt-2">{{ t("tableColumnPaste.helpNotes") }}</p>
</TooltipContent>
</Tooltip>
</div>
<textarea
ref="inputRef"
:id="inputId"
v-model="text"
:disabled="disabled"
:placeholder="example"
:aria-invalid="result.diagnostics.length > 0"
spellcheck="false"
rows="7"
class="w-full resize-y rounded-md border border-input bg-background px-3 py-2 font-mono text-sm focus-visible:outline-none focus-visible:ring-2 focus-visible:ring-ring disabled:opacity-50"
data-column-paste-input
/>
</div>
<div v-for="diagnostic in result.diagnostics" :key="diagnostic.code" role="alert" class="rounded-md border border-destructive/30 bg-destructive/5 p-3 text-sm text-destructive">
<p>{{ t("tableColumnPaste.position", { line: diagnostic.line, column: diagnostic.column }) }} · {{ t(`tableColumnPaste.${diagnostic.code}`) }}</p>
<code v-if="diagnostic.detail" class="mt-1 block max-h-20 overflow-auto whitespace-pre-wrap break-all">{{ diagnostic.detail }}</code>
</div>
<div v-if="result.columns.length" class="space-y-2">
<p class="text-sm text-muted-foreground" aria-live="polite">{{ t("tableColumnPaste.preview", { count: result.columns.length }) }}</p>
<div class="max-h-64 overflow-auto rounded-md border">
<table class="w-full text-left text-xs">
<thead class="sticky top-0 bg-muted">
<tr>
<th class="p-2">{{ t("structureEditor.columnName") }}</th>
<th class="p-2">{{ t("tableColumnPaste.typeAndAttributes") }}</th>
<th class="p-2">{{ t("structureEditor.nullable") }}</th>
<th class="p-2">{{ t("structureEditor.defaultValue") }}</th>
<th class="p-2">{{ t("structureEditor.comment") }}</th>
</tr>
</thead>
<tbody>
<tr v-for="column in result.columns" :key="column.name" class="border-t align-top">
<td class="break-all p-2 font-mono">{{ column.name }}</td>
<td class="break-all p-2 font-mono">
{{ column.dataType }}
<div v-if="column.extra.autoIncrement">AUTO_INCREMENT</div>
<div v-if="column.characterSet">CHARACTER SET {{ column.characterSet }}</div>
<div v-if="column.collation">COLLATE {{ column.collation }}</div>
</td>
<td class="whitespace-nowrap p-2 font-mono">{{ column.isNullable ? "NULL" : "NOT NULL" }}</td>
<td class="break-all p-2 font-mono">
{{ column.defaultValue }}
<div v-if="column.extra.onUpdateCurrentTimestamp">ON UPDATE CURRENT_TIMESTAMP{{ column.dataType.match(/\(\s*[0-6]\s*\)/)?.[0] ?? "" }}</div>
</td>
<td class="whitespace-pre-wrap break-all p-2">{{ column.comment }}</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<DialogFooter>
<Button variant="outline" @click="emit('update:open', false)">{{ t("common.cancel") }}</Button>
<Button :disabled="!canImport" data-column-paste-submit @click="submit">{{ t("tableColumnPaste.import", { count: result.columns.length }) }}</Button>
</DialogFooter>
</DialogContent>
</Dialog>
</template>