mcp_server_mariadb_reader

This MariaDB Reader MCP Server provides tools to explore and interact with a MariaDB database via a conversational AI agent. The available tools include list_databases to fetch all accessible databases, list_tables to retrieve all tables within a specified database, get_table_schema to view the column definitions of a table, and query_table to read data from a table (defaulting to the first 100 rows). Use these tools by calling the corresponding command names through your MCP client (for example, a VS Code MCP extension) and supplying the required inputs like database and table names. The tools are designed to be straightforward: list_databases returns a list of databases, list_tables requires the database name, get_table_schema requires database and table names, and query_table takes database, table, and an optional limit to control how many rows are returned. Configure the MCP with the MariaDB connection details so the agent can query the actual database behind the scenes.

Prerequisites:

• Node.js (and npm) installed on your machine
• Git installed
• Access to a MariaDB instance and the credentials to connect

Installation steps:

1. Clone the repository:

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

2. Navigate to the project directory:

cd mcp_server_mariadb_reader

3. Since the repository includes prebuilt executables (build/index.js), you can start using it without a build step. If you want to development-build from source, install dependencies and build:

npm install
npm run build

4. Update MCP settings to point to your local clone path and provide the MariaDB connection details in the env section, then start the server via your MCP client configuration. The example config in the README shows how to reference the build/index.js file and set the required environment variables.

Notes:

• If you are not using the prebuilt bundle, you can build from src as shown above.
• Ensure the MariaDB credentials terminated in the MCP config match your environment to establish a connection.

Tips and common considerations:

• Environment variables MARIADB_HOST, MARIADB_PORT, MARIADB_USER, MARIADB_PASSWORD, and MARIADB_DATABASE must be set for the server to connect to MariaDB. Do not include sensitive info in logs.
• If MARIADB_DATABASE is left unset, the server may connect to the server level or require database specification per query.
• Make sure the user account has appropriate privileges to list databases, list tables, read table schemas, and query data.
• If you encounter connectivity issues, verify network access to the MariaDB host/port and confirm TLS/SSL requirements if used by your database.
• When using query_table, you can specify limit to control how many rows are returned (default is 100).
• The build/index.js path in the MCP config should reflect the actual location of the prebuilt file on your system.