ClickHouse
Integrates with ClickHouse databases to execute SQL queries and retrieve results in JSON format, ena...
Determine Your Clickhouse Server Credentials
- You need to know your Clickhouse server's host address, the username, and the password required for access.
- Optionally, have the name of the database you wish to connect to.
- Decide if you want to enable read-only mode (recommended for extra safety—set as "true" for read-only, "false" for full access).
Log in to the FastMCP Connection Interface
- Click the “Install Now” button to add ENV values for the Clickhouse integration.
Fill in the Environment Variable Fields as Follows:
- CLICKHOUSE_HOST: Enter the address of your Clickhouse server (e.g.,
example.server.com). - CLICKHOUSE_USER: Enter your Clickhouse username (default is usually
root). - CLICKHOUSE_PASSWORD: Enter your Clickhouse password.
- CLICKHOUSE_DATABASE (optional): Enter the database name if you want to connect to a specific initial database.
- CLICKHOUSE_READONLY: Set this to
"true"for a read-only connection,"false"for full access (default:"false").
- CLICKHOUSE_HOST: Enter the address of your Clickhouse server (e.g.,
Save the Configuration
- Confirm the values and save the connection.
Notes:
- These values correspond to your Clickhouse account and server—if you do not have them, contact your Clickhouse administrator.
- No API key is required—just the server connection details above.
You can now proceed with using the Clickhouse MCP server integration in your environment.
How to Install ClickHouse
Install ClickHouse MCP server with one click through FastMCP. Choose your preferred AI development tool below:
Claude Desktop
Click "Claude Desktop" in Quick Start
Cursor IDE
Click "Cursor IDE" in Quick Start
VS Code
Click "VS Code" in Quick Start
Alternatives to ClickHouse
Looking for similar MCP servers? Browse other servers in the same categories on FastMCP, or check out the similar servers listed above.
Compare side by side
Quick Start
Choose Connection Type for
Authentication Required
Please sign in to use FastMCP hosted connections
Run MCP servers without
local setup or downtime
Access to 1,000+ ready-to-use MCP servers
Skip installation, maintenance, and trial-and-error.
No local setup or infra
Run MCP servers without Docker, ports, or tunnels.
Always online
Your MCP keeps working even when your laptop is off.
One secure URL
Use the same MCP from any agent, anywhere.
Secure by default
Encrypted connections. Secrets never stored locally.
Configuration for
Environment Variables
Please provide values for the following environment variables:
HTTP Headers
Please provide values for the following HTTP headers:
started!
The MCP server should open in . If it doesn't open automatically, please check that you have the application installed.
Copy and run this command in your terminal:
Make sure Gemini CLI is installed:
Visit Gemini CLI documentation for installation instructions.
Make sure Claude Code is installed:
Visit Claude Code documentation for installation instructions.
Installation Steps:
Configuration
Installation Failed
More for Database
View All →Supabase MCP Server
Remote
Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.
Svelte
Remote
Official Svelte documentation access and code analysis server that provides up-to-date reference material, playground link generation, and intelligent autofixer capabilities for detecting common patterns, anti-patterns, and migration opportunities in Svelte 5 and SvelteKit projects.
Similar MCP Servers
ClickHouse
Unlock powerful analytics with the ClickHouse MCP Server—seamlessly run, explore, and manage SQL queries across ClickHouse clusters or with chDB’s embedded OLAP engine. This server offers easy database and table listing, safe query execution, and flexible access to data from files, URLs, or databases. Built-in health checks ensure reliability, while support for both ClickHouse and chDB enables robust data workflows for any project.
