Advertise
MCP.so
Sign In

Hologres MCP Server

@MCP-Mirror

Repository

Basic information

Category

Other

License

Apache-2.0 license

Transports

stdio

Author

MCP-Mirror

About Hologres MCP Server

Mirror of

#hologres#mcp-server#ai-integration

Hologres MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

4

Execute queries in Hologres

Collect table statistics

Get query plan

Get execution plan

Overview

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

Frequently asked questions

1

What tools does Hologres MCP Server provide?

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

2

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.

3

What runtime dependencies are required?

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

4

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`.

5

Are there any built-in prompts?

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

Comments

More Other MCP servers

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

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

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

Advertise