yunqiqiliang_mcp-clickzetta-server

yunqiqiliang_mcp-clickzetta-server

3.2
databases

If you are the rightful owner of yunqiqiliang_mcp-clickzetta-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Clickzetta MCP Server is a Model Context Protocol server implementation for interacting with Clickzetta Lakehouse, enabling SQL query execution and data insights management.

The Clickzetta MCP Server is a robust implementation of the Model Context Protocol (MCP) designed to facilitate seamless interaction with the Clickzetta Lakehouse. It allows users to execute SQL queries, manage database schemas, and append data insights dynamically. The server is equipped with tools for reading and writing queries, creating tables, and managing schema information. Additionally, it provides a dynamic resource for aggregating data insights, which auto-updates as new insights are discovered. This server is particularly useful for data analysts and developers who need to interact with large datasets and derive insights efficiently. It supports integration with platforms like Claude Desktop, providing a user-friendly interface for managing database operations and insights.

Features

  • Execute SQL Queries: Supports both read and write operations with SQL queries, including SELECT, INSERT, UPDATE, and DELETE.
  • Dynamic Insights Resource: Provides a memo resource that aggregates and updates data insights automatically.
  • Schema Management: Tools for listing tables and describing table structures to facilitate database schema management.
  • Secure Operations: Enforces read-only operations by default and includes input validation to prevent SQL injection.
  • Integration with Claude Desktop: Easily integrates with Claude Desktop for enhanced user interaction and data management.

Tools

  1. read_query

    Execute SELECT queries to read data from the database.

  2. write_query

    Execute INSERT, UPDATE, or DELETE queries with the --allow-write flag.

  3. create_table

    Create new tables in the database with the --allow-write flag.

  4. list_tables

    Get a list of all tables in the database.

  5. describe-table

    View column information for a specific table.

  6. append_insight

    Add new data insights to the memo resource.

Related MCP Servers

View all databases servers →
mindsdb

mindsdb

4.5

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

databases
mysql_mcp_server

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases
mcp-notion-server

mcp-notion-server

4.3

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases
prisma

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
mcp-server

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms
genai-toolbox

genai-toolbox

3.8

by googleapis

MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.

databases
mcp-server-qdrant

mcp-server-qdrant

3.8

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
anyquery

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

databases
mcp-clickhouse

mcp-clickhouse

3.7

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

databases
osv-mcp

osv-mcp

3.7

by StacklokLabs

An MCP server providing access to the OSV database for querying vulnerability information.

databases
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-proxy

mcp-proxy

3.7

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

databases
atlas-mcp-server

atlas-mcp-server

3.6

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools
db-mcp-server

db-mcp-server

3.6

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

databases
mcp-server-motherduck

mcp-server-motherduck

3.6

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases
mcp-graphql

mcp-graphql

3.6

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

databases
mongodb-lens

mongodb-lens

3.6

by furey

MongoDB Lens is a local Model Context Protocol (MCP) server that provides full-featured access to MongoDB databases using natural language via LLMs.

databases
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases
mssql_mcp_server

mssql_mcp_server

3.6

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

databases
mcp-tinybird

mcp-tinybird

3.6

by tinybirdco

An MCP server to interact with a Tinybird Workspace from any MCP client.

databases
mcp-server-bigquery

mcp-server-bigquery

3.6

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

databases
meilisearch-mcp

meilisearch-mcp

3.6

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

databases
mcp-snowflake-server

mcp-snowflake-server

3.6

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

databases
doris-mcp-server

doris-mcp-server

3.6

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases
notion-mcp-server

notion-mcp-server

3.6

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

ai_chatbot