Can I use Mysql as a CLI?

Yes. KosmoKrator exposes a Mysql CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose Mysql through MCP?

Yes. The KosmoKrator MCP gateway can expose selected Mysql tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are Mysql credentials stored?

Mysql credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for Mysql MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

other

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.

8 functions 5 read 3 write API key auth

Submit Mysql feedback View package source

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.

Machine-Readable Metadata

integration_slug: mysql
route_slug: mysql
package: mysql
auth_strategy: api_key API key
cli_setup_supported: true
cli_runtime_supported: true
mcp_gateway_supported: true
lua_supported: true
supports_multi_account: true

Quick Links

Lua APIAgent-facing namespace and function reference. Mysql CLIHeadless setup and direct function calls. Mysql MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.

Mysql MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Mysql.

Claude Code Mysql MCP setup for Claude Code. Cursor Mysql MCP setup for Cursor. Codex Mysql MCP setup for Codex. OpenAI Agents Mysql MCP setup for OpenAI Agents SDK. Claude Agent SDK Mysql MCP setup for Claude Agent SDK. Vercel AI SDK Mysql MCP setup for Vercel AI SDK. LangChain Mysql MCP setup for LangChain. LangGraph Mysql MCP setup for LangGraph. CrewAI Mysql MCP setup for CrewAI. MCP clients Mysql MCP setup for Generic MCP Clients.

Mysql CLI Matrix

Use these pages for direct Mysql CLI workflows in scripts, CI, cron, and agent wrappers.

CI Mysql CLI for CI. Cron Jobs Mysql CLI for cron jobs. Shell Scripts Mysql CLI for shell scripts. Headless Automation Mysql CLI for headless automation. Coding Agents Mysql CLI for coding agents.

Function Catalog

Function	Type	Parameters	Description
`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.