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 { ConnectionConfig, DatabaseType } from "@/types/database";
import { filterDatabaseNamesForVisiblePicker, filterVisibleDatabaseNames, visibleDatabasePatternsAreEnabled } from "@/lib/database/visibleDatabases";
const DRAFT_VISIBLE_DATABASES_PREFIX = "__visible_draft_";
// Turso and Cloudflare D1 target one fixed SQLite-compatible `main` namespace;
// non-database services expose their own root objects rather than database namespaces.
const UNSUPPORTED_VISIBLE_DATABASE_TYPES = new Set<DatabaseType>(["turso", "cloudflare-d1", "dynamodb", "elasticsearch", "easysearch", "meilisearch", "solr", "couchdb", "qdrant", "milvus", "weaviate", "chromadb", "etcd", "zookeeper", "mq", "nacos", "consul", "plugin", "salesforce"]);
type VisibleDatabaseConnectionFields = Pick<
ConnectionConfig,
"db_type" | "driver_profile" | "host" | "port" | "username" | "database" | "connection_string" | "url_params" | "redis_connection_mode" | "redis_sentinel_master" | "redis_sentinel_nodes" | "redis_cluster_nodes" | "etcd_endpoints" | "jdbc_driver_class"
>;
type VisibleObjectFilterConnectionFields = VisibleDatabaseConnectionFields & Pick<ConnectionConfig, "visible_databases" | "visible_schemas">;
export function buildDraftVisibleDatabasesConnectionId(seed: string): string {
return `${DRAFT_VISIBLE_DATABASES_PREFIX}${seed}`;
}
export function connectionCanChooseVisibleDatabases(connection: Pick<ConnectionConfig, "db_type"> | undefined): boolean {
return !!connection?.db_type && !UNSUPPORTED_VISIBLE_DATABASE_TYPES.has(connection.db_type);
}
export function initialVisibleDatabaseSelection(databaseNames: string[], visibleDatabases: string[] | undefined, connection?: Pick<ConnectionConfig, "db_type" | "driver_profile" | "visible_databases" | "visible_database_patterns">): string[] {
const patterns = connection?.visible_database_patterns;
// 通配符与显式名单取并集,和侧栏筛选保持一致;全匹配通配符会让"显示全部"的选择器
// 重新打开时仍勾选所有库(含系统库),而不是看起来又退回默认视图。
if (Array.isArray(visibleDatabases) || visibleDatabasePatternsAreEnabled(patterns)) {
return filterVisibleDatabaseNames(databaseNames, visibleDatabases, patterns);
}
return filterDatabaseNamesForVisiblePicker(databaseNames, connection);
}
export function appendVisibleDatabaseSelection(visibleDatabases: string[] | undefined, databaseName: string): string[] | undefined {
if (!Array.isArray(visibleDatabases)) return undefined;
const name = databaseName.trim();
if (!name || visibleDatabases.includes(name)) return visibleDatabases;
return [...visibleDatabases, name];
}
export function visibleDatabaseSelectionIsStale(previous: VisibleDatabaseConnectionFields, current: VisibleDatabaseConnectionFields): boolean {
return visibleDatabaseFingerprint(previous) !== visibleDatabaseFingerprint(current);
}
export function visibleObjectFiltersNeedReset(previous: VisibleObjectFilterConnectionFields, current: VisibleObjectFilterConnectionFields): boolean {
const hasVisibleDatabaseFilter = Array.isArray(current.visible_databases);
const hasVisibleSchemaFilter = !!current.visible_schemas && Object.keys(current.visible_schemas).length > 0;
return (hasVisibleDatabaseFilter || hasVisibleSchemaFilter) && visibleDatabaseSelectionIsStale(previous, current);
}
function visibleDatabaseFingerprint(connection: VisibleDatabaseConnectionFields): string {
return JSON.stringify({
db_type: connection.db_type,
driver_profile: connection.driver_profile || "",
host: connection.host || "",
port: Number(connection.port) || 0,
username: connection.username || "",
database: connection.database || "",
connection_string: connection.connection_string || "",
url_params: connection.url_params || "",
redis_connection_mode: connection.redis_connection_mode || "",
redis_sentinel_master: connection.redis_sentinel_master || "",
redis_sentinel_nodes: connection.redis_sentinel_nodes || "",
redis_cluster_nodes: connection.redis_cluster_nodes || "",
etcd_endpoints: connection.etcd_endpoints || "",
jdbc_driver_class: connection.jdbc_driver_class || "",
});
}