MariaDB MCP Server by CData

@CDataSoftware

Basic information

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Frequently asked questions

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.

Comments

More Databases MCP servers

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.