Hydrolix time-series datalake integration providing schema exploration and query capabilities to LLM-based workflows.
An MCP server for Hydrolix.
run_select_query
sql
(string): The SQL query to execute.readonly = 1
to ensure they are safe.list_databases
list_tables
database
(string): The name of the database.Due to the wide variety in LLM architectures, not all models will proactively use the tools above, and few will use them effectively without guidance, even with the carefully-constructed tool descriptions provided to the model. To get the best results out of your model while using the Hydrolix MCP server, we recommend the following:
The Hydrolix MCP server is configured using a standard MCP server entry. Consult your client's documentation for specific instructions on where to find or declare MCP servers. An example setup using Claude Desktop is documented below.
The recommended way to launch the Hydrolix MCP server is via the uv
project manager, which will manage installing all other dependencies in an isolated environment.
MCP Server definition (JSON):
{
"command": "uv",
"args": [
"run",
"--with",
"mcp-hydrolix",
"--python",
"3.13",
"mcp-hydrolix"
],
"env": {
"HYDROLIX_HOST": "<hydrolix-host>",
"HYDROLIX_USER": "<hydrolix-user>",
"HYDROLIX_PASSWORD": "<hydrolix-password>"
}
}
MCP Server definition (YAML):
command: uv
args:
- run
- --with
- mcp-hydrolix
- --python
- "3.13"
- mcp-hydrolix
env:
HYDROLIX_HOST: <hydrolix-host>
HYDROLIX_USER: <hydrolix-user>
HYDROLIX_PASSWORD: <hydrolix-password>
Open the Claude Desktop configuration file located at:
~/Library/Application Support/Claude/claude_desktop_config.json
%APPDATA%/Claude/claude_desktop_config.json
Add a mcp-hydrolix
server entry to the mcpServers
config block:
{
"mcpServers": {
"mcp-hydrolix": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-hydrolix",
"--python",
"3.13",
"mcp-hydrolix"
],
"env": {
"HYDROLIX_HOST": "<hydrolix-host>",
"HYDROLIX_USER": "<hydrolix-user>",
"HYDROLIX_PASSWORD": "<hydrolix-password>"
}
}
}
}
Update the environment variable definitions to point to your Hydrolix cluster.
(Recommended) Locate the command entry for uv
and replace it with the absolute path to the uv
executable. This ensures that the correct version of uv
is used when starting the server. You can find this path using which uv
or where.exe uv
.
Restart Claude Desktop to apply the changes. If you are using Windows, ensure Claude is stopped completely by closing the client using the system tray icon.
The following variables are used to configure the Hydrolix connection. These variables may be provided via the MCP config block (as shown above), a .env
file, or traditional environment variables.
HYDROLIX_HOST
: The hostname of your Hydrolix serverHYDROLIX_USER
: The username for authenticationHYDROLIX_PASSWORD
: The password for authenticationHYDROLIX_PORT
: The port number of your Hydrolix server
8088
HYDROLIX_VERIFY
: Enable/disable SSL certificate verification
"true"
"false"
to disable certificate verification (not recommended for production)HYDROLIX_DATABASE
: Default database to use
Read-only database access with schema inspection
Database interaction and business intelligence capabilities
Embeddings, vector search, document storage, and full-text search with the open-source AI application database
Query your ClickHouse database server.
Interact with the data stored in Couchbase clusters using natural language.
Provides AI assistants with a secure and structured way to explore and analyze data in GreptimeDB.
Open source MCP server specializing in easy, fast, and secure tools for Databases.
Interact & query with Meilisearch (Full-text & semantic search API)
Search, Query and interact with data in your Milvus Vector Database.
Query and analyze data with MotherDuck and local DuckDB