1. Conduid
  2. Data
  3. MCP
MCP server · Data

MCP

by · github.com/comcpwork/mcp

mcp servers for mysql、redis、 sqlite、clickhouse

Unclaimed MIT last commit 9 months ago datamcpmcp-serverclickhousegolangsqlitemysql
InstallView source
58Fair

Scored 2 days ago · breakdown

About MCP

MCP is an MCP server published by comcpwork in the Data category: mcp servers for mysql、redis、 sqlite、clickhouse.

The repository has 2 stars and 0 forks, with the last commit 9 months ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.

Install

From source
git clone https://github.com/comcpwork/mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Ask AI

✦

Ask AI about MCP

Powered by Claude · Grounded in docs

I know everything about MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

  • ✓README presentThe repository ships documentation.
  • ✓License declaredUsable under a stated license.
  • !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.

3 checks have not been run yet.

Releases

v1.0.1MCP v1.0.1 · 28 Jul 2025🎉 MCP v1.0.1 ✨ Features Multi-database support (MySQL, Redis, Pulsar) Natural language interface for AI assistants Granular security controls with command-line flags SQL parser for accurate permission validation 📦 安装 Linux/macOS chmod +x…
v0.1.0MCP v0.1.0 · 25 Jul 2025🎉 MCP v0.1.0 ✨ Features Multi-database support (MySQL, Redis, Pulsar) Natural language interface for AI assistants Granular security controls with command-line flags SQL parser for accurate permission validation 📦 安装 Linux/macOS chmod +x…

README

MCP Database Tools

English | 中文

Execute MySQL, Redis, ClickHouse and SQLite commands through natural language conversations with AI assistants.

Features

  • MySQL - Execute SQL queries and modifications
  • Redis - Execute Redis commands
  • ClickHouse - Execute ClickHouse SQL statements
  • SQLite - Execute SQLite SQL (file-based or in-memory)
  • SSH Tunneling - Connect to databases through SSH bastion hosts

Installation

Requirements

  • Go 1.21 or higher
  • MCP Client (Claude Code, Cursor, Cline, etc.)

Step 1: Install the Tool

go install github.com/comcpwork/mcp/cmd/cowork-database@latest

Step 2: Configure Your MCP Client

Claude Code

Add the MCP server:

claude mcp add database -- cowork-database database

Cursor / Cline / Other MCP Clients

Add to your MCP configuration file:

{
  "mcpServers": {
    "database": {
      "command": "cowork-database",
      "args": ["database"]
    }
  }
}

Configuration file locations:

  • Claude Desktop (macOS): ~/Library/Application Support/Claude/claude_desktop_config.json
  • Claude Desktop (Windows): %APPDATA%\Claude\claude_desktop_config.json
  • Cursor: Settings > Features > MCP Servers
  • Cline (VS Code): .vscode/mcp.json or VS Code settings

Step 3: Restart Your Client

Restart your MCP client to load the database tools.

Quick Start

Ask your AI assistant:

  • MySQL: "Execute MySQL with DSN root:password@tcp(localhost:3306)/test and SQL: SELECT * FROM users"
  • Redis: "Execute Redis command PING on redis://localhost:6379/0"
  • ClickHouse: "Execute ClickHouse with DSN clickhouse://default:@localhost:9000/default and SQL: SELECT 1"
  • SQLite: "Execute SQLite with DSN :memory: and SQL: SELECT 1"

DSN Formats

Database Format Example
MySQL user:pass@tcp(host:port)/dbname root:password@tcp(localhost:3306)/mydb
Redis redis://[:password@]host:port/db redis://localhost:6379/0
ClickHouse clickhouse://user:pass@host:port/db clickhouse://default:@localhost:9000/default
SQLite /path/to/file.db or :memory: /data/mydb.db or :memory:

SSH Connection

All tools support optional SSH tunneling through the ssh parameter.

SSH URI Formats

Format Example Description
Config reference ssh://myserver Use ~/.ssh/config entry
Password auth ssh://user:pass@host:port Direct password authentication
Key auth ssh://user@host?key=/path/to/key Private key authentication

Example

{
  "dsn": "root:password@tcp(10.0.0.100:3306)/mydb",
  "sql": "SELECT * FROM users",
  "ssh": "ssh://admin@jump.example.com?key=~/.ssh/id_rsa"
}

Note: SQLite uses remote command execution mode (requires sqlite3 on remote server).

Documentation

License

MIT License - see LICENSE file for details.

README copy captured when this server was indexed; it may lag the repository. The original is authoritative.

Questions

About MCP

How do I install MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is MCP safe to use with an AI agent?

Its trust score is 58 out of 100 (fair). It passes 2 of the 3 static security checks run so far; the failures are listed above. It has no ConduID identity yet, so agent calls to it are not receipted.

Is MCP still maintained?

The last commit was 9 months ago. That's long enough that you should check whether the maintainer is responding to issues before depending on it.