Highgo MCP Server

This is a Highgo Database service implemented based on the Model Context Protocol (MCP). It allows AI agents (such as Claude Desktop, Gemini CLI, etc.) to directly connect to, query, and analyze data in a Highgo Database.

Features

• SQL Execution: Supports executing arbitrary SQL statements, including Highgo-specific SM3 encryption and syntax.

• Schema Management: Supports dynamic switching of the working schema via search_path.

• Metadata Querying: Quickly list table structures, field types, and comments in the database.

• Independent Distribution: Supports running directly via npx without global installation.

Related MCP server: PostgreSQL MCP Server

Quick Start

1. Prerequisites

• Node.js installed (v18+ recommended)

• Connection information for the Highgo Database

2. Database Configuration

Create a .env file in the project root directory, or set the following environment variables in your runtime environment:

HIGHGO_HOST=172.22.*.*
HIGHGO_PORT=5866
HIGHGO_USER=用户名
HIGHGO_PASSWORD=您的密码
HIGHGO_DATABASE=数据库名

3. Running with npx (Recommended)

If you are developing locally, you can run it directly in the project directory:

npx .

If you have published it to NPM or are referencing it as a Git dependency, you can run it remotely:

npx highgo-mcp-server

Configuration in AI Agents

Claude Desktop

Modify your claude_desktop_config.json file:

{
  "mcpServers": {
    "highgo": {
      "command": "npx",
      "args": ["-y", "/path/to/highgo-mcp"],
      "env": {
        "HIGHGO_HOST": "172.22.*.*",
        "HIGHGO_USER": "用户名",
        "HIGHGO_PASSWORD": "您的密码",
        "HIGHGO_DATABASE": "数据库名"
      }
    }
  }
}

Gemini CLI

Add similar entries to your configuration file.

Available Tools

1. query: Execute SQL queries.

   • Parameters: sql (required), search_path (optional).

2. list_tables: View all tables under a specified schema.

   • Parameters: schema (default "public").

3. describe_table: View detailed column information for a table.

   • Parameters: table_name (required), schema (default "public").

Local Development

# 安装依赖
npm install

# 本地链接以便测试
npm link

# 直接运行
node bin/mcp-server.js

License

ISC