Hologres MCP Server

@MCP-Mirror

代码仓库

基本信息

分类

其他

许可证

Apache-2.0 license

传输方式

stdio

作者

MCP-Mirror

关于 Hologres MCP Server

Mirror of

#hologres #mcp-server #ai-integration

Hologres MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "hologres-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "hologres-mcp-server",
        "hologres-mcp-server"
      ],
      "env": {
        "HOLOGRES_HOST": "",
        "HOLOGRES_PORT": "",
        "HOLOGRES_USER": "",
        "HOLOGRES_PASSWORD": "",
        "HOLOGRES_DATABASE": ""
      }
    }
  }
}

Hologres MCP Server 工具

Execute queries in Hologres

Collect table statistics

Get query plan

Get execution plan

概览

What is Hologres MCP Server?

Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases. It enables AI Agents to retrieve Hologres database metadata and execute SQL operations.

How to use Hologres MCP Server?

Install using pip install hologres-mcp-server or clone from GitHub. Add the MCP server configuration to your MCP client config file, setting the environment variables HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE. Launch using the provided uv commands for either local or pip mode.

Key features of Hologres MCP Server

Execute SQL queries in Hologres databases
Collect table statistics via analyze_table
Retrieve query plans and execution plans
Access database schemas, tables, and DDL
View recent and user/application-specific query logs
Inspect system status (missing statistics, current queries)

Use cases of Hologres MCP Server

AI agents autonomously querying Hologres for analytics
Automated database metadata retrieval for schema documentation
Performance debugging with query plan analysis
Monitoring query logs per user or application
Statistic health checks via missing_stats_tables

常见问题

What tools does Hologres MCP Server provide?

It provides `execute_sql`, `analyze_table`, `get_query_plan`, and `get_execution_plan`.

How do I configure the server for my database?

Set the environment variables `HOLOGRES_HOST`, `HOLOGRES_PORT`, `HOLOGRES_USER`, `HOLOGRES_PASSWORD`, and `HOLOGRES_DATABASE` in the MCP client configuration.

What runtime dependencies are required?

Python with `uv` installed is required. The server can be installed via `pip` or run from a local clone.

What type of data can I access via resources?

You can access schemas, table lists, DDL, table statistics, query logs (by row limit, user, or application), and system paths like `missing_stats_tables` and `stat_activity`.

Are there any built-in prompts?

No, the README does not list any prompts for this server.

其他分类下的更多 MCP 服务器

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

ICSS

chokcoco

不止于 CSS

20.7K

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K