Connect to a MySQL database. If not called explicitly, will use environment variables for connection.

Execute a SELECT query and return results. Use this for reading data.

Execute an INSERT, UPDATE, DELETE or other modifying query. Returns affected rows count.

List all databases on the MySQL server

List all tables in the current or specified database

Get the structure/schema of a table

Create a new table with specified columns

Modify an existing table structure

Drop/delete a table

Create a new database

Drop/delete a database

Switch to a different database

Create an index on a table

Drop an index from a table

Check database connection health and get server status