MCP Universal DB Client
🚀 Execute SQL queries on any database through MCP
Model Context Protocol (MCP) server for connecting to and querying multiple databases (PostgreSQL, MySQL, SQLite).
接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
npx -y @izumisy/[email protected]Claude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
claude mcp add izumisy-mcp-universal-db-client -- npx -y @izumisy/mcp-universal-db-client@0.1.8在終端機中執行。
{ "mcpServers": { "izumisy-mcp-universal-db-client": { "command": "npx", "args": [ "-y", "@izumisy/[email protected]" ] } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
psql)mysql)sqlite)Add the server to your MCP settings configuration file:
{
"mcpServers": {
"universal-db-client": {
"command": "npx",
"args": ["-y", "@izumisy/mcp-universal-db-client"]
}
}
}
connect_databaseConnect to a database using a connection string.
Parameters:
name: Unique name for this connection (used as connection ID)dialect: Database type (psql, mysql, or sqlite)connectionString: Connection string for the databaseExample:
{
"name": "my-postgres-db",
"dialect": "psql",
"connectionString": "postgresql://user:password@localhost:5432/mydb"
}
list_connectionsList all active database connections.
Returns: Array of active connections with their IDs, dialects, and connection times
disconnect_databaseDisconnect a specific database connection.
Parameters:
connectionID: The connection ID to disconnectdisconnect_allDisconnect all active database connections.
query_read - Read-Only QueriesRun SELECT and other read-only SQL queries safely.
Supported Operations:
SELECT - Query dataSHOW - Show database informationDESCRIBE / DESC - Describe table structureEXPLAIN - Explain query execution planParameters:
connectionID: The connection ID (connection name)query: Array of SQL query strings (read-only operations only)Example:
{
"connectionID": "my-postgres-db",
"query": [
"SELECT * FROM users WHERE id = 1",
"SELECT COUNT(*) FROM orders WHERE status = 'pending'"
]
}
Security: This tool validates queries and rejects destructive operations, making it safe for read-only access. If a destructive query is detected, it returns an error message suggesting to use query_write instead.
query_write - Destructive Queries ⚠️Run INSERT, UPDATE, DELETE and other data-modifying queries.
Supported Operations:
INSERT - Insert new dataUPDATE - Update existing dataDELETE - Delete dataCREATE / ALTER / DROP - DDL operationsTRUNCATE - Truncate tableREPLACE / MERGE - Replace/merge dataParameters:
connectionID: The connection ID (connection name)query: Array of SQL query strings (any operation)Example:
{
"connectionID": "my-postgres-db",
"query": [
"INSERT INTO users (name, email) VALUES ('John Doe', '[email protected]')",
"UPDATE orders SET status = 'completed' WHERE id = 123"
]
}
Security: Use with caution as this tool can modify data. Should be restricted to authorized users only.
MIT
{ "mcpServers": { "izumisy-mcp-universal-db-client": { "command": "npx", "args": [ "-y", "@izumisy/[email protected]" ] } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
@izumisy/mcp Universal Db Client 透過 stdio 在本機執行。
上次檢查時間:2026-11-16。 MCP Universal Database Client