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 assert from "node:assert/strict";
import { test } from "vitest";
import { buildDatabaseTreeNodes, sortSidebarNames } from "../../apps/desktop/src/lib/database/databaseTree.ts";
test("数据库节点按自然名称排序", () => {
const nodes = buildDatabaseTreeNodes("conn-1", [{ name: "db10" }, { name: "db2" }, { name: "campaign_data" }, { name: "cms" }, { name: "mk_campaign" }]);
assert.deepEqual(
nodes.map((node) => node.database),
["campaign_data", "cms", "db2", "db10", "mk_campaign"],
);
assert.equal(nodes.find((node) => node.database === "mk_campaign")?.id, "conn-1:mk_campaign");
});
test("sidebar name sorting uses numeric-aware ordering", () => {
assert.deepEqual(sortSidebarNames(["db10", "db2", "db1"]), ["db1", "db2", "db10"]);
});
test("数据库节点保留名称首尾空格并忽略纯空白名称", () => {
const nodes = buildDatabaseTreeNodes("conn-1", [{ name: " analytics" }, { name: "analytics" }, { name: "archive " }, { name: " " }]);
assert.deepEqual(
nodes.map((node) => ({ id: node.id, label: node.label, database: node.database })),
[
{ id: "conn-1: analytics", label: " analytics", database: " analytics" },
{ id: "conn-1:analytics", label: "analytics", database: "analytics" },
{ id: "conn-1:archive ", label: "archive ", database: "archive " },
],
);
});