Documentation Index Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
Use this file to discover all available pages before exploring further.
Server path: /mysql | Type: Application | PCID required: YesTool Description mysql_get_infoGet MySQL database connection information mysql_list_databasesList all databases on the MySQL server mysql_execute_queryExecute 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_dataSelect data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. mysql_insert_dataInsert data into a MySQL table mysql_update_dataUpdate data in a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. mysql_delete_dataDelete data from a MySQL table. Use ? placeholders in where with whereParams for safe parameterization. mysql_describe_tableGet table structure and column information mysql_list_tablesList all tables in the database mysql_create_tableCreate a new table in MySQL
mysql_get_info Get MySQL database connection information
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" } }, "required" : [ "PCID" ] }
mysql_list_databases List all databases on the MySQL server
{ "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 querystring Yes — The SQL query to execute. Use ? as placeholders for parameters (e.g., “SELECT * FROM users WHERE id = ?”) parametersstring[] No — Array of parameter values to substitute for ? placeholders in order
{ "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 tablestring Yes — Table name columnsstring[] No — Columns to select (defaults to all) wherestring No — WHERE clause conditions (use ? for parameterized values) whereParamsstring[] No — Parameters for WHERE clause ? placeholders orderBystring No — ORDER BY clause limitnumber No — LIMIT number of results offsetnumber No — OFFSET for pagination
{ "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 tablestring Yes — Table name dataobject Yes — Data to insert as key-value pairs (supports nested objects and arrays for JSON columns) onDuplicateUpdateboolean No falseUse ON DUPLICATE KEY UPDATE
{ "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 tablestring Yes — Table name dataobject Yes — Data to update as key-value pairs (supports nested objects and arrays for JSON columns) wherestring Yes — WHERE clause to identify rows to update (use ? for parameterized values) whereParamsstring[] No — Parameters for WHERE clause ? placeholders
{ "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 tablestring Yes — Table name wherestring Yes — WHERE clause to identify rows to delete (use ? for parameterized values) whereParamsstring[] No — Parameters for WHERE clause ? placeholders
{ "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 tablestring Yes — Table name to describe
{ "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 databasestring No — Specific database name (uses default if not provided)
{ "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 tableNamestring Yes — Name of the table to create columnsobject[] Yes — Table column definitions
{ "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" ] }
