MCPDBWizard for MariaDB

io.github.srmadscience由 GitHub 帳號 srmadscience 發布v2.0.46更新於 Nov 15, 2026

一個根據你選擇的儲存過程、表和語句建立的 MariaDB MCP 伺服器。沒有 run-sql 工具

AI 翻譯由 AI 模型根據下方的原文描述翻譯,可能有誤。

原文描述

A MariaDB MCP server built from the procedures, tables and statements you select. No run-sql tool

發布方自己的服務:MariaDB Documentation

已驗證STDIO僅桌面資料庫開發者工具

概覽

MCPDBWizard for MariaDB 的本機 MCP 服務;無需登入;STDIO。

暫無 AI 概覽:以下資訊來自註冊中心條目和服務本身。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 MCPDBWizard for MariaDB,將其新增到工作區。
  2. 為需要使用其工具的對話啟用該服務。

Desktop only,透過 STDIO。 STDIO 服務會啟動本機處理程序,因此需要 SourceWeft 桌面主機。

其他 MCP 客戶端

參照 儲存庫 中的啟動說明。

README

MCPDBWizard for MariaDB

MCPDBWizard for MariaDB generates MCP servers from a MariaDB schema. You select the tables, views, functions, procedures, Oracle-mode package members, sequences and SQL statements to expose, and it generates a server for exactly those. An agent then reaches the database only through typed tools. Nothing you didn't select has any code generated for it, and every call binds values rather than passing SQL text.

It ships as a Docker image. The web console runs inside it: Design chooses what to expose, and Runtime generates, starts and fronts the servers over HTTP.

This repository holds no source code. It exists for the release notes and as a public home for the image.

Get the image

docker pull ghcr.io/srmadscience/mcpdbwizard-mariadb:latestdocker pull docker.io/srmadscience/mcpdbwizard-mariadb:latest

Both registries hold the same multi-arch image (linux/amd64, linux/arm64). Pin a version tag in anything that matters. latest moves, and docker run never refreshes an image the machine already has.

Run it

docker run -d --name mcpdbwizard-mariadb -p 8080:8080 -v mcpdbwizard-data:/data \  -e MCPDBWIZARD_DB_HOST=db.example.com \  -e MCPDBWIZARD_DB_NAME=appdb \  -e MCPDBWIZARD_DB_USER=appuser \  -e DB_PASS_FILE=/run/secrets/db \  -e ADMIN_INITIAL_PASSWORD='choose-a-long-one' \  ghcr.io/srmadscience/mcpdbwizard-mariadb:latest

Open http://localhost:8080, log in as admin with ADMIN_INITIAL_PASSWORD, and set a new password when asked.

SettingMeaning
MCPDBWIZARD_DB_HOSTThe database host
MCPDBWIZARD_DB_PORTIts port; 3306 if unset
MCPDBWIZARD_DB_NAMEThe database. Its objects are the ones listed as your own
MCPDBWIZARD_DB_USERThe login. It need not share the database's name
MCPDBWIZARD_DB_OTHER_USEROptional: more databases to list, as a LIKE pattern (app%)
DB_PASS_FILE or DB_PASSThe login's password: a file (preferred) or the value; not both
ADMIN_INITIAL_PASSWORDThe console's first admin password

/data holds the configs and the generated servers. Keep it on a volume.

The login needs these grants on each database it reads:

sql
GRANT SELECT, EXECUTE, SHOW CREATE ROUTINE ON appdb.* TO appuser;

SHOW CREATE ROUTINE is the one that is easy to miss. Without it, MCPDBWizard cannot read a routine's ROW parameter fields, whether a function is an aggregate, or (on 11.8) its parameter defaults. A sequence's NEXTVAL also needs INSERT on that sequence.

Supported versions

MariaDB 11.4, 11.8, 12.3 and 13.x, each tested with lower_case_table_names 0, and 11.4 and 13.0 with 1 as well. MariaDB 10.11 is not supported: a login that did not create a routine cannot read its source there, so its parameters cannot be described.

Geometry crosses as EWKT (SRID=4326;POINT(1 2)), VECTOR (11.8 and later) as an array of numbers, and JSON as its text. Cursor outputs need 12.3 or later. The MCP server is the way in: the SOAP service layer and the JSON / JSON-RPC connectors of the Oracle product are not available for MariaDB.

Documentation and licence

Documentation is at https://mcpdbwizard.com/docs/. The image is proprietary software from ATB Consultancy Services Ltd, and an MCPDBWizard licence covers the Oracle, Postgres and MariaDB products alike. See https://mcpdbwizard.com for terms.

Reporting a problem

To report a suspected security problem, use this repository's Security tab → Report a vulnerability, which keeps the report private. Please don't open a public issue for it. For anything else, open an issue. Include the image tag, the MariaDB version (select version()), and a minimal config or steps that reproduce it.

來源:README.md,提交 7a572f7

工具

0
SourceWeft 曾在隔離沙箱中以無憑證方式啟動該軟體包一次,以列出其工具,但未能完成:該軟體包類型無法在沙箱中執行。

版本歷史

5
  1. v2.0.46最新Nov 15, 2026
  2. v2.0.44Nov 14, 2026
  3. v2.0.42Nov 14, 2026
  4. v2.0.40Nov 14, 2026
  5. v2.0.36Nov 12, 2026

評分

已滿足適用檢查項的 40%

該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通25 分

    請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。

  • 已宣告認證方式10 分

    請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。

  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分

    請在儲存庫或註冊中心條目中宣告授權條款。

其他 Mariadb 整合