List all tables and views in the warehouse with their row counts. Use this first to discover what data is available.

Return the column names and data types for a given table or view. Use this to learn the schema before writing a query.

Execute a read-only SELECT/WITH SQL query against the DuckDB warehouse and return the rows. Tables live in the 'main' schema (e.g. dms_customer, dms_contract, dms_contact_note, los_loan_app). A LIMIT is applied automatically if you omit one. Use ? placeholders with the params array for values.

Search customers by (partial) first name, last name, or customer id. Returns matching customers with their internal oid — pass that oid (or the name) to customer_insights.

Given a customer name or id, return a consolidated insight profile: identity, all contracts, delinquency/NPL summary, outstanding & overdue balances, recent collection contact notes, and loan applications. This is the tool for requests like 'get the insights of the customer Max'.