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.
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?
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?
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?
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?
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?
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.