MariaDB
Enables AI assistants to securely interact with MariaDB and MySQL databases using granular per-connection read/write permissions and transaction support. It allows users to manage multiple database connections, explore schemas, and execute controlled
What is MariaDB?
MariaDB is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables ai assistants to securely interact with mariadb and mysql databases using granular per-connection read/write permissions and transaction support. it allows users to manage multiple database co...
Enables AI assistants to securely interact with MariaDB and MySQL databases using granular per-connection read/write permissions and transaction support. It allows users to manage multiple database connections, explore schemas, and execute controlled
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables AI assistants to securely interact with MariaDB and
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx mariadb-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use MariaDB
The MariaDB MCP Server enables AI assistants to securely query and manage MariaDB and MySQL databases, with granular per-connection read/write permission controls and full transaction support. It exposes a query_database tool for executing SQL and provides schema exploration resources, allowing AI clients to inspect tables and relationships before running operations. Database administrators and developers use it to give Claude or other MCP clients controlled access to relational databases without exposing raw credentials through uncontrolled channels.
Prerequisites
- Python 3.10 or later with uv package manager installed
- A running MariaDB or MySQL server (local or remote)
- The mariadb-connector-c library installed on your system
- Database credentials: host, port, username, password, and database name
- An MCP client such as Claude Desktop or Claude Code
Install the MariaDB connector library
The Python mariadb package requires the native mariadb-connector-c library. Install it using your system package manager before installing the Python dependencies.
# macOS
brew install mariadb-connector-c
export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config
# Ubuntu/Debian
sudo apt-get install libmariadb-devClone the repository
Clone the mcp-server-mariadb source code and navigate into the project directory.
git clone https://github.com/abel9851/mcp-server-mariadb.git
cd mcp-server-mariadbInstall Python dependencies with uv
Use uv to install the project dependencies, including the mariadb Python connector.
uv add mariadb
# or install all dependencies:
uv syncConfigure environment variables
Set the required database connection environment variables. These can be placed in your MCP client config or exported in your shell.
export MARIADB_HOST=127.0.0.1
export MARIADB_USER=your_db_user
export MARIADB_PASSWORD=your_db_password
export MARIADB_DATABASE=your_database_name
export MARIADB_PORT=3306Add the server to your MCP client configuration
Open your claude_desktop_config.json and add the mariadb server entry, pointing to the uv binary and the server.py script with all connection details in the env block.
MariaDB Examples
Client configuration
Complete claude_desktop_config.json entry for the MariaDB MCP server. Replace the command path with the output of 'which uv' and the source path with where you cloned the repository.
{
"mcpServers": {
"mcp_server_mariadb": {
"command": "/usr/local/bin/uv",
"args": [
"--directory",
"/path/to/mcp-server-mariadb/src/mcp_server_mariadb",
"run",
"server.py"
],
"env": {
"MARIADB_HOST": "127.0.0.1",
"MARIADB_USER": "your_db_user",
"MARIADB_PASSWORD": "your_db_password",
"MARIADB_DATABASE": "your_database_name",
"MARIADB_PORT": "3306"
}
}
}
}Prompts to try
Use these prompts in Claude Desktop once connected to your MariaDB database.
- "Show me all tables in the database and their row counts."
- "Run a query to find all users who registered in the last 7 days."
- "Describe the schema of the orders table — what columns does it have?"
- "How many records are in each table? Give me a summary."
- "Find any orders with a status of 'pending' that are older than 48 hours."Troubleshooting MariaDB
Import error for the mariadb Python module at startup
The mariadb Python package requires the native mariadb-connector-c library. On macOS, set the MARIADB_CONFIG environment variable to the path of the mariadb_config binary before running uv add mariadb. On Linux, install libmariadb-dev via apt-get.
Connection refused or authentication failed errors
Verify that MARIADB_HOST, MARIADB_USER, MARIADB_PASSWORD, and MARIADB_PORT are all set correctly in the env block of your MCP config. Confirm the database user has CONNECT privileges on the specified database from the connecting host.
The uv command is not found when Claude Desktop tries to start the server
Use the full absolute path to the uv binary in the command field of your MCP config. Find it by running 'which uv' in your terminal and replacing the placeholder /PATH/TO/uv with the actual path.
Frequently Asked Questions about MariaDB
What is MariaDB?
MariaDB is a Model Context Protocol (MCP) server that enables ai assistants to securely interact with mariadb and mysql databases using granular per-connection read/write permissions and transaction support. it allows users to manage multiple database connections, explore schemas, and execute controlled It connects AI assistants to external tools and data sources through a standardized interface.
How do I install MariaDB?
Follow the installation instructions on the MariaDB GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with MariaDB?
MariaDB works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is MariaDB free to use?
Yes, MariaDB is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
MariaDB Alternatives — Similar Databases Servers
Looking for alternatives to MariaDB? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up MariaDB in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use MariaDB?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.