MariaDB

Provides read-only MariaDB database access through MCP, including listing databases/tables, inspecting schemas, and executing safe queries.

python

GitHub Stars

python

Language

4 months ago

First Indexed

3 weeks ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "yawlhead91-mariadb-mcp": {
      "command": "uv",
      "args": [
        "run",
        "python",
        "src/mariadb_mcp/server.py"
      ],
      "env": {
        "LOG_LEVEL": "INFO",
        "MARIADB_HOST": "localhost",
        "MARIADB_PORT": "3306",
        "MARIADB_USER": "root",
        "MARIADB_DATABASE": "mysql",
        "MARIADB_PASSWORD": "YOUR_PASSWORD"
      }
    }
  }
}

You run a MariaDB MCP server to perform read-only database operations through an MCP client. It exposes tools to list databases and tables, inspect schemas, and execute safe read-only queries, making it easy to explore and analyze MariaDB data without direct SQL client access.

How to use

You connect to the MariaDB MCP server from an MCP client to perform tasks such as listing databases, listing tables, viewing table schemas, and running read-only SQL queries. The server is designed for safe access, ensuring that only non-modifying operations are allowed and that detailed results are returned for your queries.

How to install

Prerequisites you need before starting include a Python 3.10+ runtime, a MariaDB server that you can connect to, and the uv package manager.

Step by step setup you can follow now:

# Clone or download the repository
cd mariadb-mcp

# Install dependencies
uv sync

# Configure database connection
cp .env.example .env
# Edit .env with your MariaDB credentials

Additional setup and runtime

To start the MCP server locally and connect from an MCP client, run the server with the following command and then point your client to the running process.

uv run python src/mariadb_mcp/server.py

Available tools

reload_config

Reload database configuration without restarting the server.

list_databases

List all databases you have access to.

list_tables

List tables in a specified database.

get_table_schema

Get detailed schema information for a specific table.

execute_sql

Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).

Built by

VeilStrat

AI signals for GTM teams