mcp-server-mariadb
Provides read-only querying of MariaDB databases, allowing users to retrieve data and explore schema.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-server-mariadblist all tables in the database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Related MCP server: WP Database MCP Server
dependency
install mariadb
mac
when install mariadb, maybe raise os error below. you can resolve by installing mariadb-connector-c.
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-cexecute
echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrcset environment variable
export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_configexecute
uv add mariadbagain.
Usage with Claude Desktop
Configuration File
Paths to Claude Desktop config file:
MacOS:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows:
%APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"mcp_server_mariadb": {
"command": "/PATH/TO/uvx"
"args": [
"mcp-server-mariadb",
"--host",
"${DB_HOST}",
"--port",
"${DB_PORT}",
"--user",
"${DB_USER}",
"--password",
"${DB_PASSWORD}",
"--database",
"${DB_NAME}"
]
}
}
}
Note: Replace these placeholders with actual paths:
/PATH/TO/uvx: Full path to uvx executable
{
"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.
This server cannot be deployed
Maintenance
Related MCP Connectors
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
An MCP server that provides access to Testiny projects, test cases and test runs
Read-only MCP server for ClassQuill, a tutoring-business-management platform.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Related MCP Servers
- AlicenseAqualityDmaintenanceAn MCP server that provides read-only access to MySQL databases.4371 npm72MIT
- AlicenseNot gradedqualityBmaintenanceRead-only MCP server for exploring WordPress MySQL/MariaDB databases. Provides schema inspection, relationship mapping, and safe SQL querying.6MIT
- AlicenseNot gradedqualityDmaintenanceMCP server for interacting with MariaDB databases, supporting standard SQL operations and optional vector/embedding search.MIT
- FlicenseNot gradedqualityDmaintenanceCustom MCP server connected to a read-only SQLite database, exposing a schema resource and a query tool for safe data retrieval.-