Hologres MCP Server
@spyfree
About Hologres MCP Server
No overview available yet
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"hologres-mcp-server-sse": {
"command": "python",
"args": [
"examples/test_server.py"
]
}
}
}Tools
4Execute 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, enabling seamless communication for retrieving database metadata and executing SQL operations.
How to use Hologres MCP Server?
Install via local repository clone or pip install hologres-mcp-server. Configure required environment variables (HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, HOLOGRES_DATABASE). Run the server in SSE mode (default) or STDIO mode using the --transport flag. Add the server configuration to your MCP client (e.g., Cherry Studio) with the appropriate command and environment variables.
Key features of Hologres MCP Server
- Dual transport mode support (STDIO and SSE)
- Database metadata access (schemas, tables)
- SQL execution with result analysis
- Table statistics collection and viewing
- Query plan and execution plan retrieval
Use cases of Hologres MCP Server
- AI agents retrieving Hologres schema and table information
- Executing SQL queries interactively through an agent
- Collecting table statistics for performance tuning
- Obtaining query or execution plans for optimization
- Monitoring current running queries and query logs
FAQ from Hologres MCP Server
What is the default transport mode?
The server runs in SSE (Server-Sent Events) mode by default. You can switch to STDIO mode using the --transport stdio argument.
What environment variables are required?
HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE are required. SERVER_HOST and SERVER_PORT are only needed for SSE mode.
What system resources are available for monitoring?
System resource templates expose missing_stats_tables, stat_activity, query_log/latest/<row_limits>, and query logs filtered by user or application.
Can it be integrated with Cherry Studio?
Yes. For SSE mode, use the server’s host and port (e.g., http://localhost:8001). For STDIO mode, configure the command and arguments as shown in the README.
What Python version is required?
Python 3.10 or higher is required, along with the uv package manager for development.
Frequently asked questions
What is the default transport mode?
The server runs in SSE (Server-Sent Events) mode by default. You can switch to STDIO mode using the `--transport stdio` argument.
What environment variables are required?
`HOLOGRES_USER`, `HOLOGRES_PASSWORD`, and `HOLOGRES_DATABASE` are required. `SERVER_HOST` and `SERVER_PORT` are only needed for SSE mode.
What system resources are available for monitoring?
System resource templates expose `missing_stats_tables`, `stat_activity`, `query_log/latest/<row_limits>`, and query logs filtered by user or application.
Can it be integrated with Cherry Studio?
Yes. For SSE mode, use the server’s host and port (e.g., `http://localhost:8001`). For STDIO mode, configure the command and arguments as shown in the README.
What Python version is required?
Python 3.10 or higher is required, along with the `uv` package manager for development.
Basic information
More Other MCP servers
Awesome Mlops
visengerA curated list of references for MLOps
ghidraMCP
LaurieWiredMCP Server for Ghidra
Peekaboo MCP – lightning-fast macOS screenshots for AI agents
steipetePeekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.
Activepieces
activepiecesAI 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
Maestro
mobile-dev-incPainless E2E Automation for Mobile and Web
Comments