Create Table
Create a new table in the MySQL database
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_CREATE_TABLE])
Insert Row
Insert a new row of data into a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_INSERT_ROW])
Update Row
Update an existing row in a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_UPDATE_ROW])
Delete Row
Delete a row from a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_DELETE_ROW])
Execute Query
Execute a custom SQL query
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_EXECUTE_QUERY])
Create Database
Create a new database in MySQL
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_CREATE_DATABASE])
Drop Database
Delete an existing database in MySQL
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_DROP_DATABASE])
Alter Table
Modify the structure of an existing table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_ALTER_TABLE])
Create Index
Create an index on specified columns of a table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_CREATE_INDEX])
Drop Index
Remove an existing index from a table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_DROP_INDEX])
Backup Database
Create a backup of a specified database
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_BACKUP_DATABASE])
Restore Database
Restore a database from a backup file
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_RESTORE_DATABASE])
Grant Privileges
Grant specific privileges to a user on a database or table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_GRANT_PRIVILEGES])
Revoke Privileges
Revoke specific privileges from a user on a database or table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_REVOKE_PRIVILEGES])
Create User
Create a new MySQL user account
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_CREATE_USER])
Drop User
Delete an existing MySQL user account
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_DROP_USER])
Optimize Table
Optimize a table to reclaim unused space and improve performance
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_OPTIMIZE_TABLE])
Truncate Table
Remove all rows from a table quickly
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRUNCATE_TABLE])
Create View
Create a new view based on a SELECT statement
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_CREATE_VIEW])
Drop View
Remove an existing view from the database
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_DROP_VIEW])
New Row Inserted
Triggered when a new row is inserted into a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_NEW_ROW])
Row Updated
Triggered when a row is updated in a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_ROW_UPDATED])
Row Deleted
Triggered when a row is deleted from a specified table
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_ROW_DELETED])
Table Created
Triggered when a new table is created in the database
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_TABLE_CREATED])
Table Dropped
Triggered when a table is dropped from the database
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_TABLE_DROPPED])
Database Created
Triggered when a new database is created
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_DATABASE_CREATED])
Database Dropped
Triggered when a database is dropped
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_DATABASE_DROPPED])
User Created
Triggered when a new MySQL user is created
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_USER_CREATED])
User Dropped
Triggered when a MySQL user is dropped
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_USER_DROPPED])
Query Executed
Triggered when a specific query is executed
from composio_llamaindex import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MYSQL_TRIGGER_QUERY_EXECUTED])