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 { TreeNode, TreeNodeType } from "@/types/database";
import { sidebarDatabaseOpenKey } from "@/lib/sidebar/sidebarDatabaseOpenState";
// Database-level containers whose objects the sidebar search walker may load.
// Mirrors the sidebar "database opened" indicator (sidebarDatabaseOpenState):
// a database participates in the automatic search only when the user actually
// opened it — children loaded in the tree or referenced by an open editor tab.
const searchScopeDatabaseTypes = new Set<TreeNodeType>(["database", "mongo-db", "vector-database"]);
export interface SidebarSearchDatabaseScopeOptions {
enabled: boolean;
isChildrenLoaded: (nodeId: string) => boolean;
openDatabaseKeys: ReadonlySet<string>;
}
function collectOpenedDatabaseNodeIds(node: TreeNode, opened: Set<string>, options: SidebarSearchDatabaseScopeOptions): void {
for (const child of node.children ?? []) {
if (searchScopeDatabaseTypes.has(child.type)) {
const isOpened = !!child.connectionId && child.database != null && (options.isChildrenLoaded(child.id) || options.openDatabaseKeys.has(sidebarDatabaseOpenKey(child.connectionId, child.database)));
if (isOpened) opened.add(child.id);
// Nothing below a database-level node is itself database-level, so the
// subtree never contributes another scope entry.
continue;
}
// Pass-through containers (connection groups, Doris catalogs, linked
// servers) keep their nested database nodes scannable.
collectOpenedDatabaseNodeIds(child, opened, options);
}
}
/**
* Node ids of database-level nodes the sidebar search may load for one
* connection, or null when the setting allows searching every database.
* An empty set must stay restricted: searching before opening a database
* must not load every database on the user's behalf. Schema-mode trees
* remain searchable because only database-level nodes are pruned.
*/
export function resolveSidebarSearchDatabaseScope(connectionNode: TreeNode, options: SidebarSearchDatabaseScopeOptions): ReadonlySet<string> | null {
if (!options.enabled) return null;
const opened = new Set<string>();
collectOpenedDatabaseNodeIds(connectionNode, opened, options);
return opened;
}
/**
* Whether the search walker must skip a node: a database-level node outside
* the opened scope. Containers and non-database nodes are never pruned, and a
* null scope (unrestricted) prunes nothing.
*/
export function isSidebarSearchPrunedDatabaseNode(node: TreeNode, scope: ReadonlySet<string> | null): boolean {
if (!scope) return false;
return searchScopeDatabaseTypes.has(node.type) && !scope.has(node.id);
}