Get the current database schema showing all loaded tables and their structure

List all currently loaded tables with their source CSV files

Load all CSV files from a folder into a temporary SQLite database.

Args: folder_path: Path to folder containing CSV files table_prefix: Optional prefix for table names

Returns: Status message with details of loaded files

Execute any SQL query on the loaded database.

Args: query: Any SQL query to execute (SELECT, INSERT, UPDATE, DELETE, CREATE, etc.) limit: Maximum number of rows to return for SELECT queries (default: 100)

Returns: Query results formatted as XML or execution status

Get detailed information about a specific table.

Args: table_name: Name of the table to inspect

Returns: Detailed table information including schema and sample data

Create an index on a table column for better query performance.

Args: table_name: Name of the table column_name: Name of the column to index index_name: Optional custom index name

Returns: Status message

Create a backup of the current database to a file.

Args: backup_path: Path where to save the backup file

Returns: Status message

Export a table to a CSV file.

Args: table_name: Name of the table to export output_path: Path for the output CSV file include_header: Whether to include column headers

Returns: Status message

Get the execution plan for a query to understand performance.

Args: query: SQL query to analyze

Returns: Query execution plan

Clear the temporary database and remove all loaded tables.

Returns: Status message

Get statistical summary for a specific column.

Args: table_name: Name of the table column_name: Name of the column to analyze

Returns: Statistical summary including count, nulls, unique values, and distribution info

Find duplicate rows in a table.

Args: table_name: Name of the table to check columns: Comma-separated column names to check for duplicates, or "all" for all columns

Returns: Information about duplicate rows found

Analyze missing data patterns in a table.

Args: table_name: Name of the table to analyze

Returns: Summary of missing data patterns across all columns

Get a comprehensive summary of the table data.

Args: table_name: Name of the table to summarize

Returns: Quick overview with key insights about the data