MariaDB Reader MCP Server

This project is a Model Context Protocol (MCP) server for exploring and interacting with MariaDB databases. It provides tools for AI assistants like Cline to access and query MariaDB databases.

function

This MCP server provides the following tools:

• list_databases : Returns a list of all accessible databases.

• list_tables : Returns a list of all tables in the specified database.

  • Input: database (string, required) - The name of the database for which to retrieve a list of tables.

• get_table_schema : Returns the schema (column definition) of the specified table.

  • input:

    • database (string, required) - The name of the database to which the table belongs.

    • table (string, required) - The name of the table to query the schema for.

• query_table : Retrieves data from a specified table. By default, it returns the first 100 rows.

  • input:

    • database (string, required) - The name of the database to which the table belongs.

    • table (string, required) - The name of the table from which to retrieve data.

    • limit (number, optional) - The maximum number of rows to return (default: 100).

Related MCP server: MCP MariaDB Server

setting

To use this server, you need to clone the GitHub repository and register the server information in the configuration file of your MCP client (e.g. the VS Code extension). This repository includes a pre-built executable ( build/index.js ), so no separate build step is required.

1. Clone repository: Clone this repository to a location of your choice.

   git clone https://github.com/moosin76/mcp_server_mariadb_reader.git

2. Modify the MCP settings file:

Example settings:

{
  "mcpServers": {
    "mcp_server_mariadb_reader": {
      "command": "node",
      "args": ["<클론된 저장소 경로>/build/index.js"], // 클론된 저장소 내 build/index.js 파일 경로
      "env": {
        "MARIADB_HOST": "YOUR_DB_HOST",         // MariaDB 호스트 주소
        "MARIADB_PORT": "YOUR_DB_PORT",         // MariaDB 포트 번호 (예: "3306")
        "MARIADB_USER": "YOUR_DB_USER",         // MariaDB 사용자 이름
        "MARIADB_PASSWORD": "YOUR_DB_PASSWORD", // MariaDB 비밀번호
        "MARIADB_DATABASE": "YOUR_DEFAULT_DB"   // (선택) 기본 데이터베이스 이름
      },
      "disabled": false,
      "autoApprove": []
    }
    // 다른 MCP 서버 설정...
  }
}

caution:

• You need to change <클론된 저장소 경로> part to the local path where you cloned the actual repository (e.g. C:/Users/YourUser/Documents/GitHub/mcp_server_mariadb_reader ).

• You will need to modify the MariaDB connection information in env object to match your actual environment.

Development (when modifying source code)

This repository contains the built files, so you don't need to follow the steps below to use the server. If you want to modify the source code ( src directory ) directly and apply the changes, follow these steps:

1. Installing dependencies (first time or when changing package.json ):

   npm install

2. Build after fix:

   npm run build

   • This command compiles TypeScript code in the src directory into JavaScript code in build directory.

3. (Optional) Detect changes during development and build automatically:

   npm run watch

License

This project is distributed under the [Enter License Information] license.