MySQL

Provider	Host example	Port	Notes
AWS RDS	`mydb.abc123.us-east-1.rds.amazonaws.com`	3306	Enable SSL, allow security group access
Google Cloud SQL	`10.0.0.3` (private IP) or via proxy	3306	Use Cloud SQL Auth Proxy for secure access
PlanetScale	`aws.connect.psdb.cloud`	3306	SSL required, use connection string from dashboard
Self-hosted	`localhost` or server IP	3306	Ensure firewall allows connections

execute-query: Execute a raw SQL query

Execute any SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and more. Supports parameterized queries with ? placeholders.

string

required

SQL query to execute.

unknown[]

Parameterized query values for ? placeholders.

Example request:

{
  "query": "SELECT id, name, email FROM users WHERE status = ? LIMIT 10",
  "params": ["active"]
}

Example response:

{
  "success": true,
  "data": {
    "rows": [
      { "id": 1, "name": "Alice", "email": "alice@example.com" },
      { "id": 2, "name": "Bob", "email": "bob@example.com" }
    ],
    "fields": [
      { "name": "id", "type": 3 },
      { "name": "name", "type": 253 },
      { "name": "email", "type": 253 }
    ]
  }
}

list-databases: List all databases

List all databases accessible with the current credentials.Example response:

{
  "success": true,
  "data": {
    "databases": ["information_schema", "myapp", "analytics"]
  }
}

list-tables: List tables in a database

string

Database name. Defaults to the connection’s database.

Example request:

{
  "database": "myapp"
}

Example response:

{
  "success": true,
  "data": {
    "tables": ["users", "orders", "products", "sessions"]
  }
}

describe-table: Get table schema

Returns column definitions and the CREATE TABLE statement for a table.

string

required

Table name.

string

Database name. Defaults to the connection’s database.

Example request:

{
  "table": "users"
}

Example response:

{
  "success": true,
  "data": {
    "columns": [
      { "Field": "id", "Type": "int", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment" },
      { "Field": "name", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "" },
      { "Field": "email", "Type": "varchar(255)", "Null": "NO", "Key": "UNI", "Default": null, "Extra": "" }
    ],
    "createStatement": "CREATE TABLE `users` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `name` varchar(255) NOT NULL,\n  `email` varchar(255) NOT NULL,\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `email` (`email`)\n) ENGINE=InnoDB"
  }
}

insert-rows: Insert rows into a table

string

required

Table name.

object[]

required

Array of row objects to insert.

string

Database name. Defaults to the connection’s database.

Example request:

{
  "table": "users",
  "rows": [
    { "name": "Alice", "email": "alice@example.com" },
    { "name": "Bob", "email": "bob@example.com" }
  ]
}

Example response:

{
  "success": true,
  "data": {
    "affectedRows": 2,
    "insertId": 42
  }
}

update-rows: Update rows matching a condition

string

required

Table name.

object

required

Column values to update.

string

required

WHERE clause. Use ? placeholders for parameterized values.

unknown[]

Values for ? placeholders in the WHERE clause.

string

Database name. Defaults to the connection’s database.

Example request:

{
  "table": "users",
  "set": { "status": "active" },
  "where": "last_login > ?",
  "params": ["2024-01-01"]
}

Example response:

{
  "success": true,
  "data": {
    "affectedRows": 15
  }
}

delete-rows: Delete rows matching a condition

string

required

Table name.

string

required

WHERE clause. Use ? placeholders for parameterized values.

unknown[]

Values for ? placeholders in the WHERE clause.

string

Database name. Defaults to the connection’s database.

Example request:

{
  "table": "sessions",
  "where": "expires_at < ?",
  "params": ["2024-01-01"]
}

Example response:

{
  "success": true,
  "data": {
    "affectedRows": 128
  }
}

Overview

Integrations

Remote MCP Servers

Databases

Data Processing

Text and Strings

Numbers and Dates

Files and Media

Encoding and Validation

Developer Tools

Connection setup

Common MySQL settings

Tools

​Connection setup

​Common MySQL settings

​Tools

Connection setup

Common MySQL settings

Tools