MySQL Integration — ModuleX AI

Field	Description	Required	Format
Host	MySQL server hostname or IP	Yes	`localhost or mysql.example.com`
Port	MySQL server port (defaults to 3306 if omitted)	No	`3306`
Username	MySQL username for authentication	Yes	`-`
Password	MySQL password for authentication	Yes	`-`
Database	The database name to connect to	Yes	`-`
SSL Mode	SSL mode: ‘disabled’, ‘verify’ (default), or ‘skip_verification’	No	`verify	skip_verification	disabled`

execute_raw_query — Execute any SQL statement. Use '%s' for parameterized queries (DB-API style).

Parameters

string

required

The SQL to execute

array

Values for ‘%s’ placeholders

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "row_count": {
      "default": 0,
      "title": "Row Count",
      "type": "integer"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteRawQueryOutput",
  "type": "object"
}

create_row — INSERT a new row (returns affected_rows + last_insert_id)

Parameters

string

required

The table name

object

required

Column-value pairs to insert

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "affected_rows": {
      "default": 0,
      "title": "Affected Rows",
      "type": "integer"
    },
    "last_insert_id": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Last Insert Id"
    },
    "columns": {
      "items": {
        "type": "string"
      },
      "title": "Columns",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "CreateRowOutput",
  "type": "object"
}

delete_row — DELETE rows matching a WHERE condition

Parameters

string

required

The table name

string

required

WHERE condition with ’?’ placeholders

array

required

Values matching the ’?’ placeholders

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "affected_rows": {
      "default": 0,
      "title": "Affected Rows",
      "type": "integer"
    }
  },
  "required": [
    "success"
  ],
  "title": "DeleteRowOutput",
  "type": "object"
}

update_row — UPDATE rows matching a WHERE condition

Parameters

string

required

The table name

object

required

Column-value pairs to update

string

required

WHERE condition with ’?’ placeholders

array

required

Values matching the ’?’ placeholders

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "affected_rows": {
      "default": 0,
      "title": "Affected Rows",
      "type": "integer"
    },
    "updated_columns": {
      "items": {
        "type": "string"
      },
      "title": "Updated Columns",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "UpdateRowOutput",
  "type": "object"
}

find_row — SELECT * FROM table WHERE column <op> value

Parameters

string

required

The table name

string

required

Column to filter by

string

=, >, >=, <, !=, <=, LIKE (Default: =)

string

Value to compare against

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "row_count": {
      "default": 0,
      "title": "Row Count",
      "type": "integer"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "FindRowOutput",
  "type": "object"
}

execute_query_with_condition — SELECT * FROM table WHERE <condition>

Parameters

string

required

The table name

string

required

WHERE condition with ’?’ placeholders

array

required

Values matching the ’?’ placeholders

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "row_count": {
      "default": 0,
      "title": "Row Count",
      "type": "integer"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteQueryWithConditionOutput",
  "type": "object"
}

execute_stored_procedure — CALL <stored_procedure>(...) with optional parameters

Parameters

string

required

Procedure name (may be qualified ‘db.proc’)

array

Procedure parameters

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "procedure": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Procedure"
    },
    "row_count": {
      "default": 0,
      "title": "Row Count",
      "type": "integer"
    },
    "data": {
      "anyOf": [
        {
          "items": {
            "additionalProperties": true,
            "type": "object"
          },
          "type": "array"
        },
        {
          "additionalProperties": true,
          "type": "object"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Data"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteStoredProcedureOutput",
  "type": "object"
}

list_tables — List all tables and views in the current database

Response

{
  "$defs": {
    "TableEntry": {
      "additionalProperties": false,
      "properties": {
        "name": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Name"
        },
        "type": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Type"
        }
      },
      "title": "TableEntry",
      "type": "object"
    }
  },
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "database": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Database"
    },
    "tables": {
      "items": {
        "$ref": "#/$defs/TableEntry"
      },
      "title": "Tables",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListTablesOutput",
  "type": "object"
}

describe_table — Return column metadata for a table (SHOW COLUMNS)

Parameters

string

required

The table name

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "columns": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Columns",
      "type": "array"
    },
    "column_count": {
      "default": 0,
      "title": "Column Count",
      "type": "integer"
    }
  },
  "required": [
    "success"
  ],
  "title": "DescribeTableOutput",
  "type": "object"
}

Using

Providers

Building

Tools

MySQL Integration for AI Agents & Workflows

Overview

Authentication

MySQL Database Credentials

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Response

Parameters

Response

Limits & Quotas

PostgreSQL

Snowflake

Supabase

Links

​Overview

​Authentication

​MySQL Database Credentials

​Required Credentials

​Available Actions

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Response

​Parameters

​Response

​Limits & Quotas

​Related integrations

PostgreSQL

Snowflake

Supabase

​Links

Overview

Authentication

MySQL Database Credentials

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Response

Parameters

Response

Limits & Quotas

Related integrations

Links