API Integration
Integrate this MCP server into your applications.
Get your API Key
You'll need to login and generate a Smithery API key to connect to this server.
Installation
Install the Smithery and MCP SDKs using npm:
npm install @smithery/sdk @modelcontextprotocol/sdk
TypeScript SDK
Use Smithery's TypeScript SDK to connect to this MCP server:
typescript
import { createTransport } from "@smithery/sdk/transport.js"
const transport = createTransport("https://server.smithery.ai/@benborla29/mcp-server-mysql", {
"ssl": false,
"mysqlDb": "string",
"mysqlHost": "string",
"mysqlPass": "string",
"mysqlPort": "string",
"mysqlUser": "string",
"allowDeleteOperation": false,
"allowInsertOperation": false,
"allowUpdateOperation": false,
"rejectUnauthorizedSSL": false
}, "your-smithery-api-key")
// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
const client = new Client({
name: "Test client",
version: "1.0.0"
})
await client.connect(transport)
// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)
// Example: Call a tool
// const result = await client.callTool("tool_name", { param1: "value1" })
Configuration Schema
Full JSON Schema for server configuration:
json
{
"type": "object",
"required": [
"mysqlHost",
"mysqlPort",
"mysqlUser"
],
"properties": {
"ssl": {
"type": "boolean",
"default": false,
"description": "If set to true, the connection will use SSL."
},
"mysqlDb": {
"type": "string",
"description": "The database name to connect to. If left blank, retrieves all databases."
},
"mysqlHost": {
"type": "string",
"description": "The host address of the MySQL database."
},
"mysqlPass": {
"type": "string",
"description": "The password for the specified MySQL user."
},
"mysqlPort": {
"type": "string",
"description": "The port number for connecting to MySQL."
},
"mysqlUser": {
"type": "string",
"description": "The username for MySQL authentication."
},
"allowDeleteOperation": {
"type": "boolean",
"default": false,
"description": "If set to true, DELETE operations will be allowed."
},
"allowInsertOperation": {
"type": "boolean",
"default": false,
"description": "If set to true, INSERT operations will be allowed."
},
"allowUpdateOperation": {
"type": "boolean",
"default": false,
"description": "If set to true, UPDATE operations will be allowed."
},
"rejectUnauthorizedSSL": {
"type": "boolean",
"default": false,
"description": "If set to true, the connection will verify the SSL certificate."
}
}
}