MariaDB MCP Server by CData

@CDataSoftware

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

CDataSoftware

投稿者

Cameron Leblanc

MariaDB MCP Server by CData について

This read-only MCP Server allows you to connect to MariaDB data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

#mariadb #mcp-server #cdata

MariaDB MCP Server by CData の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\mariadb.prp"
      ]
    }
  }
}

MariaDB MCP Server by CData のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MariaDB MCP Server by CData?

A read-only MCP server that allows large language models (like Claude Desktop) to query live MariaDB data using natural language. It wraps the CData JDBC Driver for MariaDB and exposes it as SQL models accessible via simple MCP tools.

How to use MariaDB MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for MariaDB, create a .prp file with your connection details (prefix, DriverPath, JdbcUrl, etc.), then configure your MCP client (e.g., Claude Desktop) to run the JAR with the .prp file as an argument. The server runs locally over stdio.

Key features of MariaDB MCP Server by CData

Read-only queries to live MariaDB data via natural language.
Exposes three MCP tools: get_tables, get_columns, run_query.
License under the MIT License.
Works with any MCP client that supports stdio transport.
Uses the CData JDBC Driver for robust connectivity.
No SQL knowledge required for end users.

Use cases of MariaDB MCP Server by CData

AI assistants answering business questions about MariaDB data.
Live analytics dashboards driven by LLM queries.
Ad-hoc data exploration without writing SQL.
Integration with Claude Desktop for conversational data access.

よくある質問

Is this server read-only?

Yes, the project explicitly builds a local, read-only MCP server. The only query tool offered is `run_query` which executes SQL SELECT statements.

What are the dependencies?

You need Java, Maven, and the CData JDBC Driver for MariaDB (free trial or licensed). The JDBC driver must be installed and activated separately.

How do I configure the connection?

Create a `.prp` file with properties: Prefix, ServerName, ServerVersion, DriverPath (full path to the JDBC JAR), DriverClass (e.g., `cdata.jdbc.mariadb.MariaDBDriver`), JdbcUrl (connection string from the JDBC utility), and Tables (leave blank for all). Example content is provided in the README.

What transport does it use?

The server uses stdio transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop). Remote access is not supported in this local build.

Does it support write, update, or delete operations?

No. Despite a mention of “read, write, update, and delete” in the usage section, the server is explicitly labeled as read-only and only provides a `run_query` tool for SELECT queries.

「データベース」の他のコンテンツ

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note