MariaDB MCP Server

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 to enable seamless integration of AI-driven data workflows with relational and vector databases.

Features

• Standard Database Operations: List databases and tables, retrieve schemas with foreign key relations, execute read-only SQL queries
• Vector Store & Embeddings (optional): Create and manage vector stores for embedding-based semantic search
• Multiple Embedding Providers: OpenAI, Gemini, and HuggingFace models
• Flexible Transport: Supports stdio, SSE, and HTTP transports
• Security: Read-only mode enforcement, SSL/TLS support, configurable authentication
• Connection Pooling: Configurable connection pool size for performance

Available Tools

Standard Database Tools

• list_databases: Lists all accessible databases
• list_tables: Lists all tables in a specified database
• get_table_schema: Retrieves schema for a table (columns, types, keys)
• get_table_schema_with_relations: Retrieves schema with foreign key relations
• execute_sql: Executes read-only SQL queries (SELECT, SHOW, DESCRIBE)
• create_database: Creates a new database if it doesn't exist

Vector Store & Embedding Tools

These tools are only available when EMBEDDING_PROVIDER is configured:

• create_vector_store: Creates a new vector store table for embeddings with configurable distance functions
• delete_vector_store: Deletes a vector store table
• list_vector_stores: Lists all vector stores in a database
• insert_docs_vector_store: Batch inserts documents and optional metadata into a vector store
• search_vector_store: Performs semantic search using embeddings

SSL/TLS Configuration

Supports secure connections with:

• CA certificate verification
• Client certificate authentication (mutual TLS)
• Hostname identity verification
• Self-signed certificate support for testing

Security Considerations

⚠️ Important: For production use, configure MariaDB user privileges appropriately. The MCP_READ_ONLY flag provides best-effort protection but is not a substitute for proper database user privileges.