KosmoKrator

data

Mysql MCP, CLI, and Lua Integration for AI Agents

Mysql integration docs for AI agents: MCP gateway setup, Mysql CLI commands, Lua API reference, credentials, and function schemas.

Mysql for agents

Credentials can be configured manually in web or CLI hosts.

Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.

Agent Surfaces

Mysql CLIHeadless setup, JSON output, direct function calls. Mysql MCPExpose selected tools to local MCP clients. Mysql LuaAgent-facing namespace and Lua reference. FeedbackReport missing tools, auth issues, or bad metadata.

Machine-Readable Metadata

integration_slug
mysql
route_slug
mysql
package
mysql
auth_strategy
api_key
cli_setup_supported
true
cli_runtime_supported
true
mcp_gateway_supported
true
lua_supported
true

Function Catalog

FunctionTypeParametersDescription
mysql.mysql_query Read read 1 Execute a raw SQL query on the MySQL database. Supports SELECT, INSERT, UPDATE, DELETE, and other SQL statements. Use for custom queries, joins, aggregations, and complex data retrieval.
mysql.mysql_list_databases Read read 0 List all databases accessible to the authenticated MySQL user. Use this to discover which databases are available before querying or exploring tables.
mysql.mysql_list_tables Read read 1 List all tables in a MySQL database. Use this to discover which tables exist before querying or describing their structure.
mysql.mysql_describe_table Read read 2 Get the column structure of a MySQL table. Returns column names, types, nullable status, keys, defaults, and extra info. Use this before inserting or updating data to understand the schema.
mysql.mysql_insert Write write 3 Insert a new row into a MySQL table. Provide column names and values as key-value pairs. Use mysql_describe_table first to understand the schema if needed.
mysql.mysql_update Write write 4 Update rows in a MySQL table that match a filter. Provide a filter to identify which rows to update and a data object with the new column values. Use mysql_describe_table first to understand the schema if needed.
mysql.mysql_delete Write write 3 Delete rows from a MySQL table that match a filter. Provide a filter with column-value pairs to identify which rows to delete. This action is irreversible — use with caution.
mysql.mysql_get_current_user Read read 0 Get information about the currently authenticated MySQL user. Useful for verifying credentials and connection status.