mcp-server-mariadb logo

mcp-server-mariadb

by abel9851

An MCP server implementation designed for retrieving data from MariaDB databases. It exposes schema information and provides tools for executing read-only queries.

View on GitHub

Last updated: N/A

What is mcp-server-mariadb?

This is an MCP (Message Communication Protocol) server specifically built to interact with MariaDB databases. It allows applications, such as Claude Desktop, to access and query data stored in MariaDB.

How to use mcp-server-mariadb?

To use this server, you need to configure it within your application (e.g., Claude Desktop) by providing the necessary database connection details (host, port, user, password, database name). The README provides configuration examples for both published and development servers. You'll also need to install the MariaDB Connector/C dependency.

Key features of mcp-server-mariadb

  • Exposes schema list in database

  • Provides a query_database tool for read-only operations

  • Supports configuration with Claude Desktop

  • Uses environment variables for database credentials

Use cases of mcp-server-mariadb

  • Integrating MariaDB data into applications like Claude Desktop

  • Providing a secure and controlled interface for querying MariaDB

  • Building data-driven applications that require access to MariaDB data

  • Enabling read-only access to MariaDB for reporting and analytics

FAQ from mcp-server-mariadb

What is MCP?

MCP stands for Message Communication Protocol. It's a protocol used for communication between different components or services.

What is MariaDB Connector/C?

MariaDB Connector/C is a client library that allows applications to connect to MariaDB databases.

How do I resolve the OSError: mariadb_config not found?

Install mariadb-connector-c using brew install mariadb-connector-c, set the PATH, and set the MARIADB_CONFIG environment variable as described in the README.

Where do I find the Claude Desktop config file?

The config file is located at ~/Library/Application Support/Claude/claude_desktop_config.json on MacOS and %APPDATA%\Claude\claude_desktop_config.json on Windows.

What kind of operations can I perform with query_database?

You can only execute read-only operations against the MariDB database using the query_database tool.