Returns the structure of a specific table, including column names, data types, and nullability. Accepts table names in format 'schema.table' or just 'table' (defaults to public schema).

Returns the top 10 partners that have appeared on the YER (Yield Enhancement Report) most frequently in the last 6 months. Includes partner ID, name, and report count. Predefined natural language pattern query.

Returns the source tags used by a specific partner. Accepts partner name as parameter. Predefined natural language pattern query.

Returns the traffic sources (source tags) used by a specific partner in the last month, including search and click metrics and traffic quality. Accepts partner name as parameter. Predefined natural language pattern query.

Execute a SQL query or natural language question against the database. Handles special commands like 'show tables' and 'describe table', as well as predefined natural language patterns for common partner and YER data queries. Returns results in tabular format with columns and rows.

Returns a list of all tables in the database, excluding system schemas (pg_catalog, information_schema). Results include table_schema and table_name columns.

Returns the top 10 source tags that improved in traffic quality (TQ) in the last month compared to the previous month. Includes current TQ, previous TQ, and change delta. Predefined natural language pattern query.