兼容性仅在 Node.js 上可用。
设置
- 启动 ClickHouse 集群。有关详细信息，请参阅 ClickHouse 安装指南。
- 启动 ClickHouse 集群后，从集群的“操作”菜单中检索“连接详细信息”。您将需要主机、端口、用户名和密码。
- 在您的工作区中安装 ClickHouse 所需的 Node.js 对等依赖项。
npm
复制
向 AI 提问
npm install -S @clickhouse/client mysql2
有关安装 LangChain 软件包的一般说明，请参阅此部分。
npm
复制
向 AI 提问
npm install @langchain/openai @langchain/community @langchain/core
索引和查询文档
复制
向 AI 提问
import { ClickHouseStore } from "@langchain/community/vectorstores/clickhouse";
import { OpenAIEmbeddings } from "@langchain/openai";
// Initialize ClickHouse store from texts
const vectorStore = await ClickHouseStore.fromTexts(
["Hello world", "Bye bye", "hello nice world"],
[
{ id: 2, name: "2" },
{ id: 1, name: "1" },
{ id: 3, name: "3" },
],
new OpenAIEmbeddings(),
{
host: process.env.CLICKHOUSE_HOST || "localhost",
port: process.env.CLICKHOUSE_PORT || 8443,
username: process.env.CLICKHOUSE_USER || "username",
password: process.env.CLICKHOUSE_PASSWORD || "password",
database: process.env.CLICKHOUSE_DATABASE || "default",
table: process.env.CLICKHOUSE_TABLE || "vector_table",
}
);
// Sleep 1 second to ensure that the search occurs after the successful insertion of data.
// eslint-disable-next-line no-promise-executor-return
await new Promise((resolve) => setTimeout(resolve, 1000));
// Perform similarity search without filtering
const results = await vectorStore.similaritySearch("hello world", 1);
console.log(results);
// Perform similarity search with filtering
const filteredResults = await vectorStore.similaritySearch("hello world", 1, {
whereStr: "metadata.name = '1'",
});
console.log(filteredResults);
从现有集合中查询文档
复制
向 AI 提问
import { ClickHouseStore } from "@langchain/community/vectorstores/clickhouse";
import { OpenAIEmbeddings } from "@langchain/openai";
// Initialize ClickHouse store
const vectorStore = await ClickHouseStore.fromExistingIndex(
new OpenAIEmbeddings(),
{
host: process.env.CLICKHOUSE_HOST || "localhost",
port: process.env.CLICKHOUSE_PORT || 8443,
username: process.env.CLICKHOUSE_USER || "username",
password: process.env.CLICKHOUSE_PASSWORD || "password",
database: process.env.CLICKHOUSE_DATABASE || "default",
table: process.env.CLICKHOUSE_TABLE || "vector_table",
}
);
// Sleep 1 second to ensure that the search occurs after the successful insertion of data.
// eslint-disable-next-line no-promise-executor-return
await new Promise((resolve) => setTimeout(resolve, 1000));
// Perform similarity search without filtering
const results = await vectorStore.similaritySearch("hello world", 1);
console.log(results);
// Perform similarity search with filtering
const filteredResults = await vectorStore.similaritySearch("hello world", 1, {
whereStr: "metadata.name = '1'",
});
console.log(filteredResults);
相关
以编程方式连接这些文档到 Claude、VSCode 等，通过 MCP 获取实时答案。