MCP Catalogs
← Home

mcp-server-mariadb

by abel9851·★ 20·Score 34

MCP server for read-only access to MariaDB databases through query tools and schema resources.

databasedeveloper-toolsai-llm
7
Forks
6
Open issues
14 mo ago
Last commit
2d ago
Indexed

Overview

mcp-server-mariadb is a Python-based MCP implementation that provides secure read-only access to MariaDB databases. It exposes database schemas as resources and offers a query tool to execute read-only SQL operations. The server maintains security by strictly limiting access to read-only operations, preventing accidental data modifications. The implementation uses the uv package manager and requires MariaDB Connector/C as a dependency for proper functioning.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

you:Data analysis and reporting by allowing AI assistants to query existing databases
you:Database schema exploration and documentation through MCP resources
you:Creating data-driven applications with AI systems that need to read from existing databases
you:What permissions does this server have?
you:Can I use this with other MCP clients besides Claude Desktop?

When to choose this

Choose this when you need AI access to existing MariaDB databases but only require read-only permissions.

When NOT to choose this

Avoid if you need write access to your database or require support for database systems other than MariaDB.

Tools this server exposes

1 tool extracted from the README
  • query_database

    Execute read-only operations against MariDB

Comparable tools

mcp-server-postgresmcp-server-mysqlpostgres-mcpmysql-mcp

Installation

Installation

  1. Install MariaDB Connector/C:

``bash brew install mariadb-connector-c echo 'export PATH="/opt/homebrew/opt/mariadb-connector-c/bin:$PATH"' >> ~/.bashrc export MARIADB_CONFIG=$(brew --prefix mariadb-connector-c)/bin/mariadb_config ``

  1. Install the MCP server:

``bash uv add mariadb ``

Claude Desktop Configuration

Add to your 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}"
            ]
        }
    }
}

FAQ

What permissions does this server have?
The server provides only read-only access to MariaDB databases. It cannot execute write operations, insert, update, or delete data.
Can I use this with other MCP clients besides Claude Desktop?
Yes, this server implements the MCP protocol and should be compatible with any MCP client that supports tool calling and resources.

Compare mcp-server-mariadb with

mcp-server-mariadb vs ultimate_mcp_servermcp-server-mariadb vs mcp-server-chartmcp-server-mariadb vs everythingmcp-server-mariadb vs filesystemmcp-server-mariadb vs time
GitHub →

Last updated · Auto-generated from public README + GitHub signals.