highgo-mcp
Enables AI agents to connect, query, and analyze Highgo Database using SQL execution, schema management, and metadata queries.
README
Highgo MCP Server (瀚高数据库 MCP 服务)
这是一个基于 Model Context Protocol (MCP) 实现的瀚高数据库 (Highgo Database) 服务。它允许 AI 智能体(如 Claude Desktop, Gemini CLI 等)直接连接、查询和分析瀚高数据库中的数据。
特性
- SQL 执行: 支持执行任意 SQL 语句,包括瀚高特有的 SM3 加密和语法。
- Schema 管理: 支持通过
search_path动态切换工作 schema。 - 元数据查询: 快速列出库中的表结构、字段类型及注释。
- 独立分发: 支持通过
npx直接运行,无需全局安装。
快速开始
1. 前置条件
- 已安装 Node.js (建议 v18+)
- 瀚高数据库的连接信息
2. 数据库配置
在项目根目录下创建一个 .env 文件,或者在运行环境中设置以下环境变量:
HIGHGO_HOST=172.22.*.*
HIGHGO_PORT=5866
HIGHGO_USER=用户名
HIGHGO_PASSWORD=您的密码
HIGHGO_DATABASE=数据库名
3. 使用 npx 运行 (推荐)
如果您在本地开发,可以直接在项目目录运行:
npx .
如果您已将其发布到 NPM 或作为 Git 依赖引用,可以远程运行:
npx highgo-mcp-server
在 AI 智能体中配置
Claude Desktop
修改您的 claude_desktop_config.json 文件:
{
"mcpServers": {
"highgo": {
"command": "npx",
"args": ["-y", "/path/to/highgo-mcp"],
"env": {
"HIGHGO_HOST": "172.22.*.*",
"HIGHGO_USER": "用户名",
"HIGHGO_PASSWORD": "您的密码",
"HIGHGO_DATABASE": "数据库名"
}
}
}
}
Gemini CLI
在配置文件中添加类似的条目。
可用工具 (Tools)
query: 执行 SQL 查询。- 参数:
sql(必填),search_path(可选)。
- 参数:
list_tables: 查看指定 Schema 下的所有表。- 参数:
schema(默认 "public")。
- 参数:
describe_table: 查看表的详细列信息。- 参数:
table_name(必填),schema(默认 "public")。
- 参数:
本地开发
# 安装依赖
npm install
# 本地链接以便测试
npm link
# 直接运行
node bin/mcp-server.js
许可证
ISC
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
E2B
Using MCP to run code via e2b.
Neon Database
MCP server for interacting with Neon Management API and databases
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.