MariaDB MCP Server

MariaDB / MySQL Database Access 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: Build from Source

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

# Install dependencies and build
pnpm install
pnpm 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 built from source:

{
  "mcpServers": {
    "mariadb": {
      "command": "node",
      "args": ["/path/to/mariadb-mcp-server/dist/index.js"],
      "env": {
        "MARIADB_HOST": "your-host",
        "MARIADB_PORT": "3306",
        "MARIADB_USER": "your-user",
        "MARIADB_PASSWORD": "your-password",
        "MARIADB_DATABASE": "your-default-database",
        "MARIADB_ALLOW_INSERT": "false",
        "MARIADB_ALLOW_UPDATE": "false",
        "MARIADB_ALLOW_DELETE": "false",
        "MARIADB_TIMEOUT_MS": "10000",
        "MARIADB_ROW_LIMIT": "1000",
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Available Tools

list_databases

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

Example:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "sessionId": "session_id from /sse call",
    "name": "list_databases"
  }
}

list_tables

Lists all tables in a specified database.

Parameters:

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

Example:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "sessionId": "session_id from /sse call",
    "name": "list_tables",
    "database": "my_database_name"
  }
}

describe_table

Shows the schema for a specific table.

Parameters:

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

Example:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "sessionId": "session_id from /sse call",
    "name": "describe_table",
    "database": "my_database_name",
    "table": "my_table_name"
  }
}

execute_query

Executes a SQL query.

Parameters:

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

Example:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "sessionId": "session_id from /sse call",
    "name": "execute_query",
    "query": "SELECT * FROM my_table LIMIT 10"
  }
}

Testing

The server automatically tests MariaDB to verify functionality with your MariaDB setup:

Troubleshooting

If you encounter issues:

Check the server logs for error messages
Verify your MariaDB credentials and connection details
Ensure your MariaDB user has appropriate permissions
Check that your query is read-only and properly formatted

Inspiration https://github.com/rjsalgado/mariadb-mcp-server

License

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

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Tools

Provides secure, read-only access to MariaDB/MySQL databases, allowing users to list databases, explore table schemas, and execute SQL queries with built-in security measures.

Related MCP Servers

MySQL MCP Server
amornpan
-
security
F
license
-
quality
Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
Last updated -
Python
MariaDB Reader MCP Server
moosin76
A
security
F
license
A
quality
Provides tools for AI assistants to explore and interact with MariaDB databases, allowing them to list databases, view tables, inspect schema definitions, and query data.
Last updated -
4
2
JavaScript
MySQL MCP Server
dave-wind
-
security
A
license
-
quality
A server that provides LLMs with read-only access to MySQL databases, allowing them to inspect database schemas and execute read-only queries.
Last updated -
33
9
JavaScript
MIT License
MySQL MCP Server
SuMiaoALi
-
security
A
license
-
quality
Provides secure access to MySQL databases for AI assistants, enabling safe SQL queries, table information retrieval, and data insertion with built-in security protections.
Last updated -
834
2
JavaScript
MIT License

View all related MCP servers

MariaDB / MySQL Database Access MCP Server

Security Features

Installation

Option 1: Build from Source

2. Configure environment variables

3. Add to MCP settings

Available Tools

list_databases

list_tables

describe_table

execute_query

Testing

Troubleshooting

License

Tools

Related MCP Servers

MySQL MCP Server

MariaDB Reader MCP Server

MySQL MCP Server

MySQL MCP Server

MCP directory API