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 { describe, expect, it } from "vitest";
import {
databaseConnectionFormKind,
databaseDefaultPort,
databaseManifestEntry,
databaseProductCapabilities,
databaseRuntimeMode,
databaseTransferSupportLevel,
supportsDatabaseCompareMode,
supportsDatabaseFeature,
usesAgentCursorForQuery,
usesAgentCursorForTableData,
} from "@/lib/database/databaseDriverManifest";
describe("databaseDriverManifest", () => {
it("advertises implemented Xugu capabilities without enabling unsupported features", () => {
expect(databaseProductCapabilities("xugu")).toEqual({
queryExecution: true,
metadataBrowse: true,
objectBrowser: true,
objectSource: true,
schemaSearch: true,
diagram: true,
tableDataEdit: true,
tableStructureEdit: true,
tableImport: true,
dataTransfer: true,
sqlFileExecution: true,
databaseCreate: false,
fieldLineage: true,
sqlExplain: true,
userAdmin: true,
driverManagement: true,
});
for (const capability of ["objectSource", "tableDataEdit", "userAdmin", "sqlExplain"] as const) {
expect(supportsDatabaseFeature("xugu", capability), capability).toBe(true);
}
});
it("uses result cursors for agent, external, and native DuckDB queries", () => {
expect(databaseRuntimeMode("gaussdb")).toBe("native");
expect(databaseRuntimeMode("meilisearch")).toBe("native");
expect(databaseRuntimeMode("dynamodb")).toBe("native");
expect(usesAgentCursorForQuery("gaussdb")).toBe(false);
expect(usesAgentCursorForQuery("meilisearch")).toBe(false);
expect(usesAgentCursorForQuery("dynamodb")).toBe(false);
expect(usesAgentCursorForQuery("mysql")).toBe(false);
expect(usesAgentCursorForQuery("duckdb")).toBe(true);
expect(usesAgentCursorForQuery("cassandra")).toBe(true);
expect(usesAgentCursorForQuery("jdbc")).toBe(true);
expect(usesAgentCursorForQuery("prestosql")).toBe(true);
expect(usesAgentCursorForQuery("sqlserver")).toBe(false);
expect(usesAgentCursorForQuery("sqlserver", "sqlserver-legacy")).toBe(true);
expect(usesAgentCursorForQuery("sqlserver", " SQLSERVER-LEGACY ")).toBe(true);
});
it("limits table-data agent cursors to Cassandra and SQL Server legacy", () => {
expect(usesAgentCursorForTableData("cassandra")).toBe(true);
expect(usesAgentCursorForTableData("sqlserver", "sqlserver-legacy")).toBe(true);
expect(usesAgentCursorForTableData("sqlserver")).toBe(false);
expect(usesAgentCursorForTableData("jdbc")).toBe(false);
expect(usesAgentCursorForTableData("prestosql")).toBe(false);
});
it("exposes connection defaults from the shared manifest", () => {
expect(databaseDefaultPort("mysql")).toBe(3306);
expect(databaseManifestEntry("h2")).toMatchObject({
dbType: "h2",
runtimeMode: "agent",
agentKey: "h2",
skipTcpProbe: true,
localFile: true,
});
});
it("exposes transfer compatibility evidence from the shared manifest", () => {
expect(databaseTransferSupportLevel("mysql")).toBe("verified");
expect(databaseTransferSupportLevel("kingbase")).toBe("family-compatible");
expect(databaseTransferSupportLevel("db2")).toBe("best-effort");
expect(databaseTransferSupportLevel("gbase")).toBeUndefined();
});
it("exposes schema and data comparison support from the shared manifest", () => {
expect(supportsDatabaseCompareMode("mysql", "schema")).toBe(true);
expect(supportsDatabaseCompareMode("kingbase", "data")).toBe(true);
expect(supportsDatabaseCompareMode("mongodb", "data")).toBe(false);
expect(supportsDatabaseCompareMode("redis", "schema")).toBe(false);
});
it("offers only the supported NebulaGraph 3.x profile", () => {
expect(databaseManifestEntry("nebula")?.driverProfiles).toEqual([{ profile: "nebula-v3", agentKey: "nebula", label: "NebulaGraph 3.x", storeVisible: false }]);
});
it("routes only specialized connection forms explicitly", () => {
expect(databaseConnectionFormKind("mysql")).toBe("standard");
expect(databaseConnectionFormKind("jdbc")).toBe("jdbc");
expect(databaseConnectionFormKind("mq")).toBe("mq");
expect(databaseConnectionFormKind("mqtt")).toBe("mqtt");
expect(databaseConnectionFormKind("nacos")).toBe("nacos");
});
it("advertises tableDataEdit capability for InterSystems IRIS / Caché (#11808)", () => {
expect(supportsDatabaseFeature("iris", "tableDataEdit")).toBe(true);
});
});