Loading...
npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude{
"mcpServers": {
"mysql": {
"command": "npx",
"args": ["-y", "@f4ww4z/mcp-mysql-server", "mysql://user:password@localhost:port/database"],
}
}
}connect_dbEstablishes a connection to a MySQL database using provided credentials.
Only establishes a connection; no data is read or modified.
queryExecutes SELECT queries against the database.
Read-only operation; no data modification.
executeExecutes INSERT, UPDATE, or DELETE queries against the database.
Allows modification of data within the database.
list_tablesLists all tables in the connected database.
Read-only operation; retrieves metadata about the database.
describe_tableRetrieves the structure of a specific table.
Read-only operation; retrieves metadata about a specific table.
This server provides useful database interaction capabilities but requires careful configuration and monitoring. It is safe when used with appropriate access controls and query validation. It is risky if exposed to untrusted AI models or if database credentials are not securely managed.