Mcp Server Mariadb
What is Mcp Server Mariadb
mcp-server-mariadb is an MCP server implementation designed to provide read-only access to data stored in a MariaDB database.
Use cases
Use cases for mcp-server-mariadb include providing data access for analytics tools, enabling reporting systems that require read-only data, and supporting application backends that need to retrieve data without modifying it.
How to use
To use mcp-server-mariadb, configure the server settings in the Claude Desktop configuration file, specifying the database connection parameters such as host, port, user, password, and database name. Then, run the server using the appropriate command.
Key features
Key features include the ability to expose schema lists from the database and execute read-only operations against MariaDB using the query_database tool.
Where to use
mcp-server-mariadb can be used in environments where read-only access to a MariaDB database is required, such as data analysis, reporting, and application development.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Server Mariadb
mcp-server-mariadb is an MCP server implementation designed to provide read-only access to data stored in a MariaDB database.
Use cases
Use cases for mcp-server-mariadb include providing data access for analytics tools, enabling reporting systems that require read-only data, and supporting application backends that need to retrieve data without modifying it.
How to use
To use mcp-server-mariadb, configure the server settings in the Claude Desktop configuration file, specifying the database connection parameters such as host, port, user, password, and database name. Then, run the server using the appropriate command.
Key features
Key features include the ability to expose schema lists from the database and execute read-only operations against MariaDB using the query_database tool.
Where to use
mcp-server-mariadb can be used in environments where read-only access to a MariaDB database is required, such as data analysis, reporting, and application development.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
mcp-server-mariadb
An MCP server implementation for retrieving data from mariadb
Features
Resources
Expose schema list in database
Tools
- query_database
- Execute read-only operations against MariDB
dependency
install mariadb
- mac
- when install mariadb,
maybe raise os error below.
you can resolve by installing mariadb-connector-c.
- when install mariadb,
OSError: mariadb_config not found.
This error typically indicates that MariaDB Connector/C, a dependency which
must be preinstalled, is not found.
If MariaDB Connector/C is not installed, see installation instructions
If MariaDB Connector/C is installed, either set the environment variable
MARIADB_CONFIG or edit the configuration file 'site.cfg' to set the
'mariadb_config' option to the file location of the mariadb_config utility.
- execute
brew install mariadb-connector-c - execute
echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc - set environment variable
export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config - execute
uv add mariadbagain.
Usage with Claude Desktop
Configuration File
Paths to Claude Desktop config file:
- MacOS:
~/Library/Application Support/Claude/claude_desktop_config.json - Windows:
%APPDATA%\Claude\claude_desktop_config.json
Add this configuration to enable published servers
Note: Replace these placeholders with actual paths:
/PATH/TO/uvx: Full path to uvx executable
Add this configuration to enable development/unpublished servers
{
"mcpServers": {
"mcp_server_mariadb": {
"command": "/PATH/TO/uv",
"args": [
"--directory",
"/YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb",
"run",
"server.py"
],
"env": {
"MARIADB_HOST": "127.0.0.1",
"MARIADB_USER": "USER",
"MARIADB_PASSWORD": "PASSWORD",
"MARIADB_DATABASE": "DATABASE",
"MARIADB_PORT": "3306"
}
}
}
}Note: Replace these placeholders with actual paths:
/PATH/TO/uv: Full path to UV executable/YOUR/SOURCE/PATH/mcp-server-mariadb/src/mcp_server_mariadb: Path to server source code
License
This mcp server is licensed under the MIT license. please see the LICENSE file in the repository.
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
