What is Mariadb Mcp Server

mariadb-mcp-server is an MCP server that provides access to MariaDB or MySQL databases, enabling users to interact with their databases securely and efficiently.

Use cases

Use cases include listing databases and tables, describing table schemas, and executing SQL queries in a secure environment without allowing data modifications.

How to use

To use mariadb-mcp-server, install it via NPM or build it from source. Configure the required environment variables for database connection and add the server configuration to your MCP settings file.

Key features

Key features include read-only access by default, query validation to prevent SQL injection, query timeout to manage resource consumption, and row limit to control data return.

Where to use

mariadb-mcp-server can be used in various fields including web development, data analysis, and any application that requires secure access to MariaDB or MySQL databases.

MariaDB / MySQL Database Access MCP Server

MCP is certified by MCP Review
https://mcpreview.com/mcp-servers/rjsalgado/mariadb-mcp-server

This MCP server provides access to MariaDB / MySQL databases.

It allows you to:

• List available databases
• List tables in a database
• Describe table schemas
• Execute SQL queries

Security Features

• Read-only access Default: SELECT, SHOW, DESCRIBE, and EXPLAIN
• Query validation: Prevents SQL injection and blocks any data modification attempts
• Query timeout: Prevents long-running queries from consuming resources
• Row limit: Prevents excessive data return

Installation

Option 1: Install from NPM (Recommended)

# Install globally
npm install -g mariadb-mcp-server

# Or install locally in your project
npm install mariadb-mcp-server

Option 2: Build from Source

# Clone the repository
git clone https://github.com/rjsalgado/mariadb-mcp-server.git
cd mariadb-mcp-server

# Install dependencies and build
npm install
npm run build

2. Configure environment variables

The server requires the following environment variables:

• MARIADB_HOST: Database server hostname
• MARIADB_PORT: Database server port (default: 3306)
• MARIADB_USER: Database username
• MARIADB_PASSWORD: Database password
• MARIADB_DATABASE: Default database name (optional)
• MARIADB_ALLOW_INSERT: false
• MARIADB_ALLOW_UPDATE: false
• MARIADB_ALLOW_DELETE: false
• MARIADB_TIMEOUT_MS: 10000
• MARIADB_ROW_LIMIT: 1000

3. Add to MCP settings

Add the following configuration to your MCP settings file:

If you installed via npm (Option 1):

If you built from source (Option 2):

Available Tools

“server_name”: “mariadb” or “server_name”: “mysql”

list_databases

Lists all accessible databases on the MariaDB / MySQL server.
Parameters: None

Example:

{
  "server_name": "mariadb",
  "tool_name": "list_databases",
  "arguments": {}
}

list_tables

Lists all tables in a specified database.

Parameters:

• database (optional): Database name (uses default if not specified)

Example:

{
  "server_name": "mariadb",
  "tool_name": "list_tables",
  "arguments": {
    "database": "my_database"
  }
}

describe_table

Shows the schema for a specific table.

Parameters:

• database (optional): Database name (uses default if not specified)
• table (required): Table name

Example:

{
  "server_name": "mariadb",
  "tool_name": "describe_table",
  "arguments": {
    "database": "my_database",
    "table": "my_table"
  }
}

execute_query

Executes a SQL query.

Parameters:

• query (required): SQL query
• database (optional): Database name (uses default if not specified)

Example:

{
  "server_name": "mariadb",
  "tool_name": "execute_query",
  "arguments": {
    "database": "my_database",
    "query": "SELECT * FROM my_table LIMIT 10"
  }
}

Testing

The server includes test scripts to verify functionality with your MariaDB / MySQL setup:

1. Setup Test Database

This script creates a test database, table, and sample data:

# Set your MariaDB / MySQL credentials as environment variables
export MARIADB_HOST=localhost
export MARIADB_PORT=3306
export MARIADB_USER=your_username
export MARIADB_PASSWORD=your_password
export MARIADB_ALLOW_INSERT: false
export MARIADB_ALLOW_UPDATE: false
export MARIADB_ALLOW_DELETE: false
export MARIADB_TIMEOUT_MS=10000
export MARIADB_ROW_LIMIT=1000


# Run the setup script
npm run test:setup

2. Test MCP Tools

This script tests each of the MCP tools against the test database:

####
# Set your MariaDB / MySQL credentials as environment variables
MARIADB_HOST=localhost
MARIADB_PORT=3306
MARIADB_USER=your_username
MARIADB_PASSWORD=your_password
MARIADB_DATABASE=mcp_test_db
MARIADB_ALLOW_INSERT=false
MARIADB_ALLOW_UPDATE=false
MARIADB_ALLOW_DELETE=false
MARIADB_TIMEOUT_MS=10000
MARIADB_ROW_LIMIT=1000
MARIADB_DEBUG_SQL=true
####
export MARIADB_HOST=localhost
export MARIADB_PORT=3306
export MARIADB_USER=your_username
export MARIADB_PASSWORD=your_password
export MARIADB_DATABASE=mcp_test_db
export MARIADB_ALLOW_INSERT: false
export MARIADB_ALLOW_UPDATE: false
export MARIADB_ALLOW_DELETE: false
export MARIADB_TIMEOUT_MS=10000
export MARIADB_ROW_LIMIT=1000


# Run the tools test script
npm run test:tools

3. Run All Tests

To run both setup and tool tests:

# Set your MariaDB / MySQL credentials as environment variables
export MARIADB_HOST=localhost
export MARIADB_PORT=3306
export MARIADB_USER=your_username
export MARIADB_PASSWORD=your_password
export MARIADB_ALLOW_INSERT: false
export MARIADB_ALLOW_UPDATE: false
export MARIADB_ALLOW_DELETE: false
export MARIADB_TIMEOUT_MS=10000
export MARIADB_ROW_LIMIT=1000

# Run all tests
npm test

Troubleshooting

If you encounter issues:

1. Check the server logs for error messages
2. Verify your MariaDB/MySQL credentials and connection details
3. Ensure your MariaDB/MySQL user has appropriate permissions
4. Check that your query is read-only and properly formatted

Inspiration
https://github.com/dpflucas/mysql-mcp-server

License

This project is licensed under the MIT License - see the LICENSE file for details.