mysql

Server path: /mysql | Type: Application | PCID required: Yes MySQL database queries and schema management

Tools

Tool	Description
`mysql_get_info`	Get MySQL database connection information
`mysql_list_databases`	List all databases on the MySQL server
`mysql_execute_query`	Execute a SQL query on MySQL. Use ? placeholders for parameterized queries (e.g., “SELECT * FROM users WHERE id = ? AND status = ?”). Parameters are applied in order.
`mysql_select_data`	Select data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization.
`mysql_insert_data`	Insert data into a MySQL table
`mysql_update_data`	Update data in a MySQL table. Use ? placeholders in where with whereParams for safe parameterization.
`mysql_delete_data`	Delete data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization.
`mysql_describe_table`	Get table structure and column information
`mysql_list_tables`	List all tables in the database
`mysql_create_table`	Create a new table in MySQL

mysql_get_info

Get MySQL database connection information

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

mysql_list_databases

List all databases on the MySQL server

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

mysql_execute_query

Execute a SQL query on MySQL. Use ? placeholders for parameterized queries (e.g., “SELECT * FROM users WHERE id = ? AND status = ?”). Parameters are applied in order. Parameters:

Parameter	Type	Required	Default	Description
`query`	string	Yes	—	The SQL query to execute. Use ? as placeholders for parameters (e.g., “SELECT * FROM users WHERE id = ?”)
`parameters`	string[]	No	—	Array of parameter values to substitute for ? placeholders in order

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "query": {
      "type": "string",
      "description": "The SQL query to execute. Use ? as placeholders for parameters (e.g., \"SELECT * FROM users WHERE id = ?\")"
    },
    "parameters": {
      "type": "array",
      "items": {
        "oneOf": [
          {
            "type": "string"
          },
          {
            "type": "number"
          },
          {
            "type": "boolean"
          },
          {
            "type": "null"
          }
        ]
      },
      "description": "Array of parameter values to substitute for ? placeholders in order"
    }
  },
  "required": [
    "PCID",
    "query"
  ]
}

mysql_select_data

Select data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. Parameters:

Parameter	Type	Required	Default	Description
`table`	string	Yes	—	Table name
`columns`	string[]	No	—	Columns to select (defaults to all)
`where`	string	No	—	WHERE clause conditions (use ? for parameterized values)
`whereParams`	string[]	No	—	Parameters for WHERE clause ? placeholders
`orderBy`	string	No	—	ORDER BY clause
`limit`	number	No	—	LIMIT number of results
`offset`	number	No	—	OFFSET for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Columns to select (defaults to all)"
    },
    "where": {
      "type": "string",
      "description": "WHERE clause conditions (use ? for parameterized values)"
    },
    "whereParams": {
      "type": "array",
      "items": {
        "oneOf": [
          {
            "type": "string"
          },
          {
            "type": "number"
          },
          {
            "type": "boolean"
          },
          {
            "type": "null"
          }
        ]
      },
      "description": "Parameters for WHERE clause ? placeholders"
    },
    "orderBy": {
      "type": "string",
      "description": "ORDER BY clause"
    },
    "limit": {
      "type": "number",
      "description": "LIMIT number of results"
    },
    "offset": {
      "type": "number",
      "description": "OFFSET for pagination"
    }
  },
  "required": [
    "PCID",
    "table"
  ]
}

mysql_insert_data

Insert data into a MySQL table Parameters:

Parameter	Type	Required	Default	Description
`table`	string	Yes	—	Table name
`data`	object	Yes	—	Data to insert as key-value pairs (supports nested objects and arrays for JSON columns)
`onDuplicateUpdate`	boolean	No	`false`	Use ON DUPLICATE KEY UPDATE

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "data": {
      "type": "object",
      "additionalProperties": true,
      "description": "Data to insert as key-value pairs (supports nested objects and arrays for JSON columns)"
    },
    "onDuplicateUpdate": {
      "type": "boolean",
      "default": false,
      "description": "Use ON DUPLICATE KEY UPDATE"
    }
  },
  "required": [
    "PCID",
    "table",
    "data"
  ]
}

mysql_update_data

Update data in a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. Parameters:

Parameter	Type	Required	Default	Description
`table`	string	Yes	—	Table name
`data`	object	Yes	—	Data to update as key-value pairs (supports nested objects and arrays for JSON columns)
`where`	string	Yes	—	WHERE clause to identify rows to update (use ? for parameterized values)
`whereParams`	string[]	No	—	Parameters for WHERE clause ? placeholders

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "data": {
      "type": "object",
      "additionalProperties": true,
      "description": "Data to update as key-value pairs (supports nested objects and arrays for JSON columns)"
    },
    "where": {
      "type": "string",
      "description": "WHERE clause to identify rows to update (use ? for parameterized values)"
    },
    "whereParams": {
      "type": "array",
      "items": {
        "oneOf": [
          {
            "type": "string"
          },
          {
            "type": "number"
          },
          {
            "type": "boolean"
          },
          {
            "type": "null"
          }
        ]
      },
      "description": "Parameters for WHERE clause ? placeholders"
    }
  },
  "required": [
    "PCID",
    "table",
    "data",
    "where"
  ]
}

mysql_delete_data

Delete data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. Parameters:

Parameter	Type	Required	Default	Description
`table`	string	Yes	—	Table name
`where`	string	Yes	—	WHERE clause to identify rows to delete (use ? for parameterized values)
`whereParams`	string[]	No	—	Parameters for WHERE clause ? placeholders

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "where": {
      "type": "string",
      "description": "WHERE clause to identify rows to delete (use ? for parameterized values)"
    },
    "whereParams": {
      "type": "array",
      "items": {
        "oneOf": [
          {
            "type": "string"
          },
          {
            "type": "number"
          },
          {
            "type": "boolean"
          },
          {
            "type": "null"
          }
        ]
      },
      "description": "Parameters for WHERE clause ? placeholders"
    }
  },
  "required": [
    "PCID",
    "table",
    "where"
  ]
}

mysql_describe_table

Get table structure and column information Parameters:

Parameter	Type	Required	Default	Description
`table`	string	Yes	—	Table name to describe

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "table": {
      "type": "string",
      "description": "Table name to describe"
    }
  },
  "required": [
    "PCID",
    "table"
  ]
}

mysql_list_tables

List all tables in the database Parameters:

Parameter	Type	Required	Default	Description
`database`	string	No	—	Specific database name (uses default if not provided)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "database": {
      "type": "string",
      "description": "Specific database name (uses default if not provided)"
    }
  },
  "required": [
    "PCID"
  ]
}

mysql_create_table

Create a new table in MySQL Parameters:

Parameter	Type	Required	Default	Description
`tableName`	string	Yes	—	Name of the table to create
`columns`	object[]	Yes	—	Table column definitions

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "tableName": {
      "type": "string",
      "description": "Name of the table to create"
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "description": "Column name"
          },
          "type": {
            "type": "string",
            "description": "Column data type (e.g., VARCHAR(255), INT, TEXT)"
          },
          "nullable": {
            "type": "boolean",
            "default": true,
            "description": "Whether column can be NULL"
          },
          "primaryKey": {
            "type": "boolean",
            "default": false,
            "description": "Whether column is primary key"
          },
          "autoIncrement": {
            "type": "boolean",
            "default": false,
            "description": "Whether column auto-increments"
          }
        }
      },
      "description": "Table column definitions"
    }
  },
  "required": [
    "PCID",
    "tableName",
    "columns"
  ]
}

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

Tools

mysql_get_info

mysql_list_databases

mysql_execute_query

mysql_select_data

mysql_insert_data

mysql_update_data

mysql_delete_data

mysql_describe_table

mysql_list_tables

mysql_create_table

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

​Tools

​mysql_get_info

​mysql_list_databases

​mysql_execute_query

​mysql_select_data

​mysql_insert_data

​mysql_update_data

​mysql_delete_data

​mysql_describe_table

​mysql_list_tables

​mysql_create_table

Tools

mysql_get_info

mysql_list_databases

mysql_execute_query

mysql_select_data

mysql_insert_data

mysql_update_data

mysql_delete_data

mysql_describe_table

mysql_list_tables

mysql_create_table