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 { aiTableMentionFromTableReference } from "@/lib/ai/aiTableReferenceDrop";
import { createTableReferencePayload } from "@/lib/editor/queryEditorTableDrop";
describe("ai table reference drop", () => {
it("maps a table payload to a table mention", () => {
const payload = createTableReferencePayload({
connectionId: "conn-1",
database: "app-db",
schema: "public",
tableName: "users",
databaseType: "postgres",
});
expect(aiTableMentionFromTableReference(payload)).toEqual({
raw: "@public.users",
schema: "public",
table: "users",
});
});
it("quotes mention parts that are not simple identifiers", () => {
const payload = createTableReferencePayload({
connectionId: "conn-1",
database: "app-db",
tableName: "order items",
databaseType: "mysql",
});
expect(aiTableMentionFromTableReference(payload)).toEqual({
raw: '@"order items"',
schema: undefined,
table: "order items",
});
});
it("ignores database references", () => {
const payload = createTableReferencePayload({
connectionId: "conn-1",
database: "app-db",
referenceType: "database",
databaseType: "mysql",
});
expect(aiTableMentionFromTableReference(payload)).toBeNull();
});
it("ignores column references", () => {
const payload = createTableReferencePayload({
connectionId: "conn-1",
database: "app-db",
schema: "public",
tableName: "users",
columnName: "email",
databaseType: "postgres",
});
expect(aiTableMentionFromTableReference(payload)).toBeNull();
});
it("ignores empty payloads", () => {
expect(aiTableMentionFromTableReference(null)).toBeNull();
expect(aiTableMentionFromTableReference(undefined)).toBeNull();
});
});