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, nextTick, onUnmounted, ref, watch, watchEffect } from "vue";
import { useI18n } from "vue-i18n";
import {
Play,
FastForward,
SquarePlay,
CirclePlay,
Loader2,
Square,
Database,
Check,
Table2,
AlignLeft,
GitBranch,
Save,
FolderOpen,
X,
Shield,
Download,
RotateCcw,
AlertTriangle,
ClipboardPaste,
Minimize2,
FoldVertical,
UnfoldVertical,
SpellCheck2,
Layers,
MoreHorizontal,
BetweenVerticalStart,
Eye,
WrapText,
RefreshCw,
UserRound,
Copy,
} from "@lucide/vue";
import { supportsInsertValueHints } from "@/lib/editor/codemirrorInsertValueHints";
import { Button } from "@/components/ui/button";
import { SearchableSelect } from "@/components/ui/searchable-select";
import { DropdownMenu, DropdownMenuCheckboxItem, DropdownMenuContent, DropdownMenuItem, DropdownMenuTrigger } from "@/components/ui/dropdown-menu";
import { Tooltip, TooltipTrigger, TooltipContent } from "@/components/ui/tooltip";
import LightTooltip from "@/components/ui/LightTooltip.vue";
import TruncatedTextTooltip from "@/components/ui/TruncatedTextTooltip.vue";
import DatabaseIcon from "@/components/icons/DatabaseIcon.vue";
import ConnectionTreeSelect from "@/components/connection/ConnectionTreeSelect.vue";
import ConnectionDetailContent from "@/components/connection/ConnectionDetailContent.vue";
import ProductionContextBadge from "@/components/common/ProductionContextBadge.vue";
import { useConnectionStore } from "@/stores/connectionStore";
import { useQueryStore } from "@/stores/queryStore";
import { useSettingsStore } from "@/stores/settingsStore";
import { catalogDatabaseOptionsKey, databaseAfterCatalogChange, normalizedQueryTabCatalog, queryCatalogSelectorVisible, selectedQueryCatalogName, useDatabaseOptions } from "@/composables/useDatabaseOptions";
import { useSchemaOptions } from "@/composables/useSchemaOptions";
import { connectionIconType } from "@/lib/connection/connectionPresentation";
import { formatDatabaseLabel, isDefaultDatabase } from "@/lib/database/defaultDatabase";
import { isSingleDatabase, supportsClearableQuerySchema, supportsSqlInListPaste, supportsTransaction as supportsTransactionFeature } from "@/lib/database/databaseCapabilities";
import { supportsQueryExecution } from "@/lib/database/databaseFeatureSupport";
import { connectionIsDorisFamilyCatalogCapable } from "@/lib/database/databaseFeatureSupport";
import { hexToRgba } from "@/lib/common/color";
import { productionContextForDatabase } from "@/lib/database/productionSafety";
import { formatShortcutDisplay, formatShortcutTooltip } from "@/lib/editor/shortcutDisplay";
import { resolveNextEditorToolbarTier, type EditorToolbarTier } from "@/lib/tabs/editorToolbarLayout";
import { canSaveSqlTab } from "@/lib/tabs/sqlTabSaveTarget";
import { looksLikeDmlStatement } from "@/lib/sql/dmlChangePreview";
import { canFormatSqlForDatabaseType } from "@/lib/sql/sqlFormatter";
import { copyToClipboard } from "@/lib/common/clipboard";
import { useToast } from "@/composables/useToast";
import type { QueryTab, ConnectionConfig } from "@/types/database";
import type { MongoQueryLanguage } from "@/lib/mongo/mongoSql";
import { isObjectDependencySection } from "@/lib/database/objectDependencyDetails";
import { connectionDetailRows } from "@/lib/connection/connectionDetailRows";
import { findConnectionGroupPath } from "@/lib/sidebar/sidebarLayout";
const props = defineProps<{
activeTab: QueryTab;
activeConnection?: ConnectionConfig;
executableSql: string;
/** 来自 QueryEditor 的实时“当前语句是否为可预览 DML”信号;未提供时退回可编辑文档启发式。 */
canPreviewChanges?: boolean;
explainMode?: string;
blockDangerousRedisCommands?: boolean;
sqlKeywordCase: "preserve" | "upper" | "lower";
databaseRequiredSignal?: number;
/** When non-zero, highlights and opens the connection picker so the user selects a connection. */
connectionRequiredSignal?: number;
autoCommit?: boolean;
txnSessionId?: string;
txnAutoRolledBack?: boolean;
/** Oracle-only: whether the current manual Oracle session executed a statement
* DBX cannot prove read-only. Commit/Rollback are hidden while false. */
txnPossiblyDirty?: boolean;
/** Oracle manual mode derived from the resolved database type (not raw
* db_type, which can be the agent transport). */
stickyProvenReadOnlyState?: boolean;
/** Auto-commit tabs (`Tx:A`): the tab's own connection holds a transaction
* the user opened explicitly (`BEGIN` / `START TRANSACTION`) that DBX kept
* open. Commit/Rollback act on that transaction. */
autoCommitOpenTransaction?: boolean;
/** Auto-commit tab: the backend rolled back an explicit transaction this tab
* left open (the tab did not opt into keeping them). */
autoCommitTxnRolledBack?: boolean;
/** Auto-commit tab: the backend rolled back an implicitly opened transaction
* (`SET autocommit = 0`), reported once per connection. */
autoCommitSessionTxnRolledBack?: boolean;
}>();
const emit = defineEmits<{
toolbarExecute: [source: "pointer" | "keyboard"];
toolbarExecuteAll: [source: "pointer" | "keyboard"];
toolbarExecuteInNewResultTab: [source: "pointer" | "keyboard"];
executePointerDown: [];
cancel: [];
previewChanges: [];
explain: [];
"update:explainMode": [mode: "explain" | "autotrace"];
formatSql: [];
compressSql: [];
foldAll: [];
unfoldAll: [];
toggleSqlKeywordCase: [];
saveSql: [tabId: string];
"change-encoding": [value: NonNullable<QueryTab["externalSqlEncoding"]>];
openSql: [];
importResultArchive: [];
pasteSqlInCondition: [];
multiExecute: [];
changeConnection: [connectionId: string];
changeCatalog: [catalog: string | undefined, database: string];
changeDatabase: [database: string];
changeSchema: [schema: string | undefined];
setDefaultDatabase: [];
clearDefaultDatabase: [];
"update:blockDangerousRedisCommands": [value: boolean];
"update:autoCommit": [value: boolean];
commit: [];
rollback: [];
dismissTxnRolledBack: [];
dismissAutoCommitTxnRolledBack: [];
dismissAutoCommitSessionTxnRolledBack: [];
}>();
const { t } = useI18n();
const { toast } = useToast();
const connectionStore = useConnectionStore();
const queryStore = useQueryStore();
const settingsStore = useSettingsStore();
const showMongoSqlToggle = computed(() => props.activeConnection?.db_type === "mongodb" && props.activeTab.mode === "query");
const mongoQueryLanguage = computed(() => props.activeTab.mongoQueryLanguage ?? "shell");
function setMongoQueryLanguage(language: MongoQueryLanguage) {
queryStore.setMongoQueryLanguage(props.activeTab.id, language);
}
async function copyGeneratedMongoShell() {
const shell = props.activeTab.mongoGeneratedShell;
if (!shell) return;
await copyToClipboard(shell);
toast(t("toolbar.mongoShellCopied"));
}
const { databaseOptions, loadingDatabaseOptions, loadDatabaseOptions, catalogOptions, loadingCatalogOptions, loadCatalogOptions, catalogDatabaseOptions, loadingCatalogDatabaseOptions, loadCatalogDatabaseOptions } = useDatabaseOptions();
const { loadSchemaOptions, getSchemaOptionsForDb, isLoadingSchemas, isSchemaAware } = useSchemaOptions();
const toolbarRootRef = ref<HTMLElement | null>(null);
const toolbarActionsRef = ref<HTMLElement | null>(null);
const toolbarTier = ref<EditorToolbarTier>(0);
// Available width when the current tier was condensed into; anchors the
// step-down hysteresis so a static narrow layout cannot oscillate.
const condensedAtWidth = ref(0);
const expandedTierRequiredWidths: Partial<Record<EditorToolbarTier, number>> = {};
let toolbarResizeObserver: ResizeObserver | undefined;
let toolbarMeasureRaf = 0;
function measureToolbarTier() {
const element = toolbarActionsRef.value;
const root = toolbarRootRef.value;
if (!element || !root) {
return;
}
const availableWidth = root.clientWidth;
// Use the stable full-row coordinate space, including the right controls.
// Tier-dependent helpers must not appear to grow the pane when they hide.
const contentWidth = element.scrollWidth + availableWidth - element.clientWidth;
const next = resolveNextEditorToolbarTier({
tier: toolbarTier.value,
availableWidth,
contentWidth,
condensedAtWidth: condensedAtWidth.value,
expandedTierRequiredWidths,
});
if (next !== toolbarTier.value) {
if (next > toolbarTier.value) {
const currentTier = toolbarTier.value;
expandedTierRequiredWidths[currentTier] = Math.max(expandedTierRequiredWidths[currentTier] ?? 0, contentWidth);
condensedAtWidth.value = availableWidth;
}
toolbarTier.value = next;
}
}
function scheduleToolbarMeasurement() {
if (toolbarMeasureRaf) {
return;
}
toolbarMeasureRaf = requestAnimationFrame(() => {
toolbarMeasureRaf = 0;
measureToolbarTier();
});
}
// Hiding or restoring controls changes the row content without resizing the
// toolbar box, so every tier change re-measures until the row settles.
watch(toolbarTier, () => {
void nextTick(scheduleToolbarMeasurement);
});
// The visible control set also changes with connection type and transaction
// state; re-measure when those do.
watch(
() => [props.activeConnection?.id, props.activeConnection?.db_type, props.txnSessionId, props.activeTab.isExecuting, props.activeTab.isExplaining] as const,
() => {
void nextTick(scheduleToolbarMeasurement);
},
);
watch(
toolbarRootRef,
(element) => {
toolbarResizeObserver?.disconnect();
toolbarResizeObserver = undefined;
if (element && typeof ResizeObserver !== "undefined") {
toolbarResizeObserver = new ResizeObserver(scheduleToolbarMeasurement);
toolbarResizeObserver.observe(element);
}
void nextTick(scheduleToolbarMeasurement);
},
{ flush: "post" },
);
onUnmounted(() => {
if (toolbarMeasureRaf) {
cancelAnimationFrame(toolbarMeasureRaf);
toolbarMeasureRaf = 0;
}
toolbarResizeObserver?.disconnect();
toolbarResizeObserver = undefined;
});
const activeCatalogs = computed(() => {
const connection = props.activeConnection;
return connection ? (catalogOptions.value[connection.id] ?? []) : [];
});
const activeCatalogNames = computed(() => activeCatalogs.value.map((catalog) => catalog.name));
const catalogSelectorAvailable = computed(() => connectionIsDorisFamilyCatalogCapable(props.activeConnection) && queryCatalogSelectorVisible(activeCatalogs.value));
// Keep connection context controls mounted while the action group condenses.
// Removing them changes the action group's available width and can make the
// tier immediately expand again at the boundary, causing visible flicker.
const showCatalogSelector = computed(() => catalogSelectorAvailable.value);
const activeCatalogValue = computed(() => selectedQueryCatalogName(activeCatalogs.value, props.activeTab.catalog));
const activeCatalogDatabaseKey = computed(() => (props.activeConnection && props.activeTab.catalog ? catalogDatabaseOptionsKey(props.activeConnection.id, props.activeTab.catalog) : ""));
const activeDatabaseOptions = computed(() => {
const connection = props.activeConnection;
if (!connection) return [];
if (props.activeTab.catalog) return catalogDatabaseOptions.value[activeCatalogDatabaseKey.value] ?? [];
return databaseOptions.value[connection.id] ?? [];
});
const loadingActiveDatabaseOptions = computed(() => {
const connection = props.activeConnection;
if (!connection) return false;
if (props.activeTab.catalog) return loadingCatalogDatabaseOptions.value[activeCatalogDatabaseKey.value] ?? false;
return loadingDatabaseOptions.value[connection.id] ?? false;
});
const switchingCatalog = ref(false);
const activeDatabaseValue = computed(() => props.activeTab.database || "");
const activeProductionContext = computed(() => productionContextForDatabase(props.activeConnection, props.activeTab.database));
const showConnectionProductionBadge = computed(() => activeProductionContext.value.reason === "connection");
const showDatabaseProductionBadge = computed(() => activeProductionContext.value.reason === "database");
const activeConnectionValue = computed(() => props.activeConnection?.id || "");
const activeConnectionDetailRows = computed(() => (props.activeConnection ? connectionDetailRows(props.activeConnection, t) : []));
const activeConnectionGroupPath = computed(() => {
const connection = props.activeConnection;
if (!connection) return "";
return findConnectionGroupPath(connectionStore.sidebarLayout, connection.id)?.join(" / ") || "";
});
const visibleConnectionGroupPath = computed(() => (settingsStore.editorSettings.showConnectionGroupPath ? activeConnectionGroupPath.value : ""));
const activeSchemaValue = computed(() => props.activeTab.schema || "");
// Salesforce identity badge. A Salesforce tab talks to one live org and every grid
// save is a real REST write, so the signed-in user stays visible next to the
// connection controls. Advisory only: Salesforce enforces the actual permissions.
const isSalesforceTab = computed(() => props.activeConnection?.db_type === "salesforce");
const salesforceIdentity = computed(() => (props.activeConnection ? connectionStore.salesforceCurrentUser(props.activeConnection.id) : null));
const salesforceIdentityLabel = computed(() => {
const identity = salesforceIdentity.value;
if (!identity) return "";
const user = identity.username || identity.name || identity.email;
const org = identity.orgName || identity.organizationId;
if (user && org) return `${user} @ ${org}`;
return user || org;
});
const salesforceIdentityTooltip = computed(() => {
const identity = salesforceIdentity.value;
if (!identity) return "";
const lines = [identity.name || identity.username || identity.email, identity.profileName || t("toolbar.salesforceIdentityUnknownProfile")];
if (identity.isAdmin === true) lines.push(t("toolbar.salesforceIdentityAdmin"));
else if (identity.isAdmin === false) lines.push(t("toolbar.salesforceIdentityNonAdmin"));
else lines.push(t("toolbar.salesforceIdentityUnknownRights"));
return lines.filter((line) => !!line).join("\n");
});
watch(
() => [isSalesforceTab.value, props.activeConnection?.id ?? "", connectionStore.connectedIds.has(props.activeConnection?.id ?? "")] as const,
([salesforce, connectionId, connected]) => {
// Never connect on a tab switch: only resolve the identity once the user has
// established the connection themselves. A failed lookup hides the badge.
if (!salesforce || !connected || !connectionId) return;
void connectionStore.loadSalesforceCurrentUser(connectionId);
},
{ immediate: true },
);
const supportsExplain = computed(() => {
const dbType = props.activeConnection?.db_type;
return (
dbType !== "redis" &&
dbType !== "mongodb" &&
dbType !== "elasticsearch" &&
dbType !== "easysearch" &&
dbType !== "meilisearch" &&
dbType !== "solr" &&
dbType !== "couchdb" &&
dbType !== "qdrant" &&
dbType !== "milvus" &&
dbType !== "weaviate" &&
dbType !== "chromadb" &&
dbType !== "etcd" &&
dbType !== "zookeeper" &&
dbType !== "consul" &&
dbType !== "mq" &&
dbType !== "nacos" &&
dbType !== "victoriametrics" &&
dbType !== "salesforce"
);
});
const isSingleDb = computed(() => isSingleDatabase(props.activeConnection?.db_type));
const supportsExPaste = computed(() => supportsSqlInListPaste(props.activeConnection?.db_type));
const supportsTransaction = computed(() => supportsTransactionFeature(props.activeConnection?.db_type));
const hasDefaultDatabaseOption = computed(() => activeDatabaseOptions.value.includes(""));
const schemaDatabaseKey = computed(() => props.activeTab.database || (isSingleDb.value ? "_" : ""));
const saveTooltip = computed(() => {
let label = t("toolbar.saveSql");
if (props.activeTab.objectSource) label = t("objects.saveSource");
else if (props.activeTab.externalSqlPath) label = t("toolbar.saveSqlFile");
return formatShortcutTooltip(label, settingsStore.editorSettings.shortcuts.saveSql);
});
const explainPlanTooltip = computed(() => formatShortcutTooltip(t("toolbar.explainPlan"), settingsStore.editorSettings.shortcuts.explainSql));
const formatSqlTooltip = computed(() => formatShortcutTooltip(t("toolbar.formatSql"), settingsStore.editorSettings.shortcuts.formatSql));
const exPasteSqlInConditionTooltip = computed(() => formatShortcutTooltip(t("toolbar.exPasteSqlInCondition"), settingsStore.editorSettings.shortcuts.exPasteSqlInCondition));
const isObjectSourceTab = computed(() => !!props.activeTab.objectSource || !!props.activeTab.sourceLoad);
const objectSourceRefreshing = computed(() => !!props.activeTab.sourceLoad && !props.activeTab.sourceLoad.error);
function refreshObjectSource() {
if (!isObjectSourceTab.value) return;
if (queryStore.isTabDirty(props.activeTab) && !window.confirm(t("objects.refreshDiscardConfirm"))) return;
queryStore.refreshObjectSourceTab(props.activeTab.id);
}
const executeShortcutDisplay = computed(() => formatShortcutDisplay(settingsStore.editorSettings.shortcuts.executeSql));
const executeShortcutTooltip = computed(() => t("toolbar.executeShortcut", { shortcut: executeShortcutDisplay.value }));
const executeAllShortcutTooltip = computed(() => formatShortcutTooltip(t("toolbar.executeAllSql"), settingsStore.editorSettings.shortcuts.executeAllSql));
const executeInNewResultTabTooltip = computed(() => formatShortcutTooltip(t("settings.shortcutExecuteSqlInNewResultTab"), settingsStore.editorSettings.shortcuts.executeSqlInNewResultTab));
// executableSql 在无选区时可能是整篇文档;只要有 DML 语句出现就显示预览按钮,
// 具体"当前语句"由编辑器(QueryEditor)按执行模式解析。
const DML_KEYWORD_RE = /(^|\s)(update|insert|delete)\s/i;
const canPreviewDml = computed(() => looksLikeDmlStatement(props.executableSql) || DML_KEYWORD_RE.test(props.executableSql));
const previewButtonVisible = computed(() => props.canPreviewChanges ?? canPreviewDml.value);
// DM calls it autotrace, Postgres EXPLAIN ANALYZE, SQL Server the actual execution
// plan (SET STATISTICS XML); all three execute the statement.
const supportsExplainAnalyze = computed(() => {
const dbType = props.activeConnection?.db_type;
return dbType === "dameng" || dbType === "postgres" || dbType === "sqlserver";
});
const explainAnalyzeTooltip = computed(() => {
const dbType = props.activeConnection?.db_type;
if (dbType === "postgres") return t("toolbar.explainAnalyze");
if (dbType === "sqlserver") return t("toolbar.actualPlan");
return t("toolbar.autotrace");
});
const canSaveSql = computed(() => canSaveSqlTab(props.activeTab));
const keywordCaseIsLower = computed(() => props.sqlKeywordCase === "lower");
const keywordCaseToggleTooltip = computed(() => (keywordCaseIsLower.value ? t("toolbar.keywordCaseUpper") : t("toolbar.keywordCaseLower")));
const wordWrapEnabled = computed(() => props.activeTab.forceWordWrap === true || settingsStore.editorSettings.wordWrap);
function toggleWordWrap() {
if (props.activeTab.forceWordWrap) return;
settingsStore.updateEditorSettings({ wordWrap: !wordWrapEnabled.value });
}
const sqlSemanticDiagnosticsEnabled = computed(() => settingsStore.editorSettings.sqlSemanticDiagnosticsEnabled);
const sqlSemanticDiagnosticsToggleTooltip = computed(() => (sqlSemanticDiagnosticsEnabled.value ? t("toolbar.sqlSemanticDiagnosticsToggleOn") : t("toolbar.sqlSemanticDiagnosticsToggleOff")));
const supportsSqlSemanticDiagnosticsToggle = computed(() => {
const dbType = props.activeConnection?.db_type;
return dbType !== "redis" && dbType !== "victoriametrics" && dbType !== "salesforce";
});
function toggleSqlSemanticDiagnostics() {
settingsStore.updateEditorSettings({
sqlSemanticDiagnosticsMode: sqlSemanticDiagnosticsEnabled.value ? "disabled" : "enabled",
});
}
const insertValueHintsEnabled = computed(() => settingsStore.editorSettings.showInsertValueHints);
const insertValueHintsToggleTooltip = computed(() => (insertValueHintsEnabled.value ? t("toolbar.insertValueHintsToggleOn") : t("toolbar.insertValueHintsToggleOff")));
const supportsInsertValueHintsToggle = computed(() => supportsInsertValueHints(props.activeConnection?.db_type));
function toggleInsertValueHints() {
settingsStore.updateEditorSettings({ showInsertValueHints: !insertValueHintsEnabled.value });
}
const isTransactionActive = computed(() => !!props.txnSessionId);
/** Auto-commit tab whose connection holds a transaction the user opened with
* `BEGIN` / `START TRANSACTION` and that DBX kept open (`Tx:A`). */
const hasOpenAutoCommitTransaction = computed(() => props.autoCommitOpenTransaction === true);
const isManualTransactionMode = computed(() => props.autoCommit === false || isTransactionActive.value);
const transactionModeBadge = computed(() => (isManualTransactionMode.value ? "M" : "A"));
// Sticky proven-read-only dialects (Oracle/OceanBase-Oracle/MySQL/PostgreSQL)
// hide Commit/Rollback while the session is clean (no unproven statement
// executed). Every other database keeps the existing rule. An auto-commit tab
// that kept the user's explicit transaction always offers both actions: that
// transaction exists only because the user asked for it.
const showTxnActions = computed(() => {
if (hasOpenAutoCommitTransaction.value) return true;
if (props.stickyProvenReadOnlyState) return isTransactionActive.value && props.txnPossiblyDirty === true;
return isTransactionActive.value;
});
const transactionTooltip = computed(() => {
if (hasOpenAutoCommitTransaction.value) return t("settings.keepExplicitTransactionInAutoCommitDescription");
if (props.activeConnection?.db_type === "sqlserver" && isManualTransactionMode.value) {
const status = props.activeTab.txnStatus;
return status ? t(`toolbar.sqlserverTxnStatus.${status}`) : t("toolbar.sqlserverIndependentTransaction");
}
const isAgent = (props.activeConnection?.db_type as string) === "agent";
const isManual = isManualTransactionMode.value;
if (isAgent && isManual) return t("toolbar.manualTransactionAgent");
if (isAgent) return t("toolbar.autoCommitAgent");
return isManual ? t("toolbar.manualTransaction") : t("toolbar.autoCommit");
});
const executeButtonClass = computed(() => {
if (props.activeTab.isExecuting) return "";
return activeProductionContext.value.active ? "bg-red-500/10 text-red-700 hover:bg-red-500/20 hover:text-red-800 dark:text-red-300 dark:hover:text-red-200" : "bg-emerald-500/10 text-emerald-700 hover:bg-emerald-500/20 hover:text-emerald-800 dark:text-emerald-300 dark:hover:text-emerald-200";
});
const executeAllButtonClass = computed(() => {
return activeProductionContext.value.active ? "text-red-700 hover:bg-red-500/10 hover:text-red-800 dark:text-red-300 dark:hover:text-red-200" : "text-emerald-600 hover:bg-emerald-500/10 hover:text-emerald-700 dark:text-emerald-300 dark:hover:text-emerald-200";
});
const canMultiExecute = computed(() => {
if (!supportsQueryExecution(props.activeConnection?.db_type)) return false;
if (props.activeTab.isExecuting || props.activeTab.isExplaining || props.activeTab.isCancelling) return false;
if (isTransactionActive.value) return false;
return !!props.executableSql.trim();
});
const schemaSelectorAvailable = computed(() => {
const connection = props.activeConnection;
return connection && isSchemaAware(connection.id) && (props.activeTab.database || isSingleDb.value || hasDefaultDatabaseOption.value);
});
const showSchemaSelector = computed(() => schemaSelectorAvailable.value);
const activeSchemaOptions = computed(() => {
const connection = props.activeConnection;
if (!connection) return [];
return getSchemaOptionsForDb(connection.id, schemaDatabaseKey.value);
});
const databaseRequiredVisible = ref(false);
watch(
() => props.databaseRequiredSignal,
(signal) => {
if (!signal) return;
databaseRequiredVisible.value = false;
requestAnimationFrame(() => {
databaseRequiredVisible.value = true;
});
},
);
const connectionRequiredVisible = ref(false);
watch(
() => props.connectionRequiredSignal,
(signal) => {
if (!signal) return;
connectionRequiredVisible.value = false;
requestAnimationFrame(() => {
connectionRequiredVisible.value = true;
connectionPickerRef.value?.openDropdown();
});
},
);
watch(activeDatabaseValue, (database) => {
if (database) databaseRequiredVisible.value = false;
});
watch(activeConnectionValue, (connectionId) => {
if (connectionId) connectionRequiredVisible.value = false;
});
/**
* 用户在侧栏显式关闭过、且还没重新连上的连接。
*
* 下面三个 watchEffect 是自动预取(挂载工具栏、切页签/切库时拉下拉选项),不代表用户
* 想连接;对显式关闭的连接必须跳过,否则残留页签一被激活就把连接连回来。它同时是这些
* 效果的响应式依赖:用户重连后标记消失,预取会自然补上。
*/
const activeConnectionClosedByUser = computed(() => (props.activeConnection ? connectionStore.isConnectionClosedByUser(props.activeConnection.id) : false));
watchEffect(() => {
const connection = props.activeConnection;
if (!connection || activeConnectionClosedByUser.value || !showSchemaSelector.value) return;
loadSchemaOptions(connection.id, schemaDatabaseKey.value).catch(() => {});
});
watchEffect(() => {
const connection = props.activeConnection;
if (!connection || activeConnectionClosedByUser.value || !connectionIsDorisFamilyCatalogCapable(connection)) return;
void loadCatalogOptions(connection.id).catch(() => {});
});
watchEffect(() => {
const connection = props.activeConnection;
const catalog = props.activeTab.catalog;
if (!connection || activeConnectionClosedByUser.value || !catalog) return;
void loadCatalogDatabaseOptions(connection.id, catalog).catch(() => {});
});
const isActiveDatabaseDefault = computed(() => isDefaultDatabase(props.activeConnection, activeDatabaseValue.value));
// Narrow panes (multi-group splits) condense the toolbar by measured width
// instead of overflowing or scrolling. See resolveEditorToolbarTier for the
// tier contract.
const showOverflowMenu = computed(() => toolbarTier.value >= 1);
const canFormatSql = computed(() => canFormatSqlForDatabaseType(props.activeConnection?.db_type));
const showFormatButton = computed(() => canFormatSql.value && toolbarTier.value < 2);
const showExplainAnalyzeToggle = computed(() => toolbarTier.value < 3);
const showCompressButton = computed(() => toolbarTier.value < 1);
const showFoldButtons = computed(() => toolbarTier.value < 1);
const foldAllTooltip = computed(() => {
const shortcut = formatShortcutDisplay(settingsStore.editorSettings.shortcuts.foldAll);
return shortcut ? `${t("toolbar.foldAll")} (${shortcut})` : t("toolbar.foldAll");
});
const unfoldAllTooltip = computed(() => {
const shortcut = formatShortcutDisplay(settingsStore.editorSettings.shortcuts.unfoldAll);
return shortcut ? `${t("toolbar.unfoldAll")} (${shortcut})` : t("toolbar.unfoldAll");
});
const showKeywordCaseButton = computed(() => toolbarTier.value < 1);
const showWordWrapButton = computed(() => toolbarTier.value < 1);
const showSemanticDiagnosticsButton = computed(() => supportsSqlSemanticDiagnosticsToggle.value && toolbarTier.value < 1);
const showPreviewButton = computed(() => previewButtonVisible.value && toolbarTier.value < 1);
const showInsertValueHintsButton = computed(() => supportsInsertValueHintsToggle.value && toolbarTier.value < 1);
const showOpenSqlButton = computed(() => toolbarTier.value < 1);
const showImportArchiveButton = computed(() => toolbarTier.value < 1);
const showPasteSqlButton = computed(() => toolbarTier.value < 1);
const showMultiExecuteButton = computed(() => toolbarTier.value < 1);
const showDatabaseHelperButtons = computed(() => toolbarTier.value < 2);
const toolbarStyle = computed(() => {
const color = props.activeConnection?.color;
if (!color) return undefined;
return {
backgroundColor: hexToRgba(color, 0.1),
boxShadow: `inset 0 1px 0 ${hexToRgba(color, 0.18)}`,
};
});
function databaseDisplayName(database: string): string {
return formatDatabaseLabel(props.activeConnection, database, {
defaultDatabase: t("editor.defaultDatabase"),
noDatabase: t("editor.noDatabase"),
});
}
function databaseOptionIsProduction(database: string): boolean {
if (!database || props.activeConnection?.is_production) return false;
return productionContextForDatabase(props.activeConnection, database).reason === "database";
}
function onExecutePointerDown(event: MouseEvent) {
if (props.activeTab.isExecuting || event.button !== 0) return;
emit("executePointerDown");
}
function onExecuteClick(event: MouseEvent) {
if (props.activeTab.isExecuting) {
emit("cancel");
return;
}
emit("toolbarExecute", event.detail > 0 ? "pointer" : "keyboard");
}
function onExecuteAllClick(event: MouseEvent) {
emit("toolbarExecuteAll", event.detail > 0 ? "pointer" : "keyboard");
}
function onExecuteInNewResultTabClick(event: MouseEvent) {
emit("toolbarExecuteInNewResultTab", event.detail > 0 ? "pointer" : "keyboard");
}
function changeEncoding(event: Event) {
const select = event.target as HTMLSelectElement;
const encoding = select.value as NonNullable<QueryTab["externalSqlEncoding"]>;
// Keep the visible selection committed until the asynchronous reload succeeds.
select.value = props.activeTab.externalSqlEncoding ?? "auto";
emit("change-encoding", encoding);
}
async function changeCatalog(selectedCatalog: string) {
const connection = props.activeConnection;
if (!connection) return;
switchingCatalog.value = true;
try {
const catalog = normalizedQueryTabCatalog(activeCatalogs.value, selectedCatalog);
const databases = catalog ? await loadCatalogDatabaseOptions(connection.id, selectedCatalog) : await loadDatabaseOptions(connection.id).then(() => databaseOptions.value[connection.id] ?? []);
emit("changeCatalog", catalog, databaseAfterCatalogChange(props.activeTab.database, databases));
} finally {
switchingCatalog.value = false;
}
}
const connectionPickerRef = ref<InstanceType<typeof ConnectionTreeSelect> | null>(null);
const connectionPickerOpen = ref(false);
const databasePickerRef = ref<InstanceType<typeof SearchableSelect> | null>(null);
const schemaPickerRef = ref<InstanceType<typeof SearchableSelect> | null>(null);
defineExpose({
openConnectionPicker: () => connectionPickerRef.value?.openDropdown() ?? false,
openDatabasePicker: () => databasePickerRef.value?.openDropdown() ?? false,
openSchemaPicker: () => schemaPickerRef.value?.openDropdown() ?? false,
});
</script>
<template>
<div v-show="!isObjectDependencySection(activeTab)" ref="toolbarRootRef" class="app-editor-toolbar h-9 min-w-0 shrink-0 border-b bg-background/80 px-3 flex items-center gap-1 text-xs text-muted-foreground relative z-10 overflow-hidden" :style="toolbarStyle">
<div ref="toolbarActionsRef" class="min-w-0 flex flex-1 items-center gap-0.5 overflow-hidden">
<Tooltip>
<TooltipTrigger as-child>
<Button
:variant="activeTab.isExecuting ? 'destructive' : 'ghost'"
size="icon"
class="h-6 w-6"
:class="executeButtonClass"
:disabled="activeTab.isCancelling || activeTab.isExplaining || (!activeTab.isExecuting && !executableSql.trim())"
@mousedown.prevent="onExecutePointerDown"
@click="onExecuteClick"
>
<Loader2 v-if="activeTab.isCancelling" class="h-3.5 w-3.5 animate-spin" />
<Square v-else-if="activeTab.isExecuting" class="h-3.5 w-3.5 fill-current" />
<Play v-else class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ activeTab.isExecuting ? t("toolbar.stopQuery") : executeShortcutTooltip }}</TooltipContent>
</Tooltip>
<div v-if="showMongoSqlToggle" class="ml-1 flex h-6 shrink-0 items-center rounded-md border bg-muted/40 p-0.5" role="group" :aria-label="t('toolbar.mongoQueryLanguage')">
<button type="button" class="h-5 rounded px-1.5 text-[11px] font-medium" :class="mongoQueryLanguage !== 'sql' ? 'bg-background text-foreground shadow-sm' : 'text-muted-foreground hover:text-foreground'" :aria-pressed="mongoQueryLanguage !== 'sql'" @click="setMongoQueryLanguage('shell')">
{{ t("toolbar.mongoShellMode") }}
</button>
<button type="button" class="h-5 rounded px-1.5 text-[11px] font-medium" :class="mongoQueryLanguage === 'sql' ? 'bg-background text-foreground shadow-sm' : 'text-muted-foreground hover:text-foreground'" :aria-pressed="mongoQueryLanguage === 'sql'" @click="setMongoQueryLanguage('sql')">
{{ t("toolbar.mongoSqlMode") }}
</button>
</div>
<Tooltip v-if="showMongoSqlToggle && mongoQueryLanguage === 'sql' && activeTab.mongoGeneratedShell">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-muted-foreground hover:text-foreground" :aria-label="t('toolbar.copyMongoShell')" @click="copyGeneratedMongoShell">
<Copy class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.copyMongoShell") }}</TooltipContent>
</Tooltip>
<Tooltip>
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6" :class="executeAllButtonClass" :disabled="activeTab.isExecuting || activeTab.isCancelling || activeTab.isExplaining || !activeTab.sql.trim()" :aria-label="t('toolbar.executeAllSql')" @click="onExecuteAllClick">
<FastForward class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ executeAllShortcutTooltip }}</TooltipContent>
</Tooltip>
<Tooltip>
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6 text-violet-600 hover:bg-violet-500/10 hover:text-violet-700 dark:text-violet-300 dark:hover:text-violet-200"
:disabled="activeTab.isExecuting || activeTab.isCancelling || activeTab.isExplaining || !executableSql.trim()"
:aria-label="t('settings.shortcutExecuteSqlInNewResultTab')"
@mousedown.prevent="onExecutePointerDown"
@click="onExecuteInNewResultTabClick"
>
<SquarePlay class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ executeInNewResultTabTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showPreviewButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-sky-600 hover:bg-sky-500/10 hover:text-sky-700" :disabled="activeTab.isExecuting || activeTab.isCancelling" :aria-label="t('editor.previewChanges')" @mousedown.prevent @click="emit('previewChanges')">
<Eye class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("editor.previewChanges") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="supportsExplain">
<TooltipTrigger as-child>
<Button
:variant="activeTab.isExplaining ? 'destructive' : 'ghost'"
size="icon"
class="h-6 w-6"
:class="activeTab.isExplaining ? '' : 'text-violet-600 hover:bg-violet-500/10 hover:text-violet-700 dark:text-violet-300 dark:hover:text-violet-200'"
:disabled="activeTab.isExecuting || (!activeTab.isExplaining && !executableSql.trim())"
@click="activeTab.isExplaining ? emit('cancel') : emit('explain')"
>
<Square v-if="activeTab.isExplaining" class="h-3.5 w-3.5 fill-current" />
<GitBranch v-else class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ activeTab.isExplaining ? t("toolbar.stopExplain") : explainPlanTooltip }}</TooltipContent>
</Tooltip>
<!-- Autotrace (DM) / EXPLAIN ANALYZE (Postgres) / actual plan (SQL Server) toggle -->
<Tooltip v-if="showExplainAnalyzeToggle">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6"
:class="props.explainMode === 'autotrace' ? 'text-green-600 bg-green-100 dark:text-green-300 dark:bg-green-900/30' : 'text-muted-foreground/50'"
:disabled="activeTab.isExecuting"
:aria-label="explainAnalyzeTooltip"
:aria-pressed="props.explainMode === 'autotrace'"
@click="emit('update:explainMode', props.explainMode === 'autotrace' ? 'explain' : 'autotrace')"
>
<span class="font-bold" style="font-size: 9px">A</span>
</Button>
</TooltipTrigger>
<TooltipContent>{{ explainAnalyzeTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showFormatButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-amber-600 hover:bg-amber-500/10 hover:text-amber-700 dark:text-amber-300 dark:hover:text-amber-200" :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @click="emit('formatSql')">
<AlignLeft class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ formatSqlTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showCompressButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-amber-600 hover:bg-amber-500/10 hover:text-amber-700 dark:text-amber-300 dark:hover:text-amber-200" :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @click="emit('compressSql')">
<Minimize2 class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.compressSql") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showFoldButtons">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-muted-foreground hover:bg-muted hover:text-foreground" :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" :aria-label="t('toolbar.foldAll')" @click="emit('foldAll')">
<FoldVertical class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ foldAllTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showFoldButtons">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-muted-foreground hover:bg-muted hover:text-foreground" :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" :aria-label="t('toolbar.unfoldAll')" @click="emit('unfoldAll')">
<UnfoldVertical class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ unfoldAllTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showKeywordCaseButton">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6 font-mono text-sm font-semibold leading-none"
:class="keywordCaseIsLower ? 'bg-amber-500/10 text-amber-700 hover:bg-amber-500/20 hover:text-amber-800 dark:text-amber-300 dark:hover:text-amber-200' : 'text-amber-600/70 hover:bg-amber-500/10 hover:text-amber-700 dark:text-amber-300/70 dark:hover:text-amber-200'"
:aria-label="keywordCaseToggleTooltip"
@click="emit('toggleSqlKeywordCase')"
>
{{ keywordCaseIsLower ? "a" : "A" }}
</Button>
</TooltipTrigger>
<TooltipContent>{{ keywordCaseToggleTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showWordWrapButton">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6"
:class="wordWrapEnabled ? 'bg-sky-500/10 text-sky-700 hover:bg-sky-500/20 hover:text-sky-800 dark:text-sky-300 dark:hover:text-sky-200' : 'text-muted-foreground/50 hover:bg-muted hover:text-muted-foreground'"
:disabled="activeTab.forceWordWrap === true"
:aria-label="t('settings.wordWrap')"
:aria-pressed="wordWrapEnabled"
@click="toggleWordWrap"
>
<WrapText class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("settings.wordWrap") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showSemanticDiagnosticsButton">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6"
:class="sqlSemanticDiagnosticsEnabled ? 'text-emerald-600 bg-emerald-500/10 hover:bg-emerald-500/20 hover:text-emerald-700 dark:text-emerald-300 dark:hover:text-emerald-200' : 'text-muted-foreground/50 hover:bg-muted hover:text-muted-foreground'"
:aria-label="sqlSemanticDiagnosticsToggleTooltip"
@click="toggleSqlSemanticDiagnostics"
>
<SpellCheck2 class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ sqlSemanticDiagnosticsToggleTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showInsertValueHintsButton">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6"
:class="insertValueHintsEnabled ? 'text-sky-600 bg-sky-500/10 hover:bg-sky-500/20 hover:text-sky-700 dark:text-sky-300 dark:hover:text-sky-200' : 'text-muted-foreground/50 hover:bg-muted hover:text-muted-foreground'"
:aria-label="insertValueHintsToggleTooltip"
:aria-pressed="insertValueHintsEnabled"
@click="toggleInsertValueHints"
>
<BetweenVerticalStart class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ insertValueHintsToggleTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="activeConnection?.db_type === 'redis'">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6"
:class="blockDangerousRedisCommands !== false ? 'text-orange-600 bg-orange-100 dark:text-orange-300 dark:bg-orange-900/30' : 'text-muted-foreground/50'"
:aria-label="t('toolbar.blockDangerousRedisCommands')"
:aria-pressed="blockDangerousRedisCommands !== false"
@click="emit('update:blockDangerousRedisCommands', blockDangerousRedisCommands === false)"
>
<Shield class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.blockDangerousRedisCommands") }}</TooltipContent>
</Tooltip>
<Tooltip>
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-blue-600 hover:bg-blue-500/10 hover:text-blue-700 dark:text-blue-300 dark:hover:text-blue-200" :disabled="!canSaveSql" @click="emit('saveSql', props.activeTab.id)">
<Save class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ saveTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="isObjectSourceTab">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6 text-emerald-600 hover:bg-emerald-500/10 hover:text-emerald-700 dark:text-emerald-300 dark:hover:text-emerald-200"
:disabled="objectSourceRefreshing || activeTab.isExecuting"
:aria-label="t('structureEditor.refresh')"
@click="refreshObjectSource"
>
<Loader2 v-if="objectSourceRefreshing" class="h-3.5 w-3.5 animate-spin" />
<RefreshCw v-else class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("structureEditor.refresh") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showOpenSqlButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-sky-600 hover:bg-sky-500/10 hover:text-sky-700 dark:text-sky-300 dark:hover:text-sky-200" @click="emit('openSql')">
<FolderOpen class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.openSql") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showImportArchiveButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-cyan-600 hover:bg-cyan-500/10 hover:text-cyan-700 dark:text-cyan-300 dark:hover:text-cyan-200" @click="emit('importResultArchive')">
<Download class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("tabs.importResultArchive") }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showPasteSqlButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-teal-600 hover:bg-teal-500/10 hover:text-teal-700 dark:text-teal-300 dark:hover:text-teal-200" @click="emit('pasteSqlInCondition')">
<ClipboardPaste class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ exPasteSqlInConditionTooltip }}</TooltipContent>
</Tooltip>
<Tooltip v-if="showMultiExecuteButton">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-primary hover:bg-primary/10" :disabled="!canMultiExecute" :aria-label="t('toolbar.multiDbExecute')" @click="emit('multiExecute')">
<CirclePlay class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.multiDbExecute") }}</TooltipContent>
</Tooltip>
<DropdownMenu v-if="showOverflowMenu">
<DropdownMenuTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-muted-foreground hover:text-foreground" :aria-label="t('toolbar.moreActions')" :title="t('toolbar.moreActions')">
<MoreHorizontal class="h-3.5 w-3.5" />
</Button>
</DropdownMenuTrigger>
<DropdownMenuContent align="start" class="w-max min-w-56 max-w-[calc(100vw-1rem)]">
<DropdownMenuItem :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @select="emit('compressSql')">
<Minimize2 class="h-3.5 w-3.5" />
{{ t("toolbar.compressSql") }}
</DropdownMenuItem>
<DropdownMenuItem :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @select="emit('foldAll')">
<FoldVertical class="h-3.5 w-3.5" />
{{ t("toolbar.foldAll") }}
</DropdownMenuItem>
<DropdownMenuItem :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @select="emit('unfoldAll')">
<UnfoldVertical class="h-3.5 w-3.5" />
{{ t("toolbar.unfoldAll") }}
</DropdownMenuItem>
<DropdownMenuItem @select="emit('toggleSqlKeywordCase')">
<span class="inline-flex h-4 w-4 shrink-0 items-center justify-center font-mono text-xs font-semibold" aria-hidden="true">
{{ keywordCaseIsLower ? "A" : "a" }}
</span>
{{ keywordCaseToggleTooltip }}
</DropdownMenuItem>
<DropdownMenuCheckboxItem :model-value="wordWrapEnabled" :disabled="activeTab.forceWordWrap === true" @select.prevent="toggleWordWrap">
<WrapText class="h-3.5 w-3.5" />
{{ t("settings.wordWrap") }}
</DropdownMenuCheckboxItem>
<DropdownMenuCheckboxItem v-if="supportsSqlSemanticDiagnosticsToggle" :model-value="sqlSemanticDiagnosticsEnabled" @select.prevent="toggleSqlSemanticDiagnostics">
<SpellCheck2 class="h-3.5 w-3.5" />
{{ t("settings.sqlSemanticDiagnosticsEnabled") }}
</DropdownMenuCheckboxItem>
<DropdownMenuItem @select="emit('openSql')">
<FolderOpen class="h-3.5 w-3.5" />
{{ t("toolbar.openSql") }}
</DropdownMenuItem>
<DropdownMenuItem @select="emit('importResultArchive')">
<Download class="h-3.5 w-3.5" />
{{ t("tabs.importResultArchive") }}
</DropdownMenuItem>
<DropdownMenuItem v-if="supportsExPaste" @select="emit('pasteSqlInCondition')">
<ClipboardPaste class="h-3.5 w-3.5" />
{{ t("toolbar.exPasteSqlInCondition") }}
</DropdownMenuItem>
<DropdownMenuItem :disabled="!canMultiExecute" @select="emit('multiExecute')">
<CirclePlay class="h-3.5 w-3.5" />
{{ t("toolbar.multiDbExecute") }}
</DropdownMenuItem>
<DropdownMenuItem v-if="previewButtonVisible" :disabled="activeTab.isExecuting || activeTab.isCancelling" @select="emit('previewChanges')">
<Eye class="h-3.5 w-3.5" />
{{ t("editor.previewChanges") }}
</DropdownMenuItem>
<DropdownMenuCheckboxItem v-if="supportsInsertValueHintsToggle" :model-value="insertValueHintsEnabled" @select.prevent="toggleInsertValueHints">
<BetweenVerticalStart class="h-3.5 w-3.5" />
{{ t("settings.showInsertValueHints") }}
</DropdownMenuCheckboxItem>
<template v-if="toolbarTier >= 2">
<DropdownMenuItem v-if="canFormatSql" :disabled="activeTab.isExecuting || activeTab.isExplaining || !activeTab.sql.trim()" @select="emit('formatSql')">
<AlignLeft class="h-3.5 w-3.5" />
{{ t("toolbar.formatSql") }}
</DropdownMenuItem>
<DropdownMenuItem v-if="activeDatabaseValue" :disabled="!activeConnection" @select="emit('changeDatabase', '')">
<X class="h-3.5 w-3.5" />
{{ t("editor.clearDatabase") }}
</DropdownMenuItem>
<DropdownMenuItem v-if="activeDatabaseValue && !activeTab.catalog" @select="isActiveDatabaseDefault ? emit('clearDefaultDatabase') : emit('setDefaultDatabase')">
<Check v-if="isActiveDatabaseDefault" class="h-3 w-3" />
{{ isActiveDatabaseDefault ? t("editor.defaultDatabase") : t("editor.setDefaultDatabase") }}
</DropdownMenuItem>
</template>
<DropdownMenuCheckboxItem v-if="toolbarTier >= 3 && supportsExplainAnalyze" :model-value="props.explainMode === 'autotrace'" @select.prevent="emit('update:explainMode', props.explainMode === 'autotrace' ? 'explain' : 'autotrace')">
<span class="font-bold" style="font-size: 9px">A</span>
{{ explainAnalyzeTooltip }}
</DropdownMenuCheckboxItem>
</DropdownMenuContent>
</DropdownMenu>
<div v-if="supportsTransaction" class="ml-1 flex items-center gap-0.5 border-l border-border/60 pl-1" role="group" :aria-label="transactionTooltip">
<!-- Transaction toggle -->
<Tooltip>
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-8 px-1"
:class="isManualTransactionMode ? 'bg-orange-100 text-orange-600 dark:bg-orange-900/30 dark:text-orange-300' : 'text-orange-600/70 hover:bg-orange-500/10 hover:text-orange-700 dark:text-orange-300/70 dark:hover:text-orange-200'"
:disabled="activeTab.isExecuting || activeTab.isExplaining || activeTab.txnStatus === 'opening' || activeTab.txnStatus === 'ending'"
:aria-label="transactionTooltip"
:aria-pressed="isManualTransactionMode || hasOpenAutoCommitTransaction"
@click="emit('update:autoCommit', autoCommit === false)"
>
<span class="inline-flex items-center gap-px leading-none" aria-hidden="true">
<span class="text-[11px] font-bold">Tx:</span>
<span class="inline-flex h-3 min-w-3 items-center justify-center rounded-[3px] border border-current px-px text-[8px] font-extrabold leading-none">{{ transactionModeBadge }}</span>
<!-- Auto-commit tab with an uncommitted explicit transaction:
the commit/rollback actions next to the badge act on it. -->
<span v-if="hasOpenAutoCommitTransaction" data-toolbar-open-transaction-dot class="ml-px h-1.5 w-1.5 rounded-full bg-current" />
</span>
</Button>
</TooltipTrigger>
<TooltipContent>{{ transactionTooltip }}</TooltipContent>
</Tooltip>
<!-- Commit button (only when a transaction action is warranted) -->
<Tooltip v-if="showTxnActions">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6 text-green-600 hover:bg-green-500/10 hover:text-green-700 dark:text-green-300 dark:hover:text-green-200"
:disabled="activeTab.isExecuting || activeTab.txnStatus === 'ending' || activeTab.txnStatus === 'opening'"
:aria-label="t('toolbar.commit')"
@click="emit('commit')"
>
<Check class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.commit") }}</TooltipContent>
</Tooltip>
<!-- Rollback button (only when a transaction action is warranted) -->
<Tooltip v-if="showTxnActions">
<TooltipTrigger as-child>
<Button
variant="ghost"
size="icon"
class="h-6 w-6 text-red-600 hover:bg-red-500/10 hover:text-red-700 dark:text-red-300 dark:hover:text-red-200"
:disabled="activeTab.isExecuting || activeTab.txnStatus === 'ending' || activeTab.txnStatus === 'opening'"
:aria-label="t('toolbar.rollback')"
@click="emit('rollback')"
>
<RotateCcw class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("toolbar.rollback") }}</TooltipContent>
</Tooltip>
</div>
</div>
<div class="flex shrink-0 items-center gap-2">
<div class="flex shrink-0 items-center gap-1" :class="{ 'connection-required-prompt': connectionRequiredVisible }">
<span v-if="activeConnection?.color" class="h-4 w-1 rounded-full shrink-0" :style="{ backgroundColor: activeConnection.color }" />
<LightTooltip text="" :disabled="connectionPickerOpen || !activeConnectionDetailRows.length" side="bottom" :side-offset="6" :delay="250" :close-delay="80" surface="popover">
<ConnectionTreeSelect
ref="connectionPickerRef"
:model-value="activeConnectionValue"
:connections="connectionStore.connections"
:layout="connectionStore.sidebarLayout"
:placeholder="t('editor.selectConnection')"
:search-placeholder="t('editor.searchConnection')"
:empty-text="t('grid.noSearchResults')"
:hide-title="activeConnectionDetailRows.length > 0"
trigger-class="max-w-[min(28rem,36vw)] font-medium text-foreground"
trigger-icon-class="h-3 w-3"
list-class="w-96 max-w-[calc(100vw-2rem)]"
@update:model-value="(connectionId) => emit('changeConnection', connectionId)"
@update:open="(open: boolean) => (connectionPickerOpen = open)"
>
<template #trigger-label="{ label }">
<div v-if="activeConnection" class="flex min-w-0 items-center gap-1.5">
<DatabaseIcon :db-type="connectionIconType(activeConnection)" class="h-3.5 w-3.5 shrink-0" />
<span v-if="visibleConnectionGroupPath" data-connection-group-path class="min-w-0 max-w-[50%] shrink truncate text-muted-foreground">{{ visibleConnectionGroupPath }} /</span>
<span :class="visibleConnectionGroupPath ? 'min-w-0 shrink truncate' : 'min-w-0 flex-1 truncate'">{{ label }}</span>
<ProductionContextBadge v-if="showConnectionProductionBadge" compact />
</div>
<span v-else class="truncate text-muted-foreground">{{ t("editor.selectConnection") }}</span>
</template>
</ConnectionTreeSelect>
<template #content><ConnectionDetailContent :rows="activeConnectionDetailRows" /></template>
</LightTooltip>
</div>
<div v-if="showCatalogSelector" class="flex shrink-0 items-center gap-1">
<SearchableSelect
:model-value="activeCatalogValue"
:options="activeCatalogNames"
:placeholder="t('editor.selectCatalog')"
:search-placeholder="t('editor.searchCatalog')"
:empty-text="t('grid.noSearchResults')"
:loading-text="t('common.loading')"
:loading="loadingCatalogOptions[activeConnection?.id || ''] || switchingCatalog"
trigger-variant="ghost"
trigger-class="gap-1.5"
trigger-icon-class="h-3 w-3"
@update:model-value="changeCatalog"
@update:open="
(open: boolean) => {
if (open && activeConnection) loadCatalogOptions(activeConnection.id).catch(() => {});
}
"
>
<template #trigger-label="{ label, loading }">
<Layers class="h-3.5 w-3.5 shrink-0" />
<span class="truncate">{{ loading ? t("common.loading") : label }}</span>
</template>
</SearchableSelect>
</div>
<div
v-if="
activeConnection?.db_type !== 'elasticsearch' &&
activeConnection?.db_type !== 'easysearch' &&
activeConnection?.db_type !== 'meilisearch' &&
activeConnection?.db_type !== 'solr' &&
activeConnection?.db_type !== 'couchdb' &&
activeConnection?.db_type !== 'qdrant' &&
activeConnection?.db_type !== 'milvus' &&
activeConnection?.db_type !== 'weaviate' &&
activeConnection?.db_type !== 'chromadb' &&
activeConnection?.db_type !== 'zookeeper' &&
activeConnection?.db_type !== 'consul' &&
!isSingleDb
"
class="flex shrink-0 items-center gap-1"
:class="{ 'database-required-prompt': databaseRequiredVisible }"
>
<SearchableSelect
ref="databasePickerRef"
:model-value="activeDatabaseValue"
:options="activeDatabaseOptions.length ? activeDatabaseOptions : activeDatabaseValue ? [activeDatabaseValue] : []"
:placeholder="t('editor.selectDatabase')"
:search-placeholder="t('editor.searchDatabase')"
:empty-text="t('grid.noSearchResults')"
:loading-text="t('common.loading')"
:loading="loadingActiveDatabaseOptions"
:display-name="databaseDisplayName"
trigger-variant="ghost"
trigger-class="gap-1.5"
trigger-icon-class="h-3 w-3"
@update:model-value="(database) => emit('changeDatabase', database)"
@update:open="
(open: boolean) => {
if (!open || !activeConnection) return;
if (activeTab.catalog) loadCatalogDatabaseOptions(activeConnection.id, activeTab.catalog).catch(() => {});
else loadDatabaseOptions(activeConnection.id).catch(() => {});
}
"
>
<template #trigger-label="{ label, loading }">
<Database class="h-3.5 w-3.5 shrink-0" />
<span class="truncate">{{ loading ? t("common.loading") : label }}</span>
<ProductionContextBadge v-if="showDatabaseProductionBadge" compact />
</template>
<template #option-label="{ option, label }">
<div class="flex min-w-0 flex-1 items-center gap-1.5">
<TruncatedTextTooltip :text="label" class="min-w-0 flex-1" side="left" :side-offset="8" />
<ProductionContextBadge v-if="databaseOptionIsProduction(option)" compact />
</div>
</template>
</SearchableSelect>
<Tooltip v-if="showDatabaseHelperButtons && activeDatabaseValue && !isSingleDb">
<TooltipTrigger as-child>
<Button variant="ghost" size="icon" class="h-6 w-6 text-muted-foreground hover:text-foreground" @click="emit('changeDatabase', '')">
<X class="h-3.5 w-3.5" />
</Button>
</TooltipTrigger>
<TooltipContent>{{ t("editor.clearDatabase") }}</TooltipContent>
</Tooltip>
<Button v-if="showDatabaseHelperButtons && activeDatabaseValue && !activeTab.catalog" variant="ghost" size="sm" class="h-6 px-2 text-[11px]" @click="isActiveDatabaseDefault ? emit('clearDefaultDatabase') : emit('setDefaultDatabase')">
<Check v-if="isActiveDatabaseDefault" class="h-3 w-3" />
{{ isActiveDatabaseDefault ? t("editor.defaultDatabase") : t("editor.setDefaultDatabase") }}
</Button>
</div>
<div v-if="showSchemaSelector" class="flex shrink-0 items-center gap-1">
<SearchableSelect
ref="schemaPickerRef"
:model-value="activeSchemaValue"
:options="activeSchemaOptions.length ? activeSchemaOptions : activeSchemaValue ? [activeSchemaValue] : []"
:placeholder="t('editor.selectSchema')"
:search-placeholder="t('editor.searchSchema')"
:empty-text="t('grid.noSearchResults')"
:loading-text="t('common.loading')"
:loading="!!activeConnection && isLoadingSchemas(activeConnection.id, schemaDatabaseKey)"
:clear-selected-option="supportsClearableQuerySchema(activeConnection?.db_type)"
trigger-variant="ghost"
trigger-class="gap-1.5"
trigger-icon-class="h-3 w-3"
@update:model-value="(schema) => emit('changeSchema', schema || undefined)"
@update:open="
(open: boolean) => {
if (open && activeConnection) loadSchemaOptions(activeConnection.id, schemaDatabaseKey).catch(() => {});
}
"
>
<template #trigger-label="{ label, loading }">
<Layers class="h-3.5 w-3.5 shrink-0" />
<span class="truncate">{{ loading ? t("common.loading") : label }}</span>
</template>
<template #option-label="{ label }">
<TruncatedTextTooltip :text="label" class="min-w-0 flex-1" side="left" :side-offset="8" />
</template>
</SearchableSelect>
</div>
</div>
<select v-if="activeTab.externalSqlPath" class="ml-1 h-6 rounded border border-border bg-background px-1 text-[11px]" :value="activeTab.externalSqlEncoding ?? 'auto'" :aria-label="t('toolbar.fileEncoding')" @change="changeEncoding">
<option value="auto">{{ t("toolbar.encodingAuto") }}</option>
<option value="utf8">UTF-8</option>
<option value="utf8Bom">UTF-8 BOM</option>
<option value="utf16le">UTF-16 LE</option>
<option value="utf16be">UTF-16 BE</option>
<option value="gbk">GBK / GB18030</option>
</select>
<div v-if="activeTab.mode === 'data' && activeTab.tableMeta" class="ml-2 inline-flex shrink-0 items-center gap-1 rounded border border-border bg-muted/30 px-2 py-0.5 font-medium text-muted-foreground tabular-nums">
<Table2 class="h-3.5 w-3.5 shrink-0" />
<span class="truncate">{{ activeTab.tableMeta.columns.length }} {{ t("tree.columns") }}</span>
</div>
<div v-if="salesforceIdentity" data-testid="salesforce-identity-badge" class="ml-2 inline-flex max-w-[20rem] shrink-0 items-center gap-1 rounded border border-border bg-muted/30 px-2 py-0.5 font-medium text-muted-foreground" :title="salesforceIdentityTooltip">
<Shield v-if="salesforceIdentity.isAdmin === true" class="h-3.5 w-3.5 shrink-0 text-amber-600 dark:text-amber-400" />
<UserRound v-else class="h-3.5 w-3.5 shrink-0" />
<span class="truncate">{{ salesforceIdentityLabel }}</span>
</div>
</div>
<div v-if="autoCommitTxnRolledBack" data-auto-commit-txn-rolled-back class="flex items-center gap-2 px-3 py-1 text-xs bg-amber-500/10 text-amber-700 dark:text-amber-300 border-b border-amber-500/20">
<AlertTriangle class="h-3.5 w-3.5 shrink-0" />
<span>{{ t("toolbar.autoCommitTxnRolledBack") }}</span>
<Button variant="ghost" size="icon" class="h-5 w-5 ml-auto" @click="emit('dismissAutoCommitTxnRolledBack')">
<X class="h-3 w-3" />
</Button>
</div>
<div v-else-if="autoCommitSessionTxnRolledBack" data-auto-commit-session-txn-rolled-back class="flex items-center gap-2 px-3 py-1 text-xs bg-amber-500/10 text-amber-700 dark:text-amber-300 border-b border-amber-500/20">
<AlertTriangle class="h-3.5 w-3.5 shrink-0" />
<span>{{ t("toolbar.autoCommitSessionTxnRolledBack") }}</span>
<Button variant="ghost" size="icon" class="h-5 w-5 ml-auto" @click="emit('dismissAutoCommitSessionTxnRolledBack')">
<X class="h-3 w-3" />
</Button>
</div>
<div v-if="activeTab.txnNotice" data-sqlserver-transaction-notice class="flex items-center gap-2 px-3 py-1 text-xs bg-amber-500/10 text-amber-700 dark:text-amber-300 border-b border-amber-500/20">
<span>{{ activeTab.txnNotice }}</span>
<Button variant="ghost" size="icon" class="ml-auto h-5 w-5 shrink-0" :aria-label="t('common.close')" @click="activeTab.txnNotice = undefined"><X class="h-3 w-3" /></Button>
</div>
<div v-if="txnAutoRolledBack" class="flex items-center gap-2 px-3 py-1 text-xs bg-amber-500/10 text-amber-700 dark:text-amber-300 border-b border-amber-500/20">
<AlertTriangle class="h-3.5 w-3.5 shrink-0" />
<span>{{ t("toolbar.txnAutoRolledBack") }}</span>
<Button variant="ghost" size="icon" class="h-5 w-5 ml-auto" @click="emit('dismissTxnRolledBack')">
<X class="h-3 w-3" />
</Button>
</div>
</template>
<style scoped>
.database-required-prompt {
color: var(--destructive);
animation: database-required-shake 420ms ease;
}
.database-required-prompt :deep(button) {
color: var(--destructive);
border-color: color-mix(in oklch, var(--destructive) 55%, transparent);
background: color-mix(in oklch, var(--destructive) 10%, transparent);
}
@keyframes database-required-shake {
0%,
100% {
transform: translateX(0);
}
12%,
36%,
60% {
transform: translateX(-3px);
}
24%,
48%,
72% {
transform: translateX(3px);
}
}
.connection-required-prompt {
color: var(--destructive);
animation: database-required-shake 420ms ease;
}
.connection-required-prompt :deep(button) {
color: var(--destructive);
border-color: color-mix(in oklch, var(--destructive) 55%, transparent);
background: color-mix(in oklch, var(--destructive) 10%, transparent);
}
</style>