Overview
What is Hologres MCP Server?
Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases. It enables seamless communication between AI Agents and Hologres, helping AI Agents retrieve Hologres database metadata and execute SQL operations.
How to use Hologres MCP Server?
Configure via an MCP client configuration file (e.g., using uv, uvx, or pip). Set environment variables (HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, HOLOGRES_DATABASE) and specify the command and arguments. Alternatively, use Streamable HTTP transport for remote deployment: start with hologres-mcp-server --transport streamable-http --host 0.0.0.0 --port 8000. Use with Claude Code via claude mcp add hologres-mcp-server.
Key features of Hologres MCP Server
- Execute SELECT, DML, and DDL SQL queries on Hologres
- Retrieve metadata: schemas, tables, views, external tables, DDL
- Collect table statistics and get query plans
- Analyze slow queries and active queries
- Manage dynamic tables, query queues, warehouses, and recycling bin
- Generate charts from query results (bar, line, scatter, pie, histogram, area)
- Access system information via resource templates
Use cases of Hologres MCP Server
- AI‑powered database exploration and schema discovery
- Automated SQL optimization and performance analysis
- Monitoring and troubleshooting query performance
- Managing Hologres resources (warehouses, query queues, dynamic tables)
- Integration with AI coding assistants for data‑driven development
FAQ from Hologres MCP Server
What transport protocols does Hologres MCP Server support?
It supports stdio, streamable-http, and sse.
What environment variables are required?
HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE.
How do I install Hologres MCP Server?
You can install via pip install hologres-mcp-server or clone from GitHub.
Can I run Hologres MCP Server remotely?
Yes, use --transport streamable-http to start an HTTP endpoint, then configure the client with a url.
Does Hologres MCP Server support Claude Code?
Yes, use claude mcp add hologres-mcp-server with the required environment variables and -- uvx hologres-mcp-server.
