List all databases in the MySQL server.

Returns: str: A formatted string containing all database names, one per line

List all tables in the current database.

Returns: str: A formatted string containing all table names, one per line

List all views in the current database.

Returns: str: A formatted string containing all view names, one per line

Search for tables and views matching a pattern.

Args: pattern (str): Search text or wildcard expression

Returns: str: Matching table and view names, one per line

List columns for a given table.

Args: table_name (str): Table name to inspect

Returns: str: Column names and types for the table

Get the schema information for a specific table.

Args: table_name (str): Name of the table to get schema for

Returns: str: A formatted string containing the table schema information Each column's information is on a new line

Raises: Error: If the table doesn't exist or schema retrieval fails

Get index information for a specific table.

Args: table_name (str): Table name to inspect

Returns: str: Index metadata for the table

Get the CREATE TABLE statement for a specific table.

Args: table_name (str): Table name to inspect

Returns: str: The DDL statement used to create the table

Get the approximate row count for a table.

Args: table_name (str): Table name to inspect

Returns: str: Row count information

Execute a SQL query and return the results as a formatted string.

Args: query (str): The SQL query to execute

Returns: str: A formatted string representation of the query results Each row is on a new line, with columns separated by tabs

Raises: Error: If the query execution fails