Which integrations are available for this server?

Enables querying and managing ClickHouse databases with support for HTTP/HTTPS and read-only enforcement. Enables querying and managing Huawei DWS (GaussDB) databases with schema discovery and read-only enforcement. Enables querying and managing MongoDB databases with JSON query support and read-only enforcement. Enables querying and managing MySQL databases with schema discovery, pagination, and read-only enforcement. Enables querying and managing PostgreSQL databases with schema discovery, pagination, and read-only enforcement. Enables querying and managing SQLite database files with schema discovery and read-only enforcement.

How do I use mcp-data-source?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mcp-data-source show tables in the production MySQL database" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

mcp-data-source

by Crankhead

Overview Schema Related Servers Score Discussions

TypeScript

Local

mcp-data-source

Multi-datasource MCP Server — connect AI assistants to 6 database types with dynamic configuration and secure credential storage.

License: MIT

📖 完整中文文档：docs/user-guide.md

Features

Capability	Description
6 Database Types	MySQL, PostgreSQL, ClickHouse, MongoDB, SQLite, Huawei DWS
Dynamic Configuration	Add/remove data sources at runtime via MCP tools — no restart needed
Secure Storage	Passwords encrypted with AES-256-GCM, stored in local SQLite
Read-Only by Default	Write operations require explicit `readOnly: false`
Schema Discovery	Auto-detect table structure to assist natural-language-to-SQL
Pagination	Built-in `limit`/`offset` pagination with `hasMore` indicator
Query Timeout	Per-database timeouts prevent long-running queries from blocking
SSL/TLS	Encrypted connections with client certificate support
Offline CLI	`mcp-ds` for managing data sources — passwords never leave your machine

Related MCP server: DBHub

Architecture

MCP Client (Claude Code / Claude Desktop / OpenCode)
    │ stdio
    ▼
┌─────────────────────────────────────┐
│         mcp-data-source             │
│  ┌──────────┐  ┌──────────────────┐ │
│  │ 9 Tools  │  │  Connectors (6)  │ │
│  │ config/* │  │ mysql / pg / dws │ │
│  │ query/*  │  │ ch / mongo / sql │ │
│  └──────────┘  └──────────────────┘ │
│         │              │             │
│    ~/.mcp-data-source/   Remote DBs  │
│    config.db (encrypted)            │
└─────────────────────────────────────┘

Installation

cd mcp-data-source
npm install
npm run build
npm link            # makes mcp-ds globally available

Or for distribution:

npm pack            # → mcp-data-source-1.0.0.tgz
npm install -g mcp-data-source-1.0.0.tgz

Requirements: Node.js ≥ 18.x, npm ≥ 9.x.

MCP Client Configuration

Configuration is a two-step process: ① Set encryption key (system env var) → ② Register the server (MCP client config).

⚠️ MCP_DATA_SOURCE_KEY is a system environment variable read via process.env. It does NOT go in the MCP config file. The config only carries MCP_LOG_LEVEL (optional).

Step 1: Set Encryption Key (system env var)

First, generate and set MCP_DATA_SOURCE_KEY as a system environment variable (see Generate Encryption Key below).

macOS / Linux — add to ~/.zshrc or ~/.bashrc:

export MCP_DATA_SOURCE_KEY=your-64-char-hex-key

Windows — set in System Environment Variables, or PowerShell:

[Environment]::SetEnvironmentVariable("MCP_DATA_SOURCE_KEY", "your-64-char-hex-key", "User")

Restart your terminal / MCP client after setting.

Step 2: MCP Client Config

⚠️ Configuration format differs between MCP clients. Copy-pasting between them won't work.

Format Comparison

Setting	Claude Code	Claude Desktop	OpenCode
Config file	`.mcp.json` or `settings.json`	`claude_desktop_config.json`	`opencode.json`
Top-level key	`mcpServers`	`mcpServers`	`mcp`
Env var key	`env`	`env`	`environment`
Extra fields	—	—	`"type": "local"`, `"enabled": true`

Claude Code

{
  "mcpServers": {
    "data-source": {
      "command": "mcp-data-source",
      "env": {
        "MCP_LOG_LEVEL": "info"
      }
    }
  }
}

Claude Desktop

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows).

{
  "mcpServers": {
    "data-source": {
      "command": "node",
      "args": ["/absolute/path/to/dist/server.js"],
      "env": {
        "MCP_LOG_LEVEL": "info"
      }
    }
  }
}

OpenCode

Config file: opencode.json in project root (not .mcp.json).

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "data-source": {
      "type": "local",
      "command": ["mcp-data-source"],
      "environment": {
        "MCP_LOG_LEVEL": "info"
      },
      "enabled": true
    }
  }
}

Common OpenCode pitfalls: using mcpServers instead of mcp, env instead of environment, or forgetting "enabled": true.

CLI Tool (`mcp-ds`)

Manage data sources offline — passwords never go through the LLM.

# Add a data source (interactive password prompt — secure)
mcp-ds add mysql --name prod --host 10.0.0.1 --port 3306 --username admin --password

# Add via environment variable (for scripting)
DB_PASS=xxx mcp-ds add mysql --name prod --host 10.0.0.1 --username admin --password-env DB_PASS

# SQLite
mcp-ds add sqlite --name local --file-path /path/to/database.db

# ClickHouse with HTTPS
mcp-ds add clickhouse --name ch --host 10.0.0.1 --username admin --password --protocol https

# List, test, delete
mcp-ds list
mcp-ds test prod
mcp-ds delete prod

Full `add` Options

Option	Required	Description
`--name`	✅	Unique data source name
`--host`	*	Database host (not for SQLite)
`--port`		Port (uses default for type)
`--database`		Database name
`--username`	*	Username (not for SQLite)
`--password`		Interactive prompt (secure, recommended)
`--password-env <var>`		Read password from env variable
`--file-path`	*	SQLite file path (SQLite only)
`--protocol`		ClickHouse: `http` or `https`
`--ssl`		Enable SSL/TLS
`--ssl-ca`		CA certificate content
`--ssl-cert`		Client certificate content
`--ssl-key`		Client private key content

Generate Encryption Key

node -e "console.log(require('crypto').randomBytes(32).toString('hex'))"
# Or: openssl rand -hex 32

Set the generated key as a system environment variable (not in MCP config):

macOS/Linux: export MCP_DATA_SOURCE_KEY=... in ~/.zshrc or ~/.bashrc Windows: System Environment Variables, or [Environment]::SetEnvironmentVariable("MCP_DATA_SOURCE_KEY", "...", "User") in PowerShell

Keep it safe — if lost, stored passwords cannot be decrypted. Restart your MCP client after setting.

Supported Databases

Database	`type`	Required Fields	Default Port
MySQL	`mysql`	host, username, password	3306
PostgreSQL	`postgresql`	host, username, password	5432
Huawei DWS	`dws`	host, username, password	5432
ClickHouse	`clickhouse`	host, username, password	8123
MongoDB	`mongodb`	host, username, password	27017
SQLite	`sqlite`	filePath	—

MCP Tools Overview

Configuration (6 tools)

Tool	Description
`get_connection_params`	Get required fields for a database type
`add_data_source`	Add new data source (credentials encrypted)
`list_data_sources`	List all configured sources (passwords hidden)
`update_data_source`	Modify an existing data source
`delete_data_source`	Remove a data source
`test_connection`	Verify connectivity to a data source

Query (3 tools)

Tool	Description
`query_execute`	Execute SQL or MongoDB JSON query
`get_schema`	Discover table structure
`prepare_query`	Get schema context for natural language questions

Quick Usage Examples

# Add and explore
User: Add a MySQL data source named "prod" at 10.0.0.1:3306, user admin, password secret123
User: Test the connection
User: Show me the tables in prod

# Natural language query
User: How many orders were placed last month in the analytics database?
→ AI auto-discovers schema, constructs SQL, and returns results

# Pagination
User: Query users table, 50 per page
User: Next page

# Write operations (requires explicit authorization)
User: Insert a new user record, allow writes

Environment Variables

Variable	Required	Default	How to set	Description
`MCP_DATA_SOURCE_KEY`	Yes	—	System env var	AES-256-GCM encryption key (64 hex chars)
`MCP_LOG_LEVEL`	No	`info`	MCP config `env`/`environment`	Log level: `debug` / `info` / `warn` / `error`

MCP_DATA_SOURCE_KEY is read from the system environment by process.env. MCP_LOG_LEVEL can be injected via the MCP client config.

Security

AES-256-GCM authenticated encryption with random IV per operation
Passwords stored encrypted in ~/.mcp-data-source/config.db
list_data_sources never returns password fields
Default readOnly: true blocks all write operations
Each query uses an isolated connection, closed immediately after use
Connection pooling (max 10) with automatic cleanup for MySQL/PostgreSQL

Troubleshooting

Issue	Check
Server won't start	Run `npm install && npm run build`, verify `dist/server.js` exists
Encryption key not configured	Set `MCP_DATA_SOURCE_KEY` as a system environment variable (not in MCP config). Verify with `echo $MCP_DATA_SOURCE_KEY`
OpenCode `/mcp` shows empty	Use `opencode.json` (not `.mcp.json`), key `mcp` (not `mcpServers`), `environment` (not `env`), and `"enabled": true`
Connection test fails	Check network/VPN, port, credentials, remote access enabled
Write operation rejected	Set `readOnly: false` in `query_execute`
Query timeout	Optimize SQL, reduce `limit`, or add indexes

For detailed troubleshooting and advanced usage, see docs/user-guide.md.

License

MIT

This server cannot be installed

license - not found

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly
Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
OpenAI
open source

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Crankhead/mcp-data-source'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

mcp-data-source

Features

Architecture

Installation

MCP Client Configuration

Step 1: Set Encryption Key (system env var)

Step 2: MCP Client Config

Format Comparison

Claude Code

Claude Desktop

OpenCode

CLI Tool (mcp-ds)

Full add Options

Generate Encryption Key

Supported Databases

MCP Tools Overview

Configuration (6 tools)

Query (3 tools)

Quick Usage Examples

Environment Variables

Security

Troubleshooting

License

Maintenance

Resources

Looking for Admin?

Latest Blog Posts

MCP directory API

CLI Tool (`mcp-ds`)

Full `add` Options