Happy slice of mcp pizzaMCP.pizza

mcp

MCP.Pizza Chef: MariaDB

Published by MariaDB itself, this connector works with Claude Desktop, Cursor, VS Code, and Windsurf. It can list your databases and tables, show how they are laid out and related, and run read-only lookups, with read-only left on by default so nothing changes by accident. An optional extra, switched on with a key from OpenAI, Gemini, or Hugging Face, stores text and finds entries by meaning rather than exact wording. You supply a running MariaDB server and its login details.

Coding
Data

Use This MCP server To

Ask which tables exist and what is stored in them Pull a count or summary without writing any SQL Check how two tables are connected before planning a change Search saved documents by meaning instead of exact words Keep the assistant read-only so nothing gets changed

README

MCP MariaDB Server

The MCP MariaDB Server provides a Model Context Protocol (MCP) interface for managing and querying MariaDB databases, supporting both standard SQL operations and advanced vector/embedding-based search. Designed for use with AI assistants, it enables seamless integration of AI-driven data workflows with relational and vector databases.

Table of Contents

Overview

The MCP MariaDB Server exposes a set of tools for interacting with MariaDB databases and vector stores via a standardized protocol. It supports:

  • Listing databases and tables
  • Retrieving table schemas
  • Executing safe, read-only SQL queries
  • Creating and managing vector stores for embedding-based search
  • Integrating with embedding providers (currently OpenAI, Gemini, and HuggingFace) (optional)

Core Components

  • server.py: Main MCP server logic and tool definitions.
  • config.py: Loads configuration from environment and .env files.
  • embeddings.py: Handles embedding service integration (OpenAI).
  • tests/: Manual and automated test documentation and scripts.

Available Tools

Standard Database Tools

mcp FAQ

Can I use this to answer questions about my data?
Yes — ask in plain language and it runs read-only lookups against your MariaDB database.
Which apps does it work in?
Claude Desktop, Cursor, VS Code, and Windsurf are documented.
Can it change or delete my data?
Not by default. Read-only mode is on unless you deliberately turn it off.
Do I need a key from anyone?
You need your database login. A key from OpenAI, Gemini, or Hugging Face is only needed for the optional meaning-based search.
How hard is setup?
You need Python, a package manager, and a running MariaDB server, so it suits someone comfortable with developer tools.
Is this an official project?
Yes, it is published by MariaDB.
Can I connect safely to a database on another server?
Yes — there are settings for encrypted connections and certificate checks.