bretoreta_mariadb-mcp-server
If you are the rightful owner of bretoreta_mariadb-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This MCP server provides access to MariaDB / MySQL databases.
The MariaDB / MySQL Database Access MCP Server is designed to facilitate secure and efficient access to MariaDB and MySQL databases. It offers functionalities such as listing available databases, listing tables within a database, describing table schemas, and executing SQL queries. The server is equipped with security features to ensure read-only access by default, validate queries to prevent SQL injection, enforce query timeouts, and limit the number of rows returned to prevent excessive data retrieval. The server can be installed by building from source and requires specific environment variables for configuration. It integrates with MCP settings to enable seamless database interactions.
Features
- Read-only access by default: Ensures only SELECT, SHOW, DESCRIBE, and EXPLAIN commands are allowed.
- Query validation: Protects against SQL injection and blocks data modification attempts.
- Query timeout: Limits the duration of queries to prevent resource exhaustion.
- Row limit: Restricts the amount of data returned to prevent excessive data retrieval.
Tools
list_databases
Lists all accessible databases on the MariaDB / MySQL server.
list_tables
Lists all tables in a specified database.
describe_table
Shows the schema for a specific table.
execute_query
Executes a SQL query.
